Keyboard Shortcuts Macro Recording

A macro is a recorded sequence of actions — keystrokes, mouse clicks, menu selections — that you can replay with a single shortcut. Macros automate repetitive multi-step tasks that would otherwise take minutes to perform manually. Many applications include built-in macro recording, and dedicated macro tools extend this capability system-wide.

What a Macro Is

  WITHOUT MACRO (manual process, repeated 50 times):
  1. Select cell A1
  2. Ctrl + C (copy)
  3. Click cell D1
  4. Ctrl + V (paste)
  5. Ctrl + 1 (Format Cells)
  6. Change number format to Currency
  7. Click OK
  → 7 steps × 50 times = 350 individual actions

  WITH MACRO (recorded once, replayed with one shortcut):
  1. Record the 7 steps once
  2. Press Ctrl + Shift + M (your assigned shortcut)
  → Macro performs all 7 steps in under 1 second
  → Repeated 50 times = 50 shortcut presses vs 350 manual actions

Macro Recording in Microsoft Excel

Excel has built-in macro recording that captures every action and saves it as a VBA (Visual Basic for Applications) script.

  STEP 1: Start Recording
  Alt + T → M → R   (Tools → Macro → Record Macro)
  OR: View tab → Macros → Record Macro

  DIALOG:
  ┌────────────────────────────────────────────────┐
  │  Record Macro                                  │
  │                                                │
  │  Macro name:    [FormatCurrency         ]      │
  │  Shortcut key:  Ctrl + [m ]                    │
  │  Store macro in:[This Workbook         ▾]      │
  │  Description:   [Formats selected as currency] │
  │                                                │
  │              [OK]    [Cancel]                  │
  └────────────────────────────────────────────────┘

  STEP 2: Perform your actions normally (Excel records them)
  STEP 3: Stop Recording
  Alt + T → M → R   (same menu — now says "Stop Recording")
  OR: click the Stop button in the status bar

  STEP 4: Play back the macro
  Press Ctrl + M (or whatever shortcut you assigned)
  → All recorded steps replay automatically

Running and Managing Macros in Excel

  Alt + F8          → Open Macro dialog (run, edit, delete macros)
  Alt + F11         → Open VBA Editor (view/edit the recorded code)

  MACRO DIALOG:
  ┌────────────────────────────────────┐
  │  Macro name: [FormatCurrency  ]    │
  │                                    │
  │  [Run]  [Step Into]  [Edit]        │
  │  [Create]  [Delete]  [Options]     │
  └────────────────────────────────────┘

  "Step Into" runs the macro one action at a time —
  useful for debugging a macro that produces unexpected results.

Macro Recording in Microsoft Word

  START RECORDING:
  Alt + T → M → R   (same as Excel)
  OR: View → Macros → Record Macro

  WORD MACRO EXAMPLE — Apply a heading style and add a line:
  Record these steps:
  1. Ctrl + Home (go to document start)
  2. Ctrl + Alt + 1 (apply Heading 1)
  3. Type "Document Title"
  4. Enter (new line)
  5. Ctrl + Shift + N (apply Normal style)

  Assign to shortcut Ctrl + Shift + T
  → Every new document gets a formatted title area in 1 second

Macro Recording in PowerPoint

  View → Macros → Record Macro
  (PowerPoint's macro recording is more limited than Excel/Word)

  COMMON POWERPOINT MACRO USES:
  ✔ Apply a consistent slide layout to every selected slide
  ✔ Export all slides as PNG images
  ✔ Set all text boxes to a specific font and size
  ✔ Add a footer to all slides at once

System-Wide Macro Tools

For macros that work across all applications — not just Office — dedicated macro tools provide more flexibility.

  AUTOHOTKEY (Windows, free):
  → Script-based macros (covered in Topic 53)
  → Full control over every keystroke and mouse action

  PULOVER'S MACRO CREATOR (Windows, free):
  → Visual macro recorder — no scripting needed
  → Records mouse + keyboard actions
  → Exports as AutoHotkey script

  KEYBOARD MAESTRO (Mac, paid):
  → Most powerful Mac macro tool
  → Record or build macros visually
  → Trigger by hotkey, time, app launch, or USB event
  → Supports loops, conditionals, variables

  AUTOMATOR (Mac, free, built-in):
  → Record actions in Automator → save as workflow
  → Assign a keyboard shortcut via System Settings

Macro Security

  WARNING: Macros can contain harmful code.
  Only run macros from sources you trust.

  EXCEL MACRO SECURITY SETTINGS:
  File → Options → Trust Center → Trust Center Settings
  → Macro Settings:
  ● Disable all macros with notification (recommended)
  ○ Enable all macros (not recommended — security risk)

  WHEN OPENING A MACRO-ENABLED FILE (.xlsm):
  Excel shows a yellow bar: "Macros have been disabled. [Enable Content]"
  → Only click "Enable Content" if you trust the file source.

Macro vs Shortcut — What Is the Difference

  KEYBOARD SHORTCUT:
  One keypress → triggers ONE action
  (e.g., Ctrl + S = Save)

  MACRO:
  One keypress → triggers a SEQUENCE of actions
  (e.g., Ctrl + Shift + M = open file, format it, save it, close it)

  Use shortcuts for single actions.
  Use macros when a task requires 5+ steps that you repeat often.

Quick Reference

  APPLICATION      START RECORDING        RUN MACRO
  ────────────────────────────────────────────────────────
  Excel            Alt + T → M → R        Alt + F8 or shortcut
  Word             Alt + T → M → R        Alt + F8 or shortcut
  PowerPoint       View → Macros          Alt + F8 or shortcut
  Excel VBA Editor Alt + F11              Run button in editor
  AutoHotkey       Write .ahk script      Double-click .ahk file
  Keyboard Maestro Record in KM app       Assigned shortcut

The highest-value macros to build first are the ones you already do manually every day without thinking. If you spend 5 minutes each morning formatting a report the same way, a 20-minute macro setup eliminates that task permanently. Track the repetitive multi-step tasks you perform this week — any task you do more than 5 times is worth automating with a macro.