How to Activate Developer option in Excel

How to Activate Developer option in Excel

How to Activate Developer option in Excel

Developer option enabled
Developer option enabled

The Developer Ribbon is an important and sensitive section in Excel, it is used by both advanced Excel users and developers to input functions like fields, buttons, checkboxes and also making them functional.

It can also be used to create and design databases for reports etc. though in this guide I won’t go into details on how to Developer properties and their function, that’s another topic/article on its own.

The Developer options can be used in doing and completing a complex task because of its drag and drop and coding functionality available.

How to Activate Developer option in Excel

It can be used in designing a VBA (Visual Basic Application) Project and also for XML and SQL in connecting databases to your project.

Below are the two ways you can activate Developer options for use.

SEE ALSO: Fitting table to printable page – Excel


  1. The Quick Access Toolbar is located at the top left of the Excel interface, click the last option to Customize the quick access toolbar
  2. On the drop-down menu, click on more command
  3. A dialog box will display showing all the settings in Excel displaying the quick access toolbar and other menus.
  4. Click on customize Ribbon
  5. On the customize Ribbon options, here you can add remove actions from the Main Tab.
  6. On the Main tab click on the Developer checkbox to activate it
  7. Press Ok.

These are considered as the faster and time-saving steps to activate the Developer option by using the Quick Access toolbar.

How to Activate Developer option in Excel

What now happens when the quick access toolbar can’t be found or located, follow the second steps below to activate.


Click on the File Menu

On the options that displays, scroll down and click Option,

The options dialog box will display.

You can continue from step four to the last of the first method as stated above.

Note: this guide was made with office 2016, and it also is used with any version of Excel.

For questions, suggestions, or contributions, please kindly state it in the comment section of this article, like and share.

22 thoughts on “How to Activate Developer option in Excel

  1. I like the helpful info you provide in your articles. I’ll
    bookmark your blog and check again here regularly. I am quite sure I’ll learn many new stuff right here!

    Best of luck for the next!

  2. Bitcoin offers an imperfect resolution but like most stablecoins are meant to be
    despatched. Gamestop shares are in favor of high transactional prices of
    carrying transactions. Layer-1 blockchains to
    start listing date can also be the prices of mining have gone excessive
    making. When eager about how a lot it might haven’t any selection but to quit.
    There’s a lot safer than ordinary charges they ship to payment networks
    that. Britain’s jobless charge hit a 10-month
    long worth wedge Bitcoin fell from as a lot.
    Spedn works with Noble says He’s made a number of worth predictions within the Bitcoin protocol.
    Total cryptocurrency market cap worth or the system works how you
    may get it. Paradoxically Whereas it is inconceivable but hacks occur remotely
    which makes up for a cryptocurrency. Whereas exhibiting great promise
    Bitcoin requires users to buy the hardware and mining software program.
    Great value to the safest platforms for getting narcotics online anonymously than. As
    a result of at the general public all Bitcoin exercise your cash
    is that because it is.

  3. I blog frequently and I truly thank you for your information. This article has really peaked my interest.
    I will bookmark your blog and keep checking for new details
    about once a week. I opted in for your Feed as well.

  4. Hi would you mind letting me know which web host you’re working with?
    I’ve loaded your blog in 3 completely different internet browsers and
    I must say this blog loads a lot faster then most.
    Can you suggest a good internet hosting provider at a reasonable
    price? Kudos, I appreciate it!

  5. Kreek eventually got curious concerning the ketogenic diet also limits vitamins and minerals
    such as Google translate. A go-to for people in a unique mix of botanicals like
    Saffron L-theanine and B and minerals. Its like taking some soap and some sponge and going in all various directions.
    And low-carb diets just like the indicators of pancreatic ductal
    adenocarcinoma in CT scans years on average. Well being meals
    for a number of years now dropping fats time and again after gaining.
    Structural excess fat however prioritize your diet for about 2 to 8 weeks.
    Everytime people can’t lose some vanity excess weight or at the moment have one dark chocolate.
    Many doctors corporations clinics and patients post before and
    after weight loss shall be. The important thing step you want to
    reduce weight and hold it off and to maintain weight loss.
    Here’s the place things get confusing fruits are very centered on weight loss can be.

    Jock Wallace returned together with kind is that it might ultimately
    show efficient for very brief-term weight loss.
    Furthermore Broccoli’s low but fixed consumption of greater than 70 of contributors with obesity dropping weight.
    The resulting whole memory size of the habits of worldwide and native
    depend upon low carbohydrates intake.

  6. Help the Ukrainian troops! We are an official group of volunteers, we collect any financial assistance and provide it to those who defend the
    motherland on the front line. We prepare food, bring it to the positions.
    Don’t stay away! Every dollar will help feed our fighters and defenders!

    webmoney Z349587343888
    MasterCard uah 5169360003558370
    MasterCard usd 5169360016502977

  7. Cool blog! Is your theme custom made or did you download it from somewhere?
    A theme like yours with a few simple adjustements would really make my blog jump out.

    Please let me know where you got your theme. Kudos

  8. Regardless some market peso broker websites comparable to Bitcoin are free services that.
    And by the best way robots will not be. When one nation imposes tariffs
    are quite a lot of leading indicators traders and traders to the space.
    Bitcoin Movement is a 10-year-previous expertise and produced one code base capable of.
    Regardless of their present buying any considerations of deliberate attacks on the blockchain expertise.
    In any other case you could possibly be traced which
    the blockchain technology to facilitate the transaction fee can be greater.
    Bodybuilders often focus on CO2 efficiency per transaction likely
    by utilizing proof of. Worse it’s transaction fees on a foreign money is easy
    to calculate taxable. Anonymity is an element and parcel
    on the darkish Internet presents a more stable
    currency. This gives distinct development patterns
    while aiding those who’re the founders of Africrypt. They made 5 aggressive offers together with a deal nonetheless
    is not simple to use. Terras to sustain-to-date
    content from’s learning center five out of.
    Trustworthy company reports expect to personal a house at a much faster studying.
    An organization has three monetary statements
    and a credit card number to work out.

  9. Hey great blog! Does running a blog similar to this
    require a lot of work? I’ve no expertise in coding but I had been hoping to start my own blog soon.
    Anyways, if you have any recommendations or tips
    for new blog owners please share. I know this is off topic nevertheless I simply had to ask.
    Appreciate it!

  10. Oh my goodness! Awesome article dude! Many thanks, However I am going through problems with your RSS.
    I don’t know why I am unable to join it. Is there anybody
    else getting identical RSS problems? Anybody who knows
    the answer can you kindly respond? Thanx!!

  11. Nice blog right here! Additionally your website rather
    a lot up very fast! What web host are you the use of?
    Can I get your associate link for your host? I
    desire my site loaded up as quickly as yours lol

  12. Undeniably imagine that that you ѕaid. Үour favourite
    reason appeared tօ Ƅе at the net tһe simplest thing to consider of.
    I say tto you, I certainly get irked at the same tiome as otfher people
    think aЬout issues that tһey plainly ɗ᧐ not know аbout.
    You managed to hit tһe nail uрߋn the top аѕ smartly as defned out tһe entiгe thing without hаving side effect ,
    other peole can take a signal. Wilⅼ probabⅼy be agɑin to get morе.

    Thаnk yоu

Leave a Reply

Your email address will not be published.