The Developer tab is hidden by default, but you can turn it on in three clicks
The Developer tab in Excel gives you access to macros, form controls, and XML tools — features most people never need, which is why Microsoft hides it. If you write macros, build forms, or work with VBA code, you need this tab visible. Turning it on takes less than a minute and works the same way in Excel 2016, 2019, 2021, and Microsoft 365.
Once you enable the Developer tab, it stays visible every time you open Excel on that computer. The setting does not affect your spreadsheet files themselves — it only changes what you see on your screen. You can turn it off again at any time without losing any macros or forms you have created.
Key Takeaways
- The Developer tab is hidden by default because most Excel users do not need macros or form controls.
- You turn it on through File > Options > Customize Ribbon, then check the Developer box and click OK.
- Once enabled, the Developer tab stays visible every time you open Excel on that computer.
- The Developer tab contains macro recording, VBA editor access, form controls, and XML mapping tools.
- Showing the Developer tab does not change how your spreadsheets work or enable macros automatically.
Where to find the option to show the Developer tab
Open Excel and look at the ribbon — the row of tabs across the top that says Home, Insert, Page Layout, Formulas, Data, Review, and View. The Developer tab is not there by default. To add it, click File in the top left corner of the window.
From the File menu, click Options near the bottom of the left sidebar. This opens the Excel Options window. On the left side of that window, click Customize Ribbon. You are now in the right place to make the Developer tab visible.
Checking the Developer box
In the Customize Ribbon window, you will see two columns. The right column shows all the tabs currently visible on your ribbon. Look down that list until you find Developer. If it is not checked, click the checkbox next to it to enable it.
Once the Developer checkbox is checked, click the OK button at the bottom right of the window. Excel closes the Options window and returns you to your spreadsheet. The Developer tab now appears on your ribbon, usually positioned between the View tab and the Help menu at the far right.
What you will see on the Developer tab
The Developer tab contains several groups of tools organized by function. The Code group holds the Visual Basic button, which opens the VBA editor where you write and edit macros. The Record Macro button lets you record your actions and turn them into a macro without writing any code yourself — Excel captures what you do and converts it to VBA automatically.
The Controls group holds buttons, checkboxes, dropdown lists, text boxes, and other form elements you can insert into a spreadsheet to make it interactive. The XML group appears only if you work with XML data mapping. Most people who need the Developer tab use it for either recording macros to automate repetitive tasks or inserting form controls to make worksheets easier for other people to use.
Turning the Developer tab off again
If you enabled the Developer tab and later decide you do not need it visible, you can hide it using the same path. Go to File > Options > Customize Ribbon, uncheck the Developer box, and click OK. The tab disappears from your ribbon when ready.
Hiding the tab does not delete any macros you have written or any forms you have built into your spreadsheets — it just removes the tab from view. You can turn it back on at any time without losing your work. The macros and controls remain in your files whether the tab is visible or not.
Why the Developer tab is hidden by default
Microsoft hides the Developer tab because it contains tools for advanced users. Most people who use Excel never write macros or build forms. Hiding the tab keeps the ribbon cleaner and less overwhelming for everyday spreadsheet work like entering data, creating charts, and writing formulas.
The tools on the Developer tab can also be dangerous if used carelessly — a badly written macro can corrupt a file or cause Excel to freeze. By hiding the tab, Microsoft reduces the chance that someone will accidentally enable a macro or insert a control they do not understand. This is a safety measure, not a limitation on what Excel can do.
Frequently Asked Questions
Does showing the Developer tab change how my spreadsheets work?
No. Turning on the Developer tab only makes the tab visible on your screen. It does not change any of your files, does not enable macros automatically, and does not affect how your spreadsheets behave. You still have to choose to record or write a macro yourself.
Will the Developer tab appear on other computers I use?
No. The Developer tab setting is stored on your computer only. If you use Excel on a different computer, you will need to turn on the Developer tab there as well. Each computer has its own ribbon settings.
What if I cannot find the Developer checkbox in Customize Ribbon?
Make sure you are in the right window. Click File, then Options, then Customize Ribbon on the left side. The Developer checkbox should appear in the right column. If you are looking at the left column instead, you are in the wrong place — the left column shows available commands you can add, not the tabs themselves.
Can I move the Developer tab to a different position on the ribbon?
Yes. In the Customize Ribbon window, click Developer in the right column and use the up and down arrow buttons to move it. You can place it anywhere in the tab order. Click OK when you are done.
What is VBA and why would I need it?
VBA stands for Visual Basic for Applications. It is the programming language Excel uses for macros. You do not need to know VBA to use the Developer tab — you can record macros by clicking Record Macro and performing actions normally. VBA is only necessary if you want to write complex macros that do things recording cannot capture.