• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » Add or Show Developer Tab in Excel Ribbon Menu

Add or Show Developer Tab in Excel Ribbon Menu

By: Waseem Patwegar

Adding the Developer tab in Microsoft Excel provides access to Advanced Excel functions. You can find below the steps to Add or Show Developer Tab to Ribbon menu in Excel.

Show Developer Tab in Excel Ribbon Menu

Show or Add Developer Tab in Excel

The Developer Tab is not enabled by default in Microsoft Excel, which results in multiple Intermediate and Advanced Level Excel functions from being hidden from users.

However, it really easy to Add the Developer Tab to Ribbon-menu and gain access to Excel Add-ins, ActiveX Controls, Visual Basic Commands, Macros, Forms, Interactive Tools and various other functions.

Make Developer Tab Visible in Excel Ribbon Menu

The quickest way to Reveal the Developer Tab in Microsoft Excel is to right-click in an Empty space in the ribbon menu and select Customize the Ribbon… option.

Customize Ribbon Option in Excel

On the next screen, check the little box next to Developer and click on OK.

Enable Developer Tab in Excel Ribbon Menu

If this does not work, you can try any of the following methods as applicable for the version of Microsoft Excel installed on your computer.

  1. Excel 2010 and Later: Click on File > Options > Customize Ribbon > check the Developer option and click on OK.
  2. Excel 2007 and earlier: Click on the Microsoft Office Button > Excel Options > Popular > Show Developer Tab in the Ribbon.
  3. Excel on Mac: Click on Customize tool bar Down Arrow and choose More Commands. On the More Commands screen, click on the Ribbon tab and check the Developer option.
Related
  • How to Create Pivot Table From Multiple Worksheets
  • How to Add Prefix or Suffix in Excel

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Set Out of Office Message in Microsoft Teams
        How to Set Out of Office Message in Microsoft Teams
        • Setup Recurring Meeting in Microsoft Teams
          How to Setup Recurring Meeting in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Techbout.com · All Rights Reserved