Excel Enable Macros - Quick How-To Guide

Reading time icon 2 min. read


Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

Excel Enable Macros

Excel lets you enable macros to automate repetitive tasks, saving time and increasing productivity. However, for security reasons, Excel disables macros by default. If you want to take advantage of this feature, you’ll have to manually activate them.

Here’s how!

How To Enable Macros on Excel

Follow the below steps:

  1. Launch Excel, open any workbook, and click on the File tab in the top-left corner. 
File tab
  1. Select Options from the drop-down menu.
Options
  1. In the Excel Options window, select Trust Center from the left-hand side.
Trust Center
  1. Click on the Trust Center Settings button located at the bottom right.
Trust Center Settings
  1. Select Macro Settings from the left panel. You’ll find four options related to macros. Choose Enable all macros. Be aware that this option allows all macros to run, including potentially harmful ones.
Macro Settings

After selecting your desired macro setting, click OK to save the changes and close the Trust Center window. Finally, close the Excel Options window to finish the process.

That’s it!

Overall, Excel lets you enable macros to automate your tasks. The steps above will help you fully utilize Excel’s powerful macro feature and streamline your workflow.

There’s still more to learn. Check how to apply a formula to the entire column, fix autosave not working, and unlock a sheet without a password in Excel.

More about the topics: Excel

User forum

0 messages