Macros in Microsoft Excel give you a way to automate tasks that could be time-consuming if performed manually. But macros can potentially be dangerous if someone wishes to use them that way, so Excel is very careful with allowing you to use them in your workbooks.
Our tutorial below will show you how to add the Developer tab in Excel 2013 so that you can see the option for macros in your ribbon. We will also show you how to adjust a setting in the Trsut Center so that you can enable macros in Excel 2013 and run them when you encounter them.
How to Add the Developer Tab in Excel 2013 and Enable Macros Through the Trust Center
The steps in this article were performed in Microsoft Excel 2013, but will also work in newer versions of Excel as well. Once you complete this guide you will have added the Developer tab to your Excel ribbon, as well as enabled macros through the Trust Center. Note that macros can potentially be dangerous, so it’s best to only use them in workbooks where you are confident that the creator of the workbook doesn’t intend to do anything malicious to you.
Step 1: Open Excel 2013.
Step 2: Click the File tab at the top-left corner of the window.
Step 3: Select the Options button from the column at the left side of the window.
Step 4: Click the Customize Ribbon tab in the left column of the Excel Options window.
Step 5: Check the box to the left of Developer.
Step 6: Click the Trust Center tab at the left side of the window.
Step 7: Click the Trust Center Settings button at the right side of the window.
Step 8: Select the Macro Settings option at the left side of the window.
Step 9: Check the circle to the left of Enable all macros, then click the OK button at the bottom of the window. As noted next to this option, this is not recommended, and can be potentially harmful. Be careful opening workbooks containing macros.
Step 10: Click the OK button on the Excel Options window, too, to save the Developer tab that we added earlier.
Do you have a spreadsheet that you need to print out, but it isn’t working the way that you want? Check out our Excel printing guide for some tips that can help make printing in Excel a little easier.