Search

How to group Commands on Excel Quick Access Toolbar by adding Separator

Adding too many commands to Excel Quick Access Toolbar (QAT) can clutter it. It will become difficult to find the required command from Excel Quick Access Toolbar (QAT). You can group the commands on Excel Quick Access Toolbar (QT) by adding a separator between commands based on functionality.

To add a separator between commands in Excel Quick Access Toolbar (QAT), follow these steps.

Step 1 : Click "Customize Quick Access Toolbar" drop-down menu button located in Quick Access Toolbar (QAT) as shown below.

Step 2 - Open "Excel Options" window's Quick Access Toolbar panel by clicking the "More Commands".

"Excel Options" window can be opened by following methods also.

• Click the "File" tab in Excel Ribbon and then click "Options". Select "Quick Access Toolbar" Panel.

Or

• Right-click anywhere on the Ribbon. Click "Customize Quick Access Toolbar".

Customize Excel Quick Access Toolbar - QAT

Step 3 - Select <Separator> from left-side list and then click "Add" to add it to right-side list.

Add separator to Excel Quick Access Toolbar 01

Step 4 - Click "Up" or "Down" arrow buttons to adjust the separator's position on Excel Quick Access Toolbar (QAT) and then click "OK".

Add separator to Excel Quick Access Toolbar 02

Step 5 - You can see the separator added on. Excel Quick Access Toolbar (QAT) as shown below.

Separator to Excel Quick Access Toolbar

 

Related Tutorials
• Excel Ribbon explained in detail
• Excel Quick Access Toolbar (QAT)
• How to customize Excel Quick Access Toolbar (QAT)
• How to change the default location of Excel Quick Access Toolbar (QAT)
• How to Add or Remove a Command to Excel Quick Access Toolbar (QAT) quickly
• How to Add a Command which is not in Ribbon to Excel Quick Access Toolbar (QAT)
• How to add a Macro to Excel Quick Access Toolbar (QAT)
• How to change default Macro button icon in Excel Quick Access Toolbar
• How to change the position of commands on Excel Quick Access Toolbar (QAT)
• How to reset Excel Quick Access Toolbar (QAT) Customizations
• How to Import/Export Excel Quick Access Toolbar (QAT) Customizations
• Excel Formula Bar explained in detail
• Excel Status Bar in brief
• Excel Status Bar explained in detail
• Excel Backstage View
• Excel Options Dialog Box Window