Chapter 3Customizing Excel

The Excel Options dialog box 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 ...

Get Microsoft Excel 2019 Inside Out 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.