Running macros in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a macro in Excel?

A macro is a set of instructions that automates tasks in Excel. It helps you do repetitive work quickly by running the saved steps automatically.

beginner

How do you run a macro using the Developer tab?

Go to the Developer tab, click on 'Macros', select the macro you want, then click 'Run'. This starts the macro and performs the saved actions.

beginner

What keyboard shortcut runs the last macro you recorded?

Press Alt + F8 to open the Macro dialog, then select the macro and click 'Run'. Alternatively, if you assigned a shortcut key when recording, use that key combination.

intermediate

Can you run a macro by clicking a button on the worksheet?

Yes! You can insert a button from the Developer tab and assign a macro to it. Clicking the button runs the macro instantly.

intermediate

What must you do before running macros if your Excel security settings block them?

You need to enable macros by changing the security settings. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings, then choose 'Enable all macros' or 'Disable all macros with notification'.

Which tab in Excel do you use to run a macro?

A View

B Developer

C Insert

D Home

The Developer tab contains the Macros button to run macros.

What happens when you run a macro?

A Excel opens a new worksheet

B Excel saves the workbook

C Excel performs a set of recorded actions automatically

D Excel deletes all data

Running a macro makes Excel do the saved steps automatically.

How can you run a macro without using the Developer tab?

A Assign a shortcut key to the macro

B Use the Home tab

C Right-click the worksheet tab

D Use the Formula bar

You can assign a shortcut key when recording a macro and use it to run the macro quickly.

If macros are disabled, what should you do to run them?

A Enable macros in Trust Center settings

B Restart Excel

C Save the file as PDF

D Close all other workbooks

Macros must be enabled in Excel's security settings to run.

What is one way to run a macro directly from the worksheet?

A Use the Status Bar

B Double-click a cell

C Press Ctrl + C

D Click a button linked to the macro

You can add a button on the worksheet and assign a macro to it for easy running.

Explain how to run a macro using the Developer tab in Excel.

Think about the steps you take to find and start a macro from the ribbon.

Describe what you need to do if Excel blocks macros from running.

Consider Excel's security features that protect you from unsafe macros.