Where to find developer in excel

You want to access one of advanced Excel features but are stuck at the very first step: where's the Developer tab they are all talking about? The good news is that the Developer tab is available in every version of Excel to , though it is not enabled by default. This article shows how to quickly activate it. The Developer tab is a useful addition to the Excel ribbon that allows you to access some of advanced features such as:.

Most often, the Developer tab is used for writing VBA macros. But it also provides access to a handful of other features that do not require any programming skills! For example, even an Excel novice can use the Developer tab to insert a check box , scroll bar, spin button, and other controls.

The problem is that by default it stays behind the scenes, and you need to show it first by using a corresponding setting. Luckily for us, it's one-time setup. Excel forms turn your spreadsheets into interactive forms. Many applications read and produce data in the extensible markup language, also known as XML. This section helps Excel and re-export information in that format.

You can also use XML within Excel to specify some additional information about your data. As you can see, the contents of the Developer tab are rather technical. The Developer tab opens up some very powerful possibilities—especially if you take advantage of Excel automation with Visual Basic and Excel macros.

And as a bonus, now you know how to customize the Ribbon to better fit your work style! It lets you access useful features that are otherwise hidden away. In this tutorial, I'll show you how to activate the Excel Developer tab.

Step 1 Open Excel from the Start menu and create a blank workbook by double-clicking the Blank workbook option selected by default. Step 3 Back on the spreadsheet view, you'll see that a new Developer tab has been added to the end of the tab list.

You've activated the Developer tab! From now on, the tab will be visible by default whenever you create a new Excel workbook.