Chapter 3
Customizing Excel
Performing a simple ribbon modification
Sharing customizations with others
Questions about ribbon customization
Using the Excel Options dialog box
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.