Excel Shortcuts That Make You Look Fast in a Test

The Excel shortcuts for interview tests that matter most are the few you use on every task: jumping to the edge of your data, selecting ranges, filling formulas down and right, locking references with F4 and turning on filters. This guide is for job seekers who want to work faster in a timed Excel test, with Windows and Mac keys for each.

Why shortcuts help in an Excel test#

Shortcuts save seconds on every step, and in a timed test those seconds add up across dozens of selections and fills. They also reduce mistakes: Ctrl+Shift+Arrow selects exactly to the last filled cell, while dragging a mouse down 200 rows often stops short or overshoots.

You don't need to avoid the mouse. Clicking a cell is often fastest. The goal is to stop scrolling and dragging on long ranges.

The Excel shortcuts for interview tests, ranked#

If you learn only ten, learn these. They cover most of the clicking in a typical test.

On some laptops, F2 and F4 need the fn key held down too.

Jump to the edge of your data#

Ctrl+Arrow (Mac: ⌘+Arrow) moves to the last filled cell in that direction, so you can reach row 500 in one keystroke. Press Ctrl+Down from A1 to reach the last row, then Ctrl+Right to reach the last column.

The jump stops just before an empty cell. That makes it a quick gap finder: if Ctrl+Down stops halfway down a column you expected to be full, there's a blank cell right below. Gaps matter in tests, because they can break a total or a lookup. The guide to moving around Excel with the keyboard covers more moves and when each one helps.

Select ranges without the mouse#

Add Shift to any move and the selection grows instead of moving:

• Shift+Arrow grows the selection one cell at a time.
• Ctrl+Shift+Arrow (Mac: ⌘+Shift+Arrow) selects to the edge of the data. From C2, Ctrl+Shift+Down selects the whole column of numbers.
• Ctrl+A (Mac: ⌘A) inside a table selects the whole table.
• Shift+Space selects the whole row.
• Ctrl+Space selects the whole column. On a Mac, Control+Space often switches the keyboard language instead, so click the column letter.

Combine them: from A2, press Ctrl+Shift+Down, then Ctrl+Shift+Right, to select every data row below the headers. See how to select ranges fast in Excel for more patterns.

Fill formulas down and right#

Fill Down copies the top cell of a selection into the cells below, and Fill Right copies the left cell across.

1. Type =B2*C2 in D2 and press Enter.
2. Select D2:D6: click D2, then press Shift+Down four times.
3. Press Ctrl+D (Mac: ⌘D).

Ctrl+Shift+Down won't help in step 2, because D3:D6 are empty: it would select all the way to the bottom of the sheet. For a long column, double-click the fill handle instead, the small square at the bottom right of the selected cell. Excel fills down as far as the column next to it has data.

D3 now holds =B3*C3, D4 =B4*C4, and so on: relative references move with each row. Ctrl+R (Mac: ⌘R) does the same across a row, so a total =SUM(C2:C6) in C7 filled right becomes =SUM(D2:D6) in D7.

If a reference must stay fixed, such as a tax rate in F1, press F4 while the cursor is on it to make it $F$1 before you fill. Each press cycles $F$1, F$1, $F1, F1.

Shortcuts for formulas and checking#

These speed up writing and checking formulas:

Ctrl+` is especially useful at the end of a test. It shows every formula instead of its result, so you can spot a typed number where a formula should be.

How to practise shortcuts so they stick#

Reading a list doesn't build the habit; using the keys on real tasks does. Pick three shortcuts at a time and use them on every task for a few days before adding more. Start with Ctrl+Arrow, Ctrl+Shift+Arrow and Ctrl+D, because almost every test task uses them.

Then use them under time pressure. The 10 Excel practice tasks to do before your test give you realistic tasks to work through with the keyboard. The guide to passing an Excel test for a job interview covers the rest of your preparation, and the Excel interview questions with answers include the show-formulas and F4 questions interviewers ask.

Practise it#

Practise each group in a live spreadsheet: jump to the edge of your data with Ctrl+Arrow and find a gap, select ranges with Shift using rows, columns and whole tables, and fill down and fill right with Ctrl+D and Ctrl+R. The exercise below is the first step of the fill lesson.