Customizing Excel
- By Bill Jelen
- 5/20/2022
- 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
Questions about ribbon customization
Can the customizations apply only to a certain workbook?
No. The Customize the Ribbon command in Excel applies to all workbooks.
Can I reset my customizations and go back to the original ribbon?
Right-click the ribbon and select Customize The Ribbon. Below the right list box, select Reset > Reset All Customizations.
How can I get complete control over the ribbon?
Learn RibbonX and write some VBA to build your own ribbon.
For more information on building your own ribbon, see RibbonX: Customizing the Office 2007 Ribbon, by Robert Martin, Ken Puls, and Teresa Hennig (Wiley, ISBN 0470191112).
These ribbon customizations are really lacking. Is there another option that doesn’t require me to write a program?
Yes, some third-party ribbon customization programs are available. For example, check out a free one from Excel MVP Andy Pope at https://andypope.info/vba/ribboneditor_2010.htm.