Stop 02 · Excel & SpreadsheetsTopics · 10/10

Excel Shortcuts & Productivity

In short

Watch a senior analyst in Excel and they barely touch the mouse. Learning a dozen shortcuts takes an hour and saves you that hour every week.

Keyboard shortcuts and small habits (Ctrl+Arrow to navigate, Ctrl+Shift+L to filter, F4 to lock references) that compound into meaningfully faster work over a career.

The jaadu drives an auto-rickshaw through a narrow lane past a traffic jam.

Think of it like this

The auto driver's gali shortcut

A new auto driver follows the main road and gets stuck at every signal. An experienced one knows the gali behind the market and reaches in half the time. Keyboard shortcuts are your galis: same destination, far less waiting.

Watch it happen

Ctrl+Arrow jumping through a column

Header

cursor

120

240

300

1/5You're on the header cell. Pressing Down arrow 9 times would be slow.

The big ideas

What you need to know

Move fast

Ctrl+Arrow jumps to the edge of data. Ctrl+Home goes to A1. Ctrl+PageDown switches sheets.

Select fast

Add Shift to any jump to select. Ctrl+Space selects a column, Shift+Space a row.

Filter and format

Ctrl+Shift+L toggles filters. Ctrl+T makes a Table. Ctrl+1 opens Format Cells.

F4 locks references

While editing a formula, F4 cycles B2 to $B$2 to B$2 to $B2. On Mac it's Cmd+T.

See it in code

Walk through the code

text

1Ctrl + Arrow         jump to edge of data2Ctrl + Shift + Arrow select to edge3Ctrl + Shift + L     toggle filters4Ctrl + T             format as Table5Ctrl + 1             Format Cells dialog6Alt + =              AutoSum7F4                   lock reference / repeat last action8Ctrl + ;             insert today's date

1/3Movement and selection: learn these two first. They're used constantly.

Windows Excel shortcuts. On a Mac, Ctrl is usually Cmd, and some keys differ, so check Excel's help for your version.

Save yourself the pain

Common mistakes

Oops

Trying to memorise 50 shortcuts at once.

Do this instead

Learn three a week and force yourself to use them. Muscle memory beats a cheat sheet.

Oops

Scrolling with the mouse through 10,000 rows.

Do this instead

Ctrl+Down gets you to the bottom instantly. Ctrl+Up brings you back.

Your mission

A mouse-free ten minutes

~15 min

Quick check

You're typing =B2*E1 and want E1 to stay fixed when copied. Which key helps?

Go deeper

1Learn 10 shortcuts and force yourself to use them instead of the mouse for a week.
2Practice F4 to quickly toggle between relative and absolute references.
3Time yourself on a repetitive task before and after learning the relevant shortcuts.