The Developer tab is hidden by default, but you can show it in three clicks
Excel's Developer tab holds tools for building forms, writing macros, and automating repetitive work. It does not appear on your ribbon by default — Microsoft hides it to avoid overwhelming people who do not need it. You can turn it on in Excel for Windows, Excel for Mac, or Excel on the web, though the steps differ slightly for each.
Once the Developer tab is visible, you will see buttons for recording macros, inserting form controls, and accessing Visual Basic code. This is where you go if you want to automate a task that happens the same way every time, or build a spreadsheet that other people can use without seeing all the formulas underneath.
Key Takeaways
- The Developer tab is hidden by default in all versions of Excel and must be turned on through the Options or Preferences menu.
- In Excel for Windows, go to File > Options > Customize Ribbon, check the Developer box, and click OK.
- In Excel for Mac, go to Excel > Preferences > Ribbon & Toolbar, check Developer, and click Save.
- Excel on the web does not have a Developer tab, but you can use the desktop version to record macros and then upload the file.
Turning on the Developer tab in Excel for Windows
Open Excel and click the File menu in the top left corner. From the menu that appears, select Options at the bottom of the list. A window titled "Excel Options" will open.
On the left side of the Excel Options window, click Customize Ribbon. On the right side, you will see a list of tabs with checkboxes next to them. Scroll down until you find Developer and click the checkbox next to it. The checkbox will fill in, showing that Developer is now selected. Click the OK button at the bottom right to close the window and save your change.
The Developer tab will now appear on your ribbon between the View tab and any custom tabs you may have created. If you do not see it when ready, close and reopen Excel.
Turning on the Developer tab in Excel for Mac
Open Excel and click Excel in the menu bar at the very top of your screen. From the dropdown menu, select Preferences. A new window will open with several icons across the top.
Look for the icon labeled Ribbon & Toolbar and click it. In the list on the right side under "Customize the ribbon", scroll down to find Developer and click the checkbox next to it. Click the Save button at the bottom of the window. Close and reopen Excel if the Developer tab does not appear right away.
Why the Developer tab is hidden by default
Microsoft hides the Developer tab because most people who use Excel never need it. The tab contains advanced features like macro recording, Visual Basic code editing, and form controls — tools meant for people building spreadsheets that others will use, or automating tasks that repeat the same way hundreds of times.
If you are using Excel to track expenses, manage a budget, or organize data, you will probably never need the Developer tab. If you find yourself doing the same steps over and over in a spreadsheet, or you want to let someone else use a spreadsheet without seeing all your formulas, that is when the Developer tab becomes useful.
What you can do once the Developer tab is visible
The Record Macro button lets you capture a series of actions — like formatting cells, copying data, or explore a filter — and play them back with a single click. This saves time if you perform the same steps on different spreadsheets or different parts of the same spreadsheet. You can also name your macro so you remember what it does.
The Visual Basic button opens the code editor, where you can write or edit macros by hand. This is for people who know how to code or want to learn. Form controls like buttons, checkboxes, and dropdown lists let you build a spreadsheet that other people can use without needing to understand how it works underneath.
The Insert options let you add ActiveX controls — more advanced form elements that respond to clicks and changes. The Design Mode button toggles between building mode (where you can edit controls) and user mode (where controls actually work).
Excel on the web does not have a Developer tab
If you use Excel in your web browser through Microsoft 365, the Developer tab is not available. The web version of Excel does not support macros or Visual Basic code for security reasons — running code in a browser carries different risks than running it on your computer.
If you need to record a macro or use Developer tools, read the file to your computer, open it in the desktop version of Excel, make your changes, and upload it back to the web. The macros will still work when you open the file in the web version later, but you cannot edit or create new ones there.
Turning off the Developer tab if you do not need it
If you turn on the Developer tab and later decide you do not need it, you can hide it the same way you showed it. In Windows, go to File > Options > Customize Ribbon, uncheck the Developer box, and click OK. On Mac, go to Excel > Preferences > Ribbon & Toolbar, uncheck Developer, and click Save.
The tab will disappear from your ribbon when ready. You can turn it back on at any time by following the same steps and checking the box again. There is no penalty for toggling it on and off as your needs change.
Frequently Asked Questions
Will turning on the Developer tab change how my spreadsheet works?
No. Showing the Developer tab only makes the tools visible — it does not change any of your data or formulas. If you never click any of the Developer buttons, nothing will happen to your spreadsheet.
Is it safe to use the Developer tab and macros?
Macros you write yourself are safe. Macros from other people can be risky because code can do things you do not expect. When you open a file with macros from someone else, Excel will ask if you want to enable them — read the message carefully before you click yes.
Can I share a spreadsheet with macros with someone who uses Excel on a Mac?
Yes, but the macro code may need small changes because Windows and Mac versions of Excel handle some things differently. Test the file on both systems before sharing it with others who depend on it.
What if I cannot find the Developer tab after turning it on?
Close Excel completely and open it again. Sometimes the ribbon does not refresh when ready. If it still does not appear, go back to Options or Preferences and make sure the Developer checkbox is actually checked — it may have unchecked itself.