In Microsoft Office Excel 2010, you can also customize the tabs, groups, and individual commands of the Ribbon. By default, Excel 2010 workbooks are saved in the Microsoft Office Open XML format and have the extension .xlsx (or .xlsm for macro-enabled workbooks). This is important to remember, since customizing the Excel 2010 Ribbon window makes use of XML language knowledge.
It should be noted that Excel 2010 introduced a convenient interface that allows users to customize the Ribbon directly.
Later in this chapter, we will discuss the possibilities of programmatically customizing the Ribbon. However, let us first look at the customization options available through the user interface: it is likely that when developing your user interface, part of the work will be done this way, while the necessary procedures will be written in VBA.
So, to quickly customize the Ribbon, follow these steps:
- Go to the File tab and click Options.
- In the opened Excel Options window, select the Customize Ribbon category in the navigation pane.
- Using the tools provided by the Excel Options user interface, you can: create a new tab, delete or modify an existing one, including adding/removing groups and commands.
