How to Activate Developer option in Excel

How to Activate Developer option in Excel

How to Activate Developer option in Excel

Developer option ebabled
Developer option ebabled

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, button, checkbox 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 its function, that’s another topic/article on its own.

The Developer options can be used in doing and completing 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

ACTIVATING VIA QUICK ACCESS TOOL BAR

  1. The Quick Access Tool bar is located at the top left of Excel interface, click the last option to Customize quick access toolbar
  2. On the drop-down menu, Click on more command
  3. A dialog box will display showing the all the settings in Excel displaying the quick access tool bar and other menu.
  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.

This is considered as the faster and time saving steps to activate the Developer option by using the Quick access tool bar.

How to Activate Developer option in Excel

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

ACTIVATING VIA FILE MENU/OPTION SETTING

Click on the File Menu

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

The option 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 be used with any version of Excel.

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

zazasco
Author: zazasco

I am Isaiah Isaiah Joel, simple in nature love fun and tourism. To know more about me, ask me in person.

+1
0
+1
0
+1
0
+1
0
+1
0
+1
0
+1
0
  • Yum

Leave a Reply

%d bloggers like this:
Enable Notifications    OK No thanks