Chapter 3

Customizing Excel

Performing a simple ribbon modification

Adding a new ribbon tab

Sharing customizations with others

Questions about ribbon customization

Using the Excel Options dialog box

Options to consider

Five Excel oddities

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

Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) 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.