The Developer tab isn't displayed by default, but you can add it to the ribbon.
1. Go to File tab in MS-Excel > select Options.
2. You will see an “Excel Options” window. In the left sidebar of this window, click “Customize Ribbon.”
3. Under Customize Ribbon > under Main Tabs, select the Developer check box. Then click “OK” at the bottom.
4. Back on the Excel window, at the top, you will now see a new tab called “Developer.” Click the tab to see all the options it offers.