trumpexcel.com Open in urlscan Pro
162.159.135.42  Public Scan

Form analysis
3 forms found in the DOM

GET https://trumpexcel.com

<form class="elementor-search-form" action="https://trumpexcel.com" method="get" role="search">
  <div class="elementor-search-form__toggle" tabindex="0" role="button"> <i aria-hidden="true" class="fas fa-search"></i> <span class="elementor-screen-only">Search</span> </div>
  <div class="elementor-search-form__container"> <label class="elementor-screen-only" for="elementor-search-form-57f4116">Search</label> <input id="elementor-search-form-57f4116" placeholder="Search..." class="elementor-search-form__input"
      type="search" name="s" value="">
    <div class="dialog-lightbox-close-button dialog-close-button" role="button" tabindex="0"> <i aria-hidden="true" class="eicon-close"></i> <span class="elementor-screen-only">Close this search box.</span> </div>
  </div>
</form>

Name: New Form — POST

<form class="elementor-form" method="post" name="New Form"> <input type="hidden" name="post_id" value="31651"> <input type="hidden" name="form_id" value="02fa695"> <input type="hidden" name="referer_title"
    value="How to Get the Excel Developer Tab Show Up in the Ribbon"> <input type="hidden" name="queried_id" value="955">
  <div class="elementor-form-fields-wrapper elementor-labels-">
    <div class="elementor-field-type-text elementor-field-group elementor-column elementor-field-group-first_name elementor-col-100"> <label for="form-field-first_name" class="elementor-field-label elementor-screen-only"> Name </label> <input
        size="1" type="text" name="form_fields[first_name]" id="form-field-first_name" class="elementor-field elementor-size-md  elementor-field-textual" placeholder="Name"> </div>
    <div class="elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required"> <label for="form-field-email" class="elementor-field-label elementor-screen-only"> Email
      </label> <input size="1" type="email" name="form_fields[email]" id="form-field-email" class="elementor-field elementor-size-md  elementor-field-textual" placeholder="Email" required="required" aria-required="true"> </div>
    <div class="elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons"> <button type="submit" class="elementor-button elementor-size-md"> <span> <span class=" elementor-button-icon"> </span> <span
            class="elementor-button-text">YES - SEND ME THE EBOOK</span> </span> </button> </div>
  </div>
</form>

POST https://trumpexcel.com/wp-comments-post.php

<form action="https://trumpexcel.com/wp-comments-post.php" method="post" id="commentform" class="comment-form" novalidate="">
  <p class="comment-form-comment"><label for="comment" class="screen-reader-text">Comment</label><textarea autocomplete="new-password" id="d22348054a" name="d22348054a" cols="45" rows="8" required=""></textarea><textarea id="comment"
      aria-label="hp-comment" aria-hidden="true" name="comment" autocomplete="new-password"
      style="padding:0 !important;clip:rect(1px,1px,1px,1px) !important;position:absolute !important;white-space:nowrap !important;height:1px !important;width:1px !important;overflow:hidden !important;" tabindex="-1"></textarea><template
      data-nitro-marker-id="d06a7d5ebb4590fef00d4c24eeed57ca-1"></template></p><label for="author" class="screen-reader-text">Name</label><input placeholder="Name *" id="author" name="author" type="text" value="" size="30" required=""> <label
    for="email" class="screen-reader-text">Email</label><input placeholder="Email *" id="email" name="email" type="email" value="" size="30" required=""> <label for="url" class="screen-reader-text">Website</label><input placeholder="Website" id="url"
    name="url" type="url" value="" size="30">
  <p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Post Comment"> <input type="hidden" name="comment_post_ID" value="955" id="comment_post_ID"> <input type="hidden" name="comment_parent" id="comment_parent"
      value="0"> </p>
</form>

Text Content

Skip to content
 * About
 * Excel Functions
 * Blog
   * Excel Tips
   * VBA Tips
   * Charting
   * Pivot Table Tips
   * Excel Dashboard Tips
 * FREE Training
   * Excel Basic to Advanced
   * Excel Dashboard Course
   * Excel VBA Course
   * Excel Power Query Course
 * FREE Excel Templates

Menu
 * About
 * Excel Functions
 * Blog
   * Excel Tips
   * VBA Tips
   * Charting
   * Pivot Table Tips
   * Excel Dashboard Tips
 * FREE Training
   * Excel Basic to Advanced
   * Excel Dashboard Course
   * Excel VBA Course
   * Excel Power Query Course
 * FREE Excel Templates

Search
Search
Close this search box.

Home » How to Get the Excel Developer Tab Show Up in the Ribbon




HOW TO GET THE EXCEL DEVELOPER TAB SHOW UP IN THE RIBBON

 * -- By Sumit Bansal

FREE EXCEL TIPS EBOOK - Click here to get your copy

You can insert a lot of interactive controls in an Excel worksheet using the
Excel developer tab.

These interactive controls (such as a check box, radio button, combo box, scroll
bars) are quite useful when you are creating interactive workbooks or excel
dashboards.

In this video, I covered 10 less-known but amazing Excel tricks that can save
you a lot of time. These are simple Excel tricks that you can use in your
day-to-day work and be more efficient


 

But there is a possibility that you may not have the Developer tab available in
the ribbon. If that happens, don’t panic – and keep reading how to get the
developer tab.



This Tutorial Covers:

Toggle
 * How to Get the Excel Developer Tab Show Up in the Ribbon
 * Alternate Method to Get Developer Tab in Excel Ribbon
 * Options Available in the Excel Developer Tab


EXCEL DEVELOPER TAB.. WHERE TO FIND IT?

Don’t worry if you can’t find the Excel developer tab in the ribbon.

Since it is not something that most of the beginner Excel users need on a daily
basis (some might), Excel team has it disabled as a default setting.

Before you can use it, you need to enable it.


HOW TO GET THE EXCEL DEVELOPER TAB SHOW UP IN THE RIBBON

In this tutorial, I’ll show you how to get the Excel developer tab in the
ribbon.

Below are the steps for getting it in Excel 2013.

While the screenshots are of Excel 2013, the process is the same in Excel 2007
or 2010.

 * Right-click on any of the existing tabs in the ribbon and select Customize
   the Ribbon. It will open the Excel Options dialogue box.
 * In the Excel Options dialogue box, you will have the Customize the Ribbon
   options. On the right, within the Main Tabs pane, check the Developer option.
 * Click OK.



Now you will have ‘Developer’ displayed as one of the tabs.

Once available, you can use this tab to access all the options within it.


ALTERNATE METHOD TO GET DEVELOPER TAB IN EXCEL RIBBON

There is another way you can get the Developer tab in the Excel ribbon.

Here are the steps:

 * Go to File –> Options.
 * In the Excel Options dialogue box, click on Customize Ribbon in the left
   pane. It will show the Customize the Ribbon options on the right.
 * On the right, within the Main Tabs pane, check the Developer option.
 * Click OK.

This will make the developer tab appear in the ribbon in Excel.

Also read: How to Remove Macros From Excel


OPTIONS AVAILABLE IN THE EXCEL DEVELOPER TAB

Here are some of the useful advanced options available in the Excel Developer
tab:


 * The Macro Options: There is a ‘Code’ group in the developer tab that gives
   you access to many macro options (such as going to the VB Editor, getting a
   list of all macros in the workbook, record and run the macros, and change
   macro security.
 * Add-ins: The Add-ins options allow you to manage inbuilt add-ins as well as
   new add-ins that you might have added.
 * Interactive Controls: The Control group gives you access to all the form and
   Active-X controls that you can use to insert interactive tools such as a
   scrollbar, combo boxes, checkboxes, radio buttons, etc.

You May Also Like the following Related Tutorials:

 * Create Groups in Quick Access Toolbar in Excel.
 * How to get the Developer Tab in the Ribbon Word 2013.
 * Excel VBA Loops- The Ultimate Guide.
 * How to Use Excel VBA Immediate Window
 * Excel VBA MsgBox [Message Box]
 * Visual Basic Editor – How to Open and Use it in Excel
 * How to Hide or Show Formula Bar in Excel?
 * How to Customize the Ribbon in Excel (Step-by-Step)
 * How to Show or Hide the Ribbon in Excel?

FREE EXCEL BOOK


GET 51 EXCEL TIPS EBOOK TO SKYROCKET YOUR PRODUCTIVITY AND GET WORK DONE FASTER

Name
Email
YES - SEND ME THE EBOOK



8 THOUGHTS ON “HOW TO GET THE EXCEL DEVELOPER TAB SHOW UP IN THE RIBBON”

 1. YT
    December 2019 at 6:14 am
    
    Does this work in Cloud version of excel where people can edit real time?
    
    Reply
 2. Juan Mindiola
    September 2019 at 11:42 pm
    
    It worked for me, and it extremely helpful Thanks! I’m just amazed it is not
    something we can just turn on it Excel under options. It seems ridiculous
    that they removed the automatic highlight of the active row during the
    last(?) upgrade. Is there anyway to get this feedback back to MS?
    
    Reply
    
 3. thomas
    July 2019 at 4:59 pm
    
    this was poor information. I never got excel to do what i wanted despite
    reading these directions many times
    
    Reply
 4. Don Frisby
    April 2019 at 11:48 pm
    
    I’ve been away from VBA programming in Excel for a few years and didn’t even
    have Excel during that time. Decided to get back into programming basically
    for myself and friends and family. Bought the stand alone Excel for $130 a
    few hrs ago and went looking for the Developer’s tab or any access route
    into my VBA program. I even went to Microsoft for some help and tried
    several attempt on the net to find out how to connect again with my macros
    created with VBA. No luck, not on the net, not at three different connects
    with Microsoft help…but FINALLY…your site and God be praised. I found
    EXACTLY what I needed to reestablish my connect with VBA thru Excel. I have
    forgotten much, but this is a good start…now.
    Thank you for this site.
    
    Reply
    
 5. KASSIM AHMED
    March 2019 at 9:35 pm
    
    how can i create a work book for data entry and result upload using excel
    work.book ?
    
    Reply
 6. Ogundepo Ezekiel Adebayo
    September 2016 at 1:18 am
    
    Oh I got it. That ks
    
    Reply
    
 7. Amit
    November 2013 at 6:39 pm
    
    Unable to apply in 7
    
    Reply
    * Sumit Bansal
      November 2013 at 11:58 pm
      
      Hi Amit.. you mean 2007 right? For enabling the Developer tab in 2007 go
      to
      
      Options –> Popular –> Show Developer tab in the Ribbon
      
      
      Reply


LEAVE A COMMENT CANCEL REPLY

Comment

Name Email Website



BEST EXCEL TUTORIALS



Best Excel Shortcuts



Conditional Formatting



Excel Skills



Creating a Pivot Table



Excel Tables



INDEX- MATCH Combo



Creating a Drop Down List



Recording a Macro



VBA Loops




©TrumpExcel.com – Free Online Excel Training



Privacy Policy | Sitemap




Update Privacy Preferences
A Raptive Partner Site