Ask a Question

Excel: Show developer tools

+4 votes
82 views
in Office by (242k points)
reopened
Excel: Show developer tools

1 Answer

+5 votes
by (1.6m points)
 
Best answer

Permanently show developer tools
1st step:
2nd step:
3rd step:
4th step:
Quick guide: Show developer tools permanently

Would you like to use developer tools in Excel, but can't find the tab? This is how you can show it permanently:

image image

If you work with Excel a lot, sooner or later it will be a good idea to use developer tools. Macros and controls make work easier and make the workbook appear clearer. We explain how to use macros in these instructions.
How to show the developer tools:

Permanently show developer tools

Follow our step-by-step instructions or take a look at the brief instructions ..

1st step:

image
Open Excel and click on " File " at the top .

2nd step:

image
Now select " Options " in the menu on the left.

3rd step:

image
Click the Excel Options to " Ribbon adapt ". You can now select the main tabs. Place a check next to Developer Tools and click OK .

4th step:

image
The Developer tab is now located as a tab on the ribbon at the top.

Quick guide: Show developer tools permanently

  1. Open Excel and click on " File " in the tab .
  2. Click on " Options " in the menu on the left .
  3. Select " Customize the Ribbon " and check the box next to " Developer ".
  4. Confirm with " OK ". The tools now appear permanently as a tab in the ribbon.
...