How to Access the Developer Tab in Excel

How to Access the Developer Tab in Excel -

By default, Excel’s Developer tab is hidden away in the program’s settings, but turning it on is just a few clicks away. Normally, this tab is hidden, as most users do not need access to the features of this particular tab. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc.

How to Unlock the Hidden Developer Tab in Excel

Method 1:

To create a checklist, you must enable the Developer tab on the ribbon. To do this, right-click on the ribbon and select Customize the Ribbon.

Excel Options Customize Ribbon -

In the list of Main Tabs on the right side of the Excel Options dialog box, check the Developer box and then click OK.

Excel Options Developer box -

Method 2:

To display the Developer tab, click on the File menu and then select Options from the drop down menu.

excel Developer tab -

When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button.

Now you should see the DEVELOPER tab in the toolbar at the top of the screen.

To hide the display of the Developer tab in the future, repeat these same steps again. This time, un-check the checkmark next to the “Developer” tab category to hide its display within the Ribbon again.
That’s all..

Watch Video

Recommended For You

How To Only Print An Area İn Microsoft Excel

How To Print Only A Selected Area Of An Excel Spreadsheet

How To Copy And Paste Performance Information In Windows 10

Add a Comment

Your email address will not be published. Required fields are marked *