3. Customizing Excel

The Excel Options dialog offers dozens of changes you can make in Excel. This chapter walks you through examples of customizing the ribbon and discusses some of the important option settings available in Excel.

Performing a Simple Ribbon Modification

Suppose that you generally like the ribbon but there is one icon that seems to be missing. You can add icons to the ribbon to make it customized to your preference. If you feel the Data tab would be perfect with the addition of a pivot table icon, you can add it (see Figure 3.1).

Image

Figure 3.1 Decide where the new command should go on the ribbon.

To add the pivot table command ...

Get Excel 2016 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.