excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Beauty Tips
ExcelTips
Money Tips
Organizing Tips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 
Tips.Net > Excel2007 Home > Configuring Excel > Displaying Excel's Developer Tab

Displaying Excel's Developer Tab

Summary: The Developer tab of the ribbon is the gateway to many advanced features in Excel, including those features related to working with macros. The Developer tab is not visible by default in Excel, but here's how to make sure it remains displayed on your system.

The user interface in Excel 2007 can be confusing, especially to those who have long used the interface of previous versions of the program. The new interface uses a "ribbon" type of interface, visible at the top of the screen. The ribbon is made up of different tabs, each of which contains a collection of related tools. The tabs that are visible often depend on what you are doing in Excel at the moment.

One tab that is especially necessary for advanced users is the Developer tab. This tab contains a variety of tools that allow you to "develop" and customize Excel. Of particular importance is the fact that the Developer tab contains tools that allow you to create and access macros.

The Developer tab is not contextual in nature; it should always be visible on the ribbon. If it is not visible, that means you have not configured Excel to display it. (The Developer tab is not visible in a default installation of Excel.) To display the tab, follow these steps:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. Make sure that Popular is selected at the left side of the dialog box. (Click here to see a related figure.)
  3. Ensure the Show Developer Tab in Ribbon check box is selected.
  4. Click OK.

The developer tab should now be visible on the ribbon.

Related Tips:

More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want. Check out WordTips: The Macros today!