How to add the Developer tab in Excel

Excel 365 2016 2013 2010
You should display the Developer tab when you want to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs. Do the following:

   1.   Click the Microsoft Office Button ms office button , and then click Excel Options:

Excel 2007 Options

   2.   In the Excel Options dialog box, on the Popular tab, check the Show Developer tab in the Ribbon checkbox:

Developer tab in Excel 2007

   3.   Click OK.

For more details, see Creating Your Own Menu.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Create a toolbar button or menu item to run a Macro

Create a toolbar button or menu item to run a Macro

If you assigned a key combination to a macro when you recorded it, you can run the macro by pressing that key combination. If not, you can subsequently assign the macro to the menu item.
Record a Macro using the Macro Recorder

Record a Macro using the Macro Recorder

The easiest way to create a macro in Excel is to use Office's built-in Macro Recorder tool.
Adding commands to the Quick Access Toolbar

Adding commands to the Quick Access Toolbar

Suppose you'd like to add a couple more commands to the Quick Access toolbar. Perhaps you miss the menu in earlier versions of Excel that let you quickly switch between open Excel windows. Also, say you're a big fan of AutoSum. You can add the AutoSum button to the Quick Access toolbar, so you can quickly create and use AutoSum entries.