To add a command to the Quick Access toolbar, follow these steps:
Click File Options Quick Access Toolbar. In the Choose commands from list, click Macros. Select the macro you want to assign a button to. Click Add to move the macro to the list of buttons on the Quick Access Toolbar. The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab on the ribbon that is currently displayed. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.
Full Quick Access Toolbar Support For Office For Mac Windows 7
1. In the right of the Quick Access toolbar, click the tinyarrow button to open the drop-down menu:
By checking the commands on this menu, you can add their icons to the Quick Access toolbar.The trouble is, the commands show that the two commands you want to add isn't even on the menu, so:
2. Near the bottom of the menu, click More Commands....
The Excel Options dialog box opens, showing the Quick Access Toolbar options. The list boxon the right shows the commands that are currently shown on the Quick Access toolbar. The box onthe left contains commands that you can add to the Quick Access toolbar.
The Choose commands from drop-down menu above the left box shows Popular Commands.Evidently, the Switch Windows and AutoSum commands aren't popular enough to make the cut,because they aren't on the list. Fortunately, you can use the Choose commands from menu todisplay more commands.
3. From the Choose commands from drop-down menu, choose AllCommands.
The All Commands list is pretty lengthy, giving you an idea of just how many different commandsExcel has to offer. That's why the Choose commands from menu also lets you narrow down yourchoices by choosing commands from specific ribbon tabs. (The major tabs are listed closer to the top,and the submenu tabs, like those for chart tools and table tools, are listed near the bottom).
4. Scroll down the All Commands list to select AutoSum,and then click the Add button between the two list boxes to add the command to the box with theQuick Access toolbar commands.
You can use the Add button to add a command to the Quick Access toolbar list, or you canjust double-click a command.
5. Scroll down to select Switch Windows, and then double-clickto add the command to the Quick Access toolbar box.
Press S to jump down to the commands that begin with S. That makes it a shorter scroll toget to the Switch Windows command. Now that you've filled the list with your desired commands,it's time to arrange them to your liking.
6. In the Customize Quick Access toolbar list box, select acommand and then use the up and down arrow buttons on the right to arrange them in an order that worksbest for you.
To make it easier to find new commands, you can add one or two separators described in the previoustip. For example, you may want to group the related Save, Undo, and Redo commandstogether:
7. Click OK to close the Excel Options box and admireyour newly configured Quick Access toolbar:
For even greater time savings, you can use keyboard shortcuts to run the commands on the QuickAccess toolbar. The commands are numbered from left to right, so, you can choose themwith the Alt key and the number:
Note: You can add a command to the Quick Access toolbar from the ribbon byright-clicking the button and choosing Add to Quick Access Toolbar:
See also this tip in French:Comment ajouter des commandes à la barre d'outils Accès rapide dans Excel.
To add a command to the Quick Access toolbar, follow this steps:
1. To the right of the Quick Access toolbar, click the tiny arrowbutton to open the drop-down menu:
By checking the commands on this menu, you can add their icons to the Quick Access toolbar.The trouble is, the commands shows that the two commands you want to add isn't even on the menu, so:
2. Near the bottom of the menu, click More Commands....
The Word Options dialog box opens, showing the Quick Access Toolbar options. The list boxon the right shows the commands that are currently shown on the Quick Access toolbar. The box onthe left contains commands that you can add to the Quick Access toolbar.
The Choose commands from drop-down menu above the left box shows Popular Commands.Evidently, the Switch Windows and AutoText commands aren't popular enough to make the cut,because they aren't on the list. Fortunately, you can use the Choose commands from menu todisplay more commands.
3. From the Choose commands from drop-down menu, choose AllCommands.
The All Commands list is pretty lengthy, giving you an idea of just how many different commandsWord has to offer. That's why the Choose commands from menu also lets you narrow down yourchoices by choosing commands from specific ribbon tabs (The major tabs are listed closer to the top,and the submenu tabs, like those for chart tools and table tools, are listed near the bottom).
4. Scroll down the All Commands list to select AutoText,and then click the Add button between the two list boxes to add the command to the box with theQuick Access toolbar commands.
You can use the Add button to add a command to the Quick Access toolbar list, or you canjust double-click a command.
5. Scroll down to select Switch Windows, and then double-click toadd the command to the Quick Access toolbar box.
Full Quick Access Toolbar Support For Office For Mac Windows 10
Press S to jump down to the commands that begin with S. That makes it a shorter scroll toget to the Switch Windows command. Now that you've filled the list with your desired commands,it's time to arrange them to your liking.
6. In the Customize Quick Access toolbar list box, select acommand, and then use the up and down arrow buttons on the right to arrange them in an order that worksbest for you.
To make it easier to find a new commands, you can add one or two separators described in the previoustip. For example, you may want to group the related Save, Undo, and Redo commandstogether:
7. Click OK to close the Word Options box and admire yournewly configured Quick Access toolbar.
For even greater time savings, you can use keyboard shortcuts to run the commands on the QuickAccess toolbar. The commands are numbered from left to right, so, you can choose themwith the Alt key and the number:
Note: You can add a command to the Quick Access toolbar from the ribbon byright-clicking the button and choosing Add to Quick Access Toolbar:
See also this tip in French:Comment ajouter des commandes à la barre d'outils Accès rapide dans Word.