Skip to main content

How to show/display developer tab in Excel Ribbon?

Author: Sun Last Modified: 2024-11-18

By default, the Developer tab is hidden on the Excel Ribbon. However, if you often work with advanced features like inserting controls, recording macros, or running VBA scripts, enabling the Developer tab can significantly enhance your productivity. This guide will walk you through the steps to display the Developer tab in the Ribbon for both modern Excel versions and Excel 2007.

Show Developer tab in Ribbon in Excel

Show Developer tab in Ribbon in Excel 2007


arrow blue right bubble Show Developer tab in Ribbon in Excel

To show the Developer tab in Excel, please follow these steps:

1. Click File > Options to open the Excel Options dialog. See screenshot:

A screenshot of the Excel File menu with the Options item highlighted

2. In the Excel Options dialog that appears, click Customize Ribbon in the left pane. See screenshot:

A screenshot of the Excel Options dialog with the Customize Ribbon option selected

3. And go right to the Customize the Ribbon section, and check Developer option in the Main Tabs list. See screenshot:

A screenshot of the Customize the Ribbon section with the Developer tab option checked in the Main Tabs list

4. Click OK to close the Excel Options dialog. Now you can see the Developer tab displayed in the Ribbon.

A screenshot of the Excel Ribbon showing the Developer tab displayed


arrow blue right bubble Show Developer tab in Ribbon in Excel 2007

In Excel 2007, you can also enable an option in the Excel Options dialog to show the Developer tab in the Ribbon.

1. Click Office Button > Excel Options. See screenshot:

A screenshot of the Office Button menu with the Excel Options item highlighted in Excel 2007

2 Then in the popping Excel Options dialog, click Popular in the left pane, then go to Top options for working with Excel section, and check Show Developer tab in the Ribbon option. See screenshot:

A screenshot of the Excel Options dialog in Excel 2007 with the Show Developer tab in the Ribbon option checked

3. Click OK to close Excel Options dialog. Now the Developer tab is displaying in the Ribbon.


Related Articles:

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions…
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!