Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
Quick Access Toolbar or also known as QAT in excel is a toolbar available in excel where we can position our important shortcuts in excel and use them much easier whenever necessary, this is a customizable toolbar located on the upper left-hand side of the window in a workbook.
Quick Access Toolbar (Table of Contents)
What is the Quick Access Toolbar (QAT) in Excel?
Quick Access Toolbar in excel is a customizable toolbar which contains a set of commands that visible at the top of the ribbon which is independent. You can add or remove the buttons with your choice by customizing the toolbar but you are not able to resize it. You can move the toolbar to two possible locations one is at the top of the ribbon other one is at the top of the workspace area. With your choice, you can create the custom tabs and groups to choose your frequent and repeated usage commands.
How to use Quick Access Toolbar in Excel?
- QAT in excel is a shortcut tool to avoid searching for the commands you frequently use in working on the documents.
- If you have mistaken in the typing the word or made any other errors while making the document you don’t need to search the undo tool which is available at this toolbar just click on it at the top.
- It helps us to simplify accessing the commands of the document.
Example #1 – Customizing the Quick Access Toolbar Excel
On the ribbon, click the appropriate tab or group to display the command that you want to add in the toolbar.
- Choose the left click command, on the excel quick access toolbar short cut menu, Customize QAT to more commands like open, save, undo, redo, etc. by clicking the left click on the commands.
- If the command already available in the toolbar in Excel, it shows a tick mark at the left of the tab, you can remove the command if you don’t need it.
- If you want to add more commands that not displayed in the list don’t worry click on More commands button visible at the bottom of the tab to add or remove the commands.
- If you choose More commands tab then the screen will display as below.
- If you select the choose commands from Drop menu then you can choose the menus you want to add, by default it shows the popular commands mostly recommended by the users.
- You can select the reference tabs in case if it is difficult to find out the commands search for.
- To add or remove the tools in the toolbar first select the command by left click on which you have to insert which displays at the left side window then select Add>> then the selected command will displays in the right side window then click ok to finish the customizing process once you completed.
- If you have to reset all customizations you have done select the Reset icon then select ok to customize the toolbar to default.
- You can choose the customizations for a single workbook too if you don’t want other files to perform the customizations you choose then select the Customize access tool bars drop down menu then select for XXXX (filename) as shown below.
Example #2 – Changing the Position of the Quick Access Excel Toolbar
- You can only place the toolbar in two positions one is at the top of the ribbon and the other is at the top of the workspace area.
- You cant resize the toolbar but the other option to resize the toolbar is by changing the resolution of your screen.
Explanation of Changing the Position of Quick Access Excel Toolbar
- To replace the toolbars position right click at the drop-down icon and select show below the ribbon to replace as shown below.
- Then the position of the Toolbar will change as below.
- If you want to replace to its default position do the same again this time it shows as shown above the ribbon.
Example #3 – Customizing the toolbar by Options Command
- Click the file tab and then click options to customize the toolbar in excel
- Then click Quick access excel toolbar, then make the changes you want as you wish to ease of access on the commands.
Example #4 – Changing the Order of the Commands
- Choose the left click command, on the QAT short cut menu then click more commands to Customize Quick access excel toolbar.
- Then click toolbar on the menu to replace the position of the commands to ease of access.
- Under the Customize Quick Access excel toolbar, click the command you want to move, then click the move up or move down
- Then click ok to see the customizations on your screen.
Example #5 – Export a Customized Quick Access Toolbar in Excel
You can export your ribbon and toolbars customizations into a file that can be imported and used by a team member on another PC.
Explanation of Export a customized Quick Access Excel Toolbar
- Click the file tab under help, Click options then click Quick access excel toolbar, then click import/export, and then click Export all customizations.
- Then share the exported file to the user who wants to perform the customizations.
Things to Remember
- You can add the multiple commands in this toolbar but remind that it is a shortcut tool for simplifying the job so don’t choose the list of commands which you use in long intervals which makes uncomfortable during searching the command you frequently
- Use regular usage commands to display in the same icons which makes easy to retrieve the command while using a file.
This has been a guide to Quick Access Toolbar in Excel. Here we discuss how to customize Quick Access Excel Toolbar, change positions, change command order and also how to export the toolbar. You may learn more about excel from the following articles –