Quick Access Toolbar in Excel

Question

How to add commands to the Quick Access Toolbar in Excel?

Answer

If you often use commands that are not as quickly available as you would like, you can easily add them to the Quick Access Toolbar, which is above the Ribbon when you first start Excel. On that toolbar, commands are always visible and near at hand.  

For example, if you use AutoFilter every day, and you don't want to have to click the Data tab to access the Filter command each time, you can add Filter to the Quick Access Toolbar.

To do that, click on the Dropdown icon, and then click More Commands and select icons to Add to Quick Access. 

To remove a button from that toolbar, right-click the button on the toolbar, and then click Remove from Quick Access Toolbar.

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

 

 

CTL Support Request

Details

Article ID: 7864
Created
Thu 12/22/22 10:47 AM
Modified
Fri 11/3/23 3:33 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.