What is the keyboard shortcut to run a macro in Excel?

The keyboard shortcut Alt+F8 opens the Macro dialog box in Microsoft Excel. This dialog box lists all available macros in the current workbook and other open workbooks. From this window, the user can select a specific macro and choose to run, edit, step into, or delete it. While individual macros can be assigned their own Ctrl (or Ctrl+Shift) shortcut keys during creation, Alt+F8 is the universal shortcut to access the main macro management interface.

A. Ctrl+Shift+M: This is not a default Excel shortcut for running macros. It is sometimes associated with adding a new worksheet in older versions or can be custom assigned.

B. Ctrl+Alt+H: This shortcut is not assigned to any macro-related function in Excel. Ctrl+H opens the Find and Replace dialog box.

D. Ctrl+Alt+R: This is not a standard Excel shortcut. The Ctrl+R shortcut is used to fill the selected cells to the right.

1. Microsoft Corporation. (n.d.). Keyboard shortcuts in Excel. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f.

Reference Specifics: In the section "Ctrl key combination shortcuts

" the documentation lists Alt+F8 as the shortcut to "Display the Macro dialog box to create

run

edit

or delete a macro."

2. University of Wisconsin-Madison. (n.d.). Excel - Keyboard Shortcuts. Division of Information Technology (DoIT). Retrieved from https://it.wisc.edu/services/online-training-for-faculty-staff-and-students/courses/excel-keyboard-shortcuts/.

Reference Specifics: Under the "Macros" section

the document lists Alt + F8 to "Open the Macro dialog box."