add a Ribbon command, simply right-click its command button on the Ribbon and then choose Add to Quick Access Toolbar from its shortcut menu. Excel immediately adds the command button to the very end of the Quick Access toolbar, immediately in front of the Customize Quick Access Toolbar button.
If you want to move the command button to a new location on the Quick Access toolbar or group it with other buttons on the toolbar, you need to click the Customize Quick Access Toolbar button and then choose More Commands from its drop-down menu.
Excel then opens the Excel Options dialog box with the Quick Access Toolbar tab selected (similar to the one shown in Figure 2-1). Here, Excel shows all the buttons currently added to the Quick Access toolbar in the order in which they appear from left to right on the toolbar corresponding to their top-down order in the list box on the right side of the dialog box.
Figure 2-1: Use the buttons on the Quick Access Toolbar tab of the Excel Options dialog box to customize the appearance of the Quick Access toolbar.
To reposition a particular button on the bar, click it in the list box on the right and then click either the Move Up button (the one with the black triangle pointing upward) or the Move Down button (the one with the black triangle pointing downward) until the button is promoted or demoted to the desired position on the toolbar.
You can also use the options on the Quick Access Toolbar tab of the Excel Options dialog box (refer to Figure 2-1) to add a button for any Excel command even if it’s not one of those displayed on the tabs of the Ribbon:
1. Select the type of command you want to add to the Quick Access toolbar from the Choose Commands From drop-down list box.
The types of commands include the default Popular Commands, Commands Not in the Ribbon, All Commands, and Macros, as well as each of the standard and contextual tabs that can appear on the Ribbon. To display only the commands not displayed on the Ribbon, select Commands Not in the Ribbon near the top of the drop-down list. To display a complete list of all the Excel commands, select All Commands near the bottom of the drop-down list.
2. Click the command option whose button you want to add to the Quick Access toolbar in the Choose Commands From list box on the left.
3. Click the Add button to add the command button to the bottom of the list box on the right.
4. (Optional) To reposition the newly added command button so that it’s not the last one on the toolbar, click the Move Up button until it’s in the desired position.
5. Click the OK button to close the Excel Options dialog box.
Although certain commands from earlier versions of Excel, such as Data ⇒ Form and Format ⇒ AutoFormat, did not make it to the Ribbon in Excel 2016, this does not mean that they were entirely eliminated from the program. The only way, however, to revive these commands is to add their command buttons to the Quick Access toolbar after selecting the Commands Not in the Ribbon category from the Choose Commands From drop-down list on the Customization tab of the Excel Options dialog box.
If you’ve created favorite macros (see Book VIII, Chapter 1) that you routinely use and want to be able to run directly from the Quick Access toolbar, select Macros from the Choose Commands From drop-down list box and then click the name of the macro to add in the Choose Commands From list box followed by the Add button.
Exercising Your Options
Each time you open a new workbook, Excel makes a whole bunch of assumptions about how you want the spreadsheet and chart information that you enter into it to appear onscreen and in print. These assumptions may or may not fit the way you work and the kinds of spreadsheets and charts you need to create.
In the following five sections, you get a quick rundown on how to change the most important default or preference settings in the Excel Options dialog box. This is the biggest dialog box in Excel, with a billion tabs (ten actually). From the Excel Options dialog box, you can see what things appear onscreen and how they appear, as well as when and how Excel 2016 calculates worksheets.
The General tab (shown in Figure 2-2) is the first tab in the Excel Options dialog box. This tab is automatically selected whenever you first open this dialog box by choosing File ⇒ Options or by pressing Alt+FT.
Figure 2-2: The General tab’s options enable you to change many universal Excel settings.
The options on the General tab are arranged into four groups: User Interface Options, When Creating New Workbooks, Personalize Your Copy of Microsoft Office, and Start Up Options.
The User Interface Options group contains the following check boxes and buttons:
✔ Show Mini Toolbar on Selection: Disables or reenables the display of the mini-toolbar, which contains essential formatting buttons from the Home tab, above a cell selection or other object’s shortcut menu when you right-click
