How to Enable Macros in Excel for Office 365: A Step-by-Step Guide


Michael Collins

Enabling macros in Excel for Office 365 can seem like a daunting task, but it’s actually quite simple once you know where to look. You just need to get into the Trust Center settings and tweak a couple of options. After that, you’ll be able to run macros to automate tasks and save time on your Excel projects.

Step by Step Tutorial on How to Enable Macros in Excel for Office 365

Before we dive into the steps, let’s quickly understand what we’re about to do. By enabling macros in Excel, you’re allowing the program to automize certain tasks which can be useful for repetitive actions. It’s like teaching Excel to do a part of your job for you!

Step 1: Open Excel

Open Excel and create a new document or open an existing one.

When you open Excel, you’ll see a blank document or the last document you worked on. It’s important to note that macros can be enabled for all documents or just specific ones, depending on your preference.

Step 2: Access the File Menu

Click on the ‘File’ tab in the upper-left corner of Excel.

The ‘File’ tab is like the control center of Excel. From here, you can access a lot of different settings and options for your Excel document.

Step 3: Go to Options

Select ‘Options’ at the bottom of the menu.

The ‘Options’ menu is where you can change the settings for how Excel behaves. There’s a lot you can do here, but today we’re focusing on macros.

Step 4: Choose ‘Trust Center’

In the Excel Options window, click on ‘Trust Center’ in the menu on the left side.

The ‘Trust Center’ is where Excel’s security settings are housed. It’s designed to keep your computer safe from potentially harmful macros and other risks.

Step 5: Open Trust Center Settings

Click on the ‘Trust Center Settings’ button.

This will open a new window with even more security options for Excel.

Step 6: Enable All Macros

Go to the ‘Macro Settings’ section, and select ‘Enable all macros’. Click ‘OK’.

By enabling all macros, you can run any macro, even if it’s from an unknown source. Be sure that you trust the source of your macros, as malicious macros can harm your computer.

After you complete these steps, macros will be enabled in Excel, and you can start automating your tasks. Just remember to use this power wisely, as macros can also potentially pose a security risk if they come from an untrusted source.

Tips on How to Enable Macros in Excel for Office 365

  • Always make sure that the macros you’re enabling come from a trusted source to avoid any potential security risks.
  • If you’re not using macros regularly, consider setting your macro security level to ‘Disable all macros with notification’. You’ll be prompted each time a macro tries to run, and you can enable it on a case-by-case basis.
  • Keep in mind that enabling macros can sometimes cause Excel to run a bit slower, as it’s doing extra work to execute the macro’s commands.
  • You can also assign macros to a button in the Quick Access Toolbar for even quicker access.
  • Don’t forget that you can record your own macros for simple tasks instead of writing the code yourself. Just go to the ‘View’ tab, and click on ‘Macros’ to get started.

Frequently Asked Questions

What is a macro?

A macro is a series of instructions that automates tasks in Excel, saving you time.

Why can’t I find the ‘Trust Center’ in my Excel?

If you can’t find the ‘Trust Center’, you may be using a version of Excel that’s different from Office 365, or your interface might be customized differently.

Are macros safe to enable?

Macros are safe as long as they come from a trusted source. Be cautious about enabling macros from sources you don’t know or trust.

Can I enable macros for just one document?

Yes, you can change the macro settings for a single document by accessing the ‘Trust Center’ settings while that document is open.

How do I disable macros if I no longer need them?

You can disable macros by going back to the ‘Macro Settings’ in the ‘Trust Center’ and selecting ‘Disable all macros without notification’.


  1. Open Excel.
  2. Click on the ‘File’ tab.
  3. Select ‘Options’.
  4. Click on ‘Trust Center’.
  5. Open ‘Trust Center Settings’.
  6. Enable all macros.


Enabling macros in Excel for Office 365 can be a game-changer when it comes to productivity. With just a few clicks, you can set Excel to perform repetitive tasks, freeing up your time to tackle more complex problems. However, with great power comes great responsibility. Always ensure that you trust the source of the macros you enable to keep your computer safe from harm. Remember, macros can be both a friend and a foe. Use them wisely, and you’ll wonder how you ever managed without them. Happy automating!