Excel 2016 All-in-One For Dummies. Harvey Greg

Чтение книги онлайн.

       You can add separators to the toolbar to group related buttons. To do this, click the <Separator> selection in the list box on the left and then click the Add button twice to add two. Then, click the Move Up or Move Down button to position one of the two separators at the beginning of the group and the other at the end. Also keep in mind that you can always return the Quick Access toolbar to its default state with its three buttons (Save, Undo, and Redo) by selecting the Reset Only Quick Access Toolbar option from the Reset drop-down list.

       If you’ve added too many buttons to the Quick Access toolbar and can no longer read the workbook name, you can reposition it so that it appears beneath the Ribbon immediately on top of the Formula bar. To do this, click the Customize Quick Access Toolbar button at the end of the toolbar and then choose Show Below the Ribbon from the drop-down menu.

      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.

       Adding commands lost from earlier Excel versions to the Quick Access toolbar

      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.

       Excel 2016 then adds a custom macro command button to the end of the Quick Access toolbar whose generic icon displays the branching of a programming diagram. This means that if you add several favorite macros to the Quick Access toolbar, the only way to tell them apart is by their ScreenTips, each of which displays the location and name of the macro attached to the particular custom button when you highlight the button by passing the mouse pointer over it.

       Nothing discussed in the following five sections is critical to your being able to operate Excel. Just remember the Excel Options dialog box if you find yourself futzing with the same setting over and over again in most of the workbooks you create. In such a situation, it’s high time to get into the Excel Options dialog box and modify that setting so that you won’t waste any more time tinkering with the same setting in future workbooks.