How to show hidden Quick Access Toolbar in Excel
Quick Access Toolbar (Excel) is also known as the quick access toolbar in Excel. It, provides quick customizations to common command buttons that users frequently use. In Excel's interface, the default location of the Quick Access Toolbar is in the top left corner. This bar can be moved, hidden and shown as you wish.
How to show hidden Quick Access Toolbar in Excel Picture 1
Note: The Ribbon is the main toolbar and the Quick Access Toolbar is a small toolbar containing commands that users frequently use. Using Quick Access Toolbar, you do not need to switch between tabs on the Ribbon.
The Quick Access Toolbar is currently hidden in Excel
How to show Quick Access Toolbar Excel is very simple, less than 3 seconds.
- Click File in the Ribbon > Options > When the Options window appears, select ' Quick Access Toolbar ' (left column).
- Move your mouse to ' Show Quick Access Toolbar below the Ribbon ' and uncheck this item.
- Click ' OK '.
How to show hidden Quick Access Toolbar in Excel Picture 3
Immediately, the Quick Access Toolbar will appear again in its default state.
Hide the quick access toolbar in Excel
Quickly use the mouse to hide the Quick Access Toolbar.
=> First select the Quick Access Toolbar in Excel. In the drop-down list, select ' Show below the Ribbon '.
Immediately the Quick Access Toolbar is hidden in Excel.
How to show hidden Quick Access Toolbar in Excel Picture 5
Ways to adjust Quick Access Toolbar you need to know
In modern calculations, fast operations are extremely necessary. If you grasp the Quick Access Toolbar, your work will be more convenient and easier. Here are a few important instructions for you to grasp that.
Add command button to Quick Access Toolbar
Method 1: Add command buttons on the Ribbon
- Find the command button you need to add on the Ribbon.
- Go to the location of the command button and Right-click on the icon of the command button to add. Then select: 'Add to Quick Access Toolbar'.
How to show hidden Quick Access Toolbar in Excel Picture 7
Method 2: Add a command button that is not available in the Ribbon.
- Click the Quick Access Toolbar's down arrow.
- Select 'More Commands'…
- Find and select the command buttons needed for your Quick Access Toolbar.
How to show hidden Quick Access Toolbar in Excel Picture 9
Delete and move command buttons for Quick Access Toolbar
For simplicity, you can remove command buttons from the Quick Access Toolbar when you don't need to use them too much. At the same time, you can move the position of the buttons to make them more eye-catching.
How to delete : Click on the command button on the bar and select Remove from Quick Access Toolbar.
How to show hidden Quick Access Toolbar in Excel Picture 11
Change command button position:
- Open Quick Access Toolbar options: File > Options > Quick Access Toolbar.
- In the Customize option box, select the command button you want to move > press the up or down arrow until it reaches the desired position. (Follow the picture).
How to show hidden Quick Access Toolbar in Excel Picture 13
(*) If you want to group command buttons, add them between command groups! [Choose command from: Popular Commands/ /Add/press arrow to move position].
Return Quick Access Toolbar to its original state
There are times when the Quick Access Toolbar is hidden in Excel due to too much manipulation by someone. So you can return it to its original state to rearrange.
Select the Reset button and select 'Reset only Quick Access Toolbar'.
Everything will be returned to its original state for you to begin other customizations.
How to show hidden Quick Access Toolbar in Excel Picture 15
There are also many ways for you to add special function keys such as adding Macros. Because the way to add it is quite complicated and lengthy, see you in another article. The instructions will be more detailed.
I hope the information on how to display the Quick Access Toolbar will be useful to you. Leave a comment if you need further support!
You should read it
- Get started with Excel for beginners
- Tips for adding in Excel you need to know
- How to fix the SUM function doesn't add up in Excel
- Guidance on how to align Excel correctly
- How to keep Excel and Excel columns fixed?
- What is ### error in Excel? how to fix ### error in Excel
- How to display 0 in front of a number in Excel
- Instructions for searching and replacing in Excel tables
- MS Excel 2007 - Lesson 2: Customizing in Excel
- 3 ways down the line in Excel, line break, down row in 1 Excel cell
- Shortcut guide, abbreviated in Excel
- Microsoft Excel test P5
May be interested
How to turn off notifications when showing PowerPoint presentation slides to not reveal personal information
How to change slide background in PowerPoint
Inserting Word files into Google Sheets is simple that you may not know
Here is a quick and effective way to fix the error of Excel screen being split in half
3 simple ways to convert Excel files to Word that you should know
How to convert handwriting to text in Excel