7 Excel Shortcuts Your Coworkers Don’t Know (But Will Thank You For)

We all know Ctrl+C and Ctrl+V. But there’s a tier of Excel shortcuts that even power users often miss — and they save hours of repetitive work.

Here are 7 genuinely useful Excel shortcuts that fly under the radar:

1. Open Any Drop-Down Menu Instantly

Windows: Alt + ↓
Mac: Opt + ↓

This one shortcut works in four different scenarios:

• Filter headers — Opens the filter drop-down without clicking
• Data validation lists — Reveals your dropdown options
• Auto-fill suggestions — Shows unique entries from the column above
• Formula arguments — Displays available options when writing formulas

Why it matters: No more mouse hunting. Your fingers stay on the keyboard, your eyes stay on the data.

2. Repeat Your Last Action Anywhere

Windows: F4 or Ctrl + Y
Mac: Cmd + Y

Applied a fill color? Changed number formatting? Inserted a shape? Hit F4 and Excel repeats that exact action on any other cell instantly.

Pro tip: This works for almost any formatting action. Bold a cell, then F4 to bold others. Apply currency format, then F4 to apply it elsewhere.

3. Select an Entire Column (Stopping at Blanks)

Windows/Mac: Ctrl + Shift + ↓

Click the top cell of a column, then hit this combo. Excel selects all the way down — until it hits a blank cell.

Use case: Perfect for selecting data ranges without dragging through thousands of rows.

Gotcha: If your column has blank cells mid-data, this stops at the first gap.

4. Duplicate a Worksheet Tab

Windows: Ctrl + drag
Mac: Opt + drag

Click a sheet tab, hold Ctrl (or Opt on Mac), and drag right. A small + icon appears. Release — and you’ve duplicated the entire sheet with all formatting and formulas intact.

Why it’s a game-changer: No more right-click → Move or Copy → Create a Copy → OK. One gesture, done.

5. Jump Between Worksheet Tabs

Windows: Ctrl + PgUp / Ctrl + PgDn
Mac: Fn + Cmd + ↑ / Fn + Cmd + ↓

Cycle through all sheets in your workbook without touching the mouse.

Pro tip: Use this to quickly audit multi-sheet models — your fingers never leave the keyboard.

6. Insert Today’s Date or Current Time

Date: Ctrl + ;
Time (Windows): Ctrl + Shift + ;
Time (Mac): Opt + ;

Excel instantly enters the current date or time from your system clock — no typing, no =TODAY() formulas that update tomorrow.

Use case: Timestamping entries in logs, timesheets, or tracking sheets.

Bonus: Want both? Type the date shortcut, hit Space, then type the time shortcut.

7. AutoSum a Column in One Stroke

Windows: Alt + =
Mac: Opt + Shift + T

Click below a column of numbers. Hit this shortcut. Excel writes the SUM() formula for you, guessing the range. Press Enter to confirm.

Why it’s better than clicking the AutoSum button: It’s instant, precise, and works anywhere in your sheet.

Practice These in Shortcut Kings

Reading shortcuts is one thing. Memorizing them is another.

Head to shortcutkings.com and practice these Excel shortcuts in a game format. Build muscle memory so they become automatic — not something you have to think about.