Quick Access Toolbar Posts

Quick Access Toolbar
Quick Access Toolbar Customization Menu
Quick Access Toolbar Customization Tab

Quick Access Tooblar Customization Tab

Category Selection Box

Users can select from many different commands categories. To select which type of category of commands you display in the Available Commands Window simply select the chosen category from the Category Selection Box. Some of the categories available to choose from are Popular Commands, Commands not in Ribbon and Macros.  Users can also select from a variety of different tabs.

Available Commands Window

This window will display the commands from the category chosen within the Category Selection Box. It is important to note that if you choose to select the Not in Ribbon category or any one of the specific tabs that the list of commands may change based on what Is displayed on your ribbon or tabs.

Document Selection Box

The Document Selection Box can be used to determine if you are going to customize a specific workbook or all documents of Excel.  If you choose All Documents then anytime you open Excel on your computer you will see that same command still on your Quick Access Toolbar.  If you only choose a specific workbook then you will not see that command on any other workbook within Excel.

Selected Commands Window

This window lists which commands are currently displayed on the Quick Access Toolbar.  The top command shown within this list will be the command displayed furthest to the left on the Quick Access Toolbar. The higher up the rest of the commands the further left that command will be displayed on the Quick Access Toolbar.  For example if you want a command displayed all the way to the right of the Quick Access Toolbar then you want to have it at the bottom of the Selected Commands Window.

Add Command Button

This button adds commands to Selected Commands Window.  To perform this function simply select the command you want from the list of available commands and select Add.  If you double click on one of the available commands you will also add the command.

Remove Command Button

This button removes commands from the Selected Commands Window. To remove a command select the command you want to remove from the Selected Commands Window and select remove.  Users can also double click on the command you want to remove.

Reorder Command Buttons

There are two command buttons located on the right side of the Selected Commands Window.  One points upwards. One points downward. This allows you to move commands within the Selected Commands Window up or down, in order to readjust the commands left or right on the Quick Access Toolbar.

Quick Access Toolbar Customization Menu

Introduction
The Quick Access Toolbar Customization Menu allows users to add or remove commands to the Quick Access Toolbar, Open the Quick Access Toolbar Customization Tab or show the Quick Access Toolbar above or below the Ribbon.

Adding Commands

To add commands using the Quick Access Toolbar Customization Menu check the checkbox of the preset command located on the Quick Access Toolbar Customization Menu.

Removing Commands

To remove commands from the Quick Access Toolbar using the Quick Access Toolbar Customization Menu uncheck the command’s checkbox.

Opening the Quick Access Toolbar Customization Tab

The Quick Access Toolbar Customization Tab allows users to add all the commands in Excel instead of just the preset commands shown on the Quick Access Toolbar Customization Menu. To open the Quick Access Toolbar Customization Tab select More Commands.

Show Above the Ribbon

The Show Above the Ribbon command will move the Quick Access Toolbar above the Ribbon.

Show Below the Ribbon

The Show Below the Ribbon command will move the Quick Access Toolbar below the Ribbon.

Quick Access Toolbar

Introduciton:The Quick Access Toolbar is customizable menu where users can display commonly used commands for quick access.  The commands Save, Undo and Repeat are generally defaulted to the toolbar. The toolbar can be located in two places.

Adding Commands:

To add commands to the toolbar users can selected a command from the Quick Access Toolbar Customization Menu or the Quick Access Toolbar Customization Tab.

Removing Commands:

To remove command from the toolbar user can simply right click on the command and select Remove from Quick Access Toolbar.

Display Above Ribbon:
If the toolbar is actively displayed above the ribbon users can select to display the toolbar below the ribbon by right clicking the toolbar and selecting Show Quick Access Toolbar Below the Ribbon.

Display Below Ribbon:
If the toolbar is actively displayed below the ribbon users can select to display the toolbar above the ribbon by right clicking the toolbar and selecting Show Quick Access Toolbar Above the Ribbon.