This will appear on the right hand side of the ribbon if you successfully enabled it. Now you will have ‘Developer’ displayed as one of the tabs. Within the Main Tabs pane, check the Developer option. On the right you find the list showing the active tabs. On the picture below you can see the Excel Option window. You can even make it appear faster when clicking on the “ R” button after right click. Quick tip: If you are in a hurry you can choose the faster way using keyboard shortcuts. It will open the Excel Options dialogue box. Right click on any of the existing tabs in the ribbon and select Customize the Ribbon. The steps below are relevant to Excel 2013 and Excel 2016 versions. So before you can use it, you need to enable it. But on the other hand the most dashboard software can be reached only from here.Įxcel team has it disabled as a default setting. The Developer tab function was not created for beginner users. Thereby we give data visualization an effective support and can make our presentation more spectacular. Of its many advantages let’s see here some: we can start useful macros, we can insert interactive controls. You wouldn’t even think how many things can be controlled by its use. In today’s article we’ll show how can it be reached and what kind of functions it has. The Developer tab can’t be found on the ribbon as a default. How to show Developer tab on the Ribbon in Excel? This tab contains a lot of advanced features.

Add developer to excel 2016