Excel 2016 All-in-One For Dummies. Harvey Greg
Читать онлайн книгу.
add any additional groups of commands to be included on the new custom tab, simply repeat Step 6. Use the Move Up and Move Down buttons if you need to reposition any groups on the custom tab.
7. Rename the custom tab by clicking the New Tab (Custom) in the Customize the Ribbon list box. Then, click Rename button and type the name for the tab in the Display Name text box of the Rename dialog box before you click OK.
To add additional custom tabs to the Ribbon, repeat Steps 2 through 7. After you finish all your custom tabs to the Ribbon, you’re ready to close the Excel Options dialog box and return to the worksheet.
8. Click the OK button in the Excel Options dialog box.
When Excel closes this dialog box and returns you to the worksheet, the new custom tab appears in the Ribbon at the position where you placed it.
Figure 2-10: Adding forgotten Excel commands to a custom group on a brand new Ribbon tab.
Figure 2-11 shows you the Excel Ribbon on my computer after I added a Miscellaneous tab between the Review and View tab. As you can see, when this new tab is selected, it contains three custom groups: Old Friends (Custom) with AutoFormat, Form, and Print Preview Full Screen; Text to Speech (Custom) with the Speak Cells, Stop Speaking, and On Enter buttons; and Web (Custom) with its Web Page Preview button.
Figure 2-11: Excel Ribbon after selecting a Miscellaneous tab with its command buttons clustered in three custom groups.
Using Office Add-ins
Excel 2016 supports the use of Office Add-ins to help you build your worksheets. Office Add-ins are small application programs that run within specific Office 2016 programs, such as Excel, and increase particular functionality to promote greater productivity.
There are Office Add-ins to help you learn about Excel’s features, look up words in the Merriam-Webster dictionary, and even enter dates into your spreadsheet by selecting them on a calendar. Many of the Office Add-ins for Excel 2016 are available free of charge, whereas others are offered for a trial period after which you may purchase them from the Office Store for a small price.
To use any of these Office Add-ins in Excel 2016, you first need to install them by following these steps:
1. Select the My Add-ins option on the Add-ins button on the Insert tab of the Ribbon; then, click the See All option on the drop-down menu (or press Alt+NZ1APS).
Excel opens the Office dialog Add-ins box containing the My Add-ins and Store buttons, along with thumbnails of all the Office Add-ins already installed and ready to insert into the current Excel workbook (see Figure 2-12).
2. To install new Office Add-ins, click the Store button in the Office Add-ins dialog box.
Excel connects to the Office Store, and your Office Add-ins dialog box displays thumbnails of available add-ins for Excel. These thumbnails are organized by particular categories ranging from Get Work Done with Office to Discover Great Reference Content in the main area of the dialog box. In addition, you see the names of general categories, ranging from All down to Visualization that you can select in a column on the left side of the dialog box.
3. To display more Office Add-ins in a particular category, such as Visualize Information in New Ways or Editor’s Picks, click its See More link; to see Office Add-ins in other general categories, such as CRM or Data Analytics, click its link in the Category list to the left.
4. When you find an add-in that you may want to install in any one of the categories, click its thumbnail.
The Office Add-in dialog box displays information about the Office Add-in you selected, including the name of the add-in’s creator, its rating, how it works with your Excel data, and whether or not it can send data over the Internet.
5. To install the add-in, click the Trust It button; to return to the list of suggested add-ins in the Office Add-ins Store, click Cancel.
Once you click the Trust It button for a free Office Add-in, Excel closes the Office Add-ins dialog box and downloads the add-in in the current worksheet for you to use. It also adds the Office add-in to the list of installed Office Add-ins on the My Add-ins tab of the Office Add-ins dialog box.
Figure 2-12: Inserting the Mini Calendar and Date Picker Office app into an Excel worksheet.
Once installed, you can then insert the Office Add-in you want to use into any open worksheet. To do this, follow these steps:
1. If the Office Add-ins dialog box is not currently open in Excel, open it by clicking Insert ⇒ Add-ins ⇒ My Add-ins ⇒ See All or press Alt+NZ1APS.
Excel displays all the Office Add-ins currently installed in Excel 2016 in the My Add-ins tab of the Office Add-ins dialog box.
2. Click the Office Add-in you want to use in your worksheet to select it and then click the Insert button or press Enter.
Excel then inserts the Office Add-in into your current worksheet so that you can start using its features.
Some Office Add-ins, such as Merriam-Webster Dictionary and QuickHelp Starter, open in task panes docked on the right side of the worksheet window. Others, such as Bing Maps and the Mini Calendar and Date Picker, open as graphic objects that float above the worksheet.
To close Office Add-ins that open in docked task panes, you simply click the pane’s Close button. To close Office Add-ins that open as floating graphic objects, you need to select the graphic and then press the Delete key (don’t worry – doing this only closes the app without uninstalling it).
Note that after you start using various Office Add-ins in Excel, they’re added to the Recently Used Add-ins section of the My Add-ins button’s drop-down menu. You can then quickly re-open any closed Office add-in that appears on this menu simply by clicking it.
Using Excel’s Own Add-Ins
Office Add-ins aren’t the only ones that you can use to extend Excel’s built-in features in some way. You can also use built-in add-ins created by Microsoft or third-party Excel add-ins that you can purchase from a wide variety of vendors. Before you can use any Excel add-in program, the add-in must be installed in the proper folder on your hard drive, and then you must select the add-in in the Add-Ins dialog box.
There are two different types of Excel add-in programs immediately available that you can use to extend the features in Excel 2016:
✔ Excel Add-ins: This group of add-ins (also known as automation add-ins) is designed to extend the data analysis capabilities of Excel. These include Analysis ToolPak, Euro Currency Tools, and Solver.
✔ COM