MS Office User

One of the cool new features of Microsoft Office 2010 is that the Options dialog now allows the user to quickly and easily customize the Ribbon Settings for any of the Office applications. This also means that enabling the Developer Ribbon in Microsoft Excel 2010 is slightly different than previous versions. To enable the Developer Ribbon in Microsoft Excel 2010, complete the following steps.

Step-by-Step

1. Open the Microsoft Excel from the Windows Start Menu.
2. Once Microsoft Excel 2010 has been opened, click on the File Tab on the Ribbon to open the Excel 2010 Backstage.


Figure 1 - Excel 2010 File Ribbon Tab

3. Once the Backstage is opened, click on the Options Button on the bottom left corner of the Excel 2010 window. This will open the Excel Options dialog


Figure 2 - The Excel 2010 Backstage Options Button

4. On the Excel Options dialog, click on the Customize Ribbon Tab on the Left Side of the Excel Options dialog. This will show the Customize Ribbon options on the right side of the dialog.


Figure 3 - The Excel 2010 Options Dialog Customize Ribbon Tab

5. Once the Customize Ribbon options are shown on the right side of the Excel Options dialog, Check the CheckBox next to the Developer item in the list. Once Developer item is Checked, click the OK Button on the dialog to Save the changes.


Figure 4 - The Excel Options Customize Ribbon Settings

6. You will be taken back to the Excel 2010 main window and the Developer Ribbon Tab will now be shown.


Figure 5 - The Excel 2010 Developer Ribbon Tab

Enabling the Developer Ribbon Tab in Microsoft Excel 2010 is really just that easy. And the beautiful thing is that the Excel Options dialog makes it extremely quick and easy to enable or disable any of the standard Excel Ribbon Tabs in Excel 2010!

Submitted By: Geoffrey L. Griffith – May 27th, 2011