How much extra time do you spend clicking back and forth between the tabs on the ribbon in Excel? Are there things you do often enough that having a simple shortcut to them would be a huge time saver? For example, remember the previous Excel Tips for freezing panes, grouping (rather than hiding), and using the Format Painter? All of these and more can be added to the Quick Access Toolbar in Excel, giving you almost instant access to the features you use on a routine basis. Here's how.
- Start by clicking on the drop-down arrow next to the Quick Access Toolbar (this might be above the ribbon on your screen; if you want to move it, select the last option on the menu to display it above or below the ribbon).
- Check the items that you want to show on the Quick Access Toolbar.
- Select the 'More Commands...' option to add or remove commands from the list.
- When you select 'More Commands…', the Excel Options dialog box appears with the 'Quick Access Toolbar' category selected on the left. (You can also get to the Excel Options dialog box from the File menu by selecting 'Options' > 'Quick Access Toolbar'.)
- From here, you can filter to choose commands from Popular Commands, Commands Not in the Ribbon, All Commands, or by a specific tab in the ribbon.
- Once you've chosen the command you'd like to add to the Quick Access Toolbar, just click the Add >> button. Once your commands are listed on the right-hand side, you can rearrange the order by selecting the up or down arrow buttons.
- When you are finished, click the OK button.
Now your Quick Access Toolbar will contain the commands you want in the order you want them; no more fumbling around for what you need!
Leave us a comment and let readers know what Excel tips you use on a daily basis.