Within the File menu, click on Options, and it will load a new window with all excel options available.Navigate to the File menu in your excel file and click on it.The first thing that comes is enabling the developer tab that helps you to record and store a macro (VBA Code). Let’s understand how to Program in excel with few illustrations. Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.