• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » Quick Access Toolbar
Next →
← Prev

Quick Access Toolbar

By Dinesh Thakur

There is an access panel at the top of the working document – an echo of the toolbars used in previous versions of Excel.

Quick Access Toolbar

By default, the panel contains only a few icons to save the document, undo or redo the action. Also, in the right part of the panel, there is a special label in the form of an arrow directed downward, clicking on, which leads to the display of a drop-down list of commands. These commands include the Place Under Ribbon instruction to move the Quick Access Toolbar to the area of the working document below the application’s Ribbon. In Fig below, this command is selected from the drop-down list.

ribbon is selected from the drop-down listAs a result, the Quick Access Toolbar drops “from heaven to earth” – it is displayed immediately below the Ribbon in a separate strip, reminiscent of the good old toolbar of earlier versions of Excel.

The quick access bar is located under the ribbonReturning the Quick Access Toolbar to its original location is easy enough. You should click on the label in the lower right corner of the panel and select the Place above the ribbon command from the drop-down list.

The command to move the Quick Access Toolbar above the Ribbon is selected from the drop-down list

The drop-down list in the initial part contains the names of the commands. You can display the icon for the corresponding command on the quick access panel by checking the box. The Other commands command is used to add icons to the quick access toolbar of those not presented in the list.

After selecting this command, the Excel Options dialog box opens, which is open in the Quick Access Toolbar section. In this case, the window looks like.
The main working area of the window consists of two lists. The left side displays the icons and command names available in Excel, and the right side contains a list of icons located on the Quick Access Toolbar. At the top of the left-hand list, there is a drop-down list Select commands from, in which you select a category or tab to which the commands belong, the icons of which are added to the quick access toolbar. The command for creating a new document New is selected in the left list, belonging to the category “File” tab. To add the corresponding icon to the quick access panel, click the Add button.

After the icon is added, it is displayed in the right list. The icon’s placement on the panel can be selected using the arrow buttons: clicking on each of the buttons leads to the relative movement of the selected icon one position up or down.

Customize Quick Access Toolbar command selected from the drop-down list

Dialog window Excel options to customize the quick access panel open in the section Quick Access Toolbar

Adding a New Document Icon to the Quick Access Toolbar

Selecting the position of an icon added to the Quick Access Toolbar

The figure shows a situation when a new icon will be placed on the quick access panel second from the left, immediately after the command’s icon to save the document.

After applying the new settings, the Quick Access Toolbar will look like the one shown in Fig.

The icon is added, the place on the panel is selected for it

Added a new document creation icon to the quick access toolbar

To remove a button from the quick access toolbar, go to the Excel Options window (you can also open it through the File tab), select the icon to be deleted in the right list and click the Delete button.

It is worth noting that at the bottom of the left list in the Excel Options window (section Quick Access Toolbar), there is an option Place the Quick Access Toolbar under the Ribbon by checking the box of which you can move the Quick Access Toolbar under the Ribbon. Also, changes made to the Quick Access Toolbar settings can be applied only within the current working document or used for all documents. The required mode is selected from the Customize Quick Access Toolbar drop-down list located at the top of the list of icons of the access toolbar. The reset button is used to restore the default settings of the Quick Access Toolbar, and the Change button is active if the toolbar has an icon for the command to run a macro for execution. Using this button, the utility for editing the corresponding icon is launched.

Removing an icon from the Quick Access Toolbar

You’ll also like:

  1. What is Access Method? Explain Different type of Access Methods
  2. What is Quick Sort in C
  3. Quick Sort in Java Example
  4. Access Time – What is disk access time?
  5. Access Protection in Packages
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2023. All Rights Reserved.