The Developer Tab contains a variety of tools that allow you to customise Excel.
Of importance is the fact that the Developer tab contains tools that allow you to create, access and edit macros. By default, the Developer Tab is not displayed. To enable and display complete the following steps.
Click the File tab.
Select Options from the menu on the left of the screen.
The Excel Options dialog box will be displayed.
Select Customise Ribbon.
In the right hand pane click the check-box next to Developer.
The Developer tab will now be displayed in the tabs section of the ribbon.