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. Creating a Database from Template using Microsoft Access 2007
  2. Saving a Report as PDF with the Access 2010 GUI
  3. Connecting Microsoft Outlook 2007 to GoDaddy email with SSL
  4. Can’t Delete File in Windows Vista or Windows 7 – Problem Solved!
  5. Using ShapeSheets in Microsoft Visio 2007
  6. Using Text Box controls to create borders in Microsoft Publisher 2010
  7. Connecting Microsoft Outlook 2007 to Gmail with SSL
  8. Creating a Spreadsheet from Template in Microsoft Excel 2007
  9. Submitting Access Database Templates to Office Online
  10. Creating a Macro to Save a Report as PDF in Access 2010

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

Leave a Reply

You must be logged in to post a comment.



Archives