MS Office User

How to Enable the Developer Ribbon in Microsoft Excel 2010

by on May.28, 2011, under Excel

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.
  3. Figure 1 - Excel 2010 File Ribbon Tab

    Figure 1 - Excel 2010 File Ribbon Tab

  4. 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
  5. Figure 2 - The Excel 2010 Backstage Options Button

    Figure 2 - The Excel 2010 Backstage Options Button

  6. 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.
  7. Figure 3 - The Excel 2010 Options Dialog Customize Ribbon Tab

    Figure 3 - The Excel 2010 Options Dialog Customize Ribbon Tab

  8. 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.
  9. Figure 4 - The Excel Options Customize Ribbon Settings

    Figure 4 - The Excel Options Customize Ribbon Settings

  10. You will be taken back to the Excel 2010 main window and the Developer Ribbon Tab will now be shown.
  11. Figure 5 - The Excel 2010 Developer Ribbon Tab

    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


Random Posts:

  1. Using the Graphics Manager to work with Images in Publisher 2007
  2. Connecting Microsoft Outlook 2007 to GoDaddy email with SSL
  3. Saving a Report as PDF with the Access 2010 GUI
  4. Connecting Microsoft Outlook 2007 to Gmail without SSL
  5. Creating a new blank database using Microsoft Access 2007
  6. Connecting Microsoft Outlook 2007 to Gmail with SSL
  7. Calculated Data Types in Microsoft Access 2010
  8. ASCII Character Table for ISO 8859-1
  9. Using Text Box controls to create borders in Microsoft Publisher 2010
  10. Submitting Access Database Templates to Office Online

:, , , , , , , , , , , ,

Leave a Reply

You must be logged in to post a comment.



Archives