Office 365: Enable Excel macros - how to do it

With the help of macros, you can automate a variety of operations in Excel, saving yourself time and work. How you activate the macro function depends on the Excel version. Learn how to turn on the feature in the Office 365 version of Excel.

How to enable the macro function in Excel

In order to be able to use the macro function in the Office 365 version of Excel at all, you must first enable it via the program's settings.

1. Open the application and call up the options via the menu.
2. Select the category "Customize ribbon" in the overview.
3. Scroll down in the list "Main tabs" and check the box "Developer Tools".
4. Confirm your change by finally clicking "OK".

The macro function can now be found under the category "Code" in the "Developer Tools" tab.

Record macros: How to create your own macros

Using the macro function, you now have the option to record your own macros.

1. Open any Excel file.
2. Click on "Developer Tools" in the ribbon and then on the "Record Macro" option.
3. Determine a name, a key combination and a storage location for the macro. Also enter a description.
4. Click "OK" to start recording and execute the command sequence.
5. If you want to stop recording, click the "Stop recording" option in the "Developer Tools" tab.

Besides Excel, you can also enable and use macros in all other applications of the Office 365 package.