10 Excel shortcuts that save you real time

A 4,000-row sheet, and you are scrolling with the wheel to reach the last cell. You overshoot, you scroll back, you click one row off. Twenty seconds gone, fifteen times a day. The combinations below remove exactly that kind of movement — these are not competition tricks, they are the ones that come up most often in ordinary spreadsheet work.

Keys are given for Excel on Windows, with the macOS equivalent in brackets where it differs. On a laptop, F1 to F12 often need the Fn key held down as well.

Moving and selecting without touching the mouse

1. Ctrl + arrow: jump to the edge of the data block

Ctrl + ↓ puts the cursor on the last filled cell in the column, however far away it is. Ctrl + End goes straight to the intersection of the last used row and the last used column (Mac: Cmd + arrow, Cmd + Fn + →).

The jump stops at the first empty cell it meets: a blank row in the middle of the table means pressing twice. Conversely, if Ctrl + End throws you down to row 12,000 when your data stops at 400, those are rows that were once filled and then emptied: select the whole rows below your data, delete them (right-click → Delete, not the Delete key), then save and reopen the file. The used range is recalculated, and the workbook usually gets lighter in the process.

2. Ctrl + Shift + arrow: select a whole block

Same logic, but selecting as it goes. Ctrl + Shift + ↓ grabs the column down to the bottom of the data, Ctrl + Shift + End grabs everything as far as the bottom-right corner. Two useful additions: Ctrl + Space selects the entire column, Shift + Space the entire row.

Merged cells break this behaviour: the selection either expands to cover the whole merged area or refuses to extend at all. If the table is going to be sorted, filtered or exported, avoid merges and centre the text across several columns instead.

3. Ctrl + Shift + L: switch the filters on

Adds or removes the filter arrows on the header row (Mac: Cmd + Shift + F). Follow it with Alt + ↓ on a header cell to open the filter drop-down without the mouse, then move with the arrow keys and confirm with Enter.

Entering data without repeating yourself

4. Ctrl + Enter: fill an entire selection in one go

Select a range, type your value or your formula, then confirm with Ctrl + Enter instead of Enter: the entry is copied into every selected cell, with relative references adjusted for each one. This is the shortcut that replaces dragging the fill handle down 800 rows with the mouse.

It also works on a non-contiguous selection (Ctrl + click on several areas), which is handy for filling only the empty cells in a column, picked out beforehand with F5 → Special → Blanks.

5. Filling down and filling right

Select the model cell plus the cells to be filled below it, then run the fill. In an English-language Excel, filling down is Ctrl + D and filling right is Ctrl + R. Watch out on a machine set to another language, because those letters follow the local words: in a French Excel, filling down sits on Ctrl + B and filling right on Ctrl + D. Do not test blind — a wrongly guessed shortcut overwrites the neighbouring column (Ctrl + D in a French Excel fills to the right) or simply applies bold (Ctrl + B in an English one). Work out which version you are in first, or go through Home → Fill → Down, which does not depend on the language.

Filling overwrites the formatting of the destination cells as well as their contents. If you only want the formula, copy and then use Paste Special → Formulas.

6. Alt + =: the total without writing the formula

Put the cursor under a column of numbers and press Alt + = (Mac: Cmd + Shift + T): Excel inserts =SUM() with a guessed range. And the guess is exactly where it catches you out — it stops at the first empty or non-numeric cell, so a separator row halfway down the column leaves the whole top of the table out of the total. The opposite happens when the column already contains subtotals: Excel picks up those and ignores the detail rows. Either way, look at the range outlined with the dashed border before you confirm.

7. Ctrl + ;: today's date, frozen

Ctrl + ; inserts today's date as a constant value, Ctrl + Shift + ; inserts the time (depending on your keyboard, that second combination may read as Ctrl + Shift + :). It has nothing to do with the TODAY() function, which recalculates every time the file is opened and every time the sheet recalculates: for a data-entry timestamp, an invoice or a tracking log, the frozen value is the one you want.

Formatting, and getting out of trouble

8. F4: lock a reference, or repeat the last action

While editing a formula, with the cursor sitting on a reference, F4 cycles through A1 → $A$1 → A$1 → $A1 (Mac: Cmd + T). It is the quickest way to lock a column of rates before copying a formula across a whole grid.

Outside edit mode, the same key repeats the last action: apply a fill colour to one cell, click another, F4, and the colour is reproduced. The same goes for borders, inserting rows or setting row height. Ctrl + Y does the same thing as F4 outside edit mode — it is the same Repeat command; it only behaves as a redo when you have just undone something with Ctrl + Z.

9. Alt + Enter: a line break inside the cell

In a cell you are editing, Alt + Enter inserts a line break (Mac: Option + Enter, sometimes Ctrl + Option + Enter on older versions). Excel switches Wrap Text on for that cell automatically.

One thing worth knowing before an export: that line break is a real character (code 10) stored in the cell. Saving as CSV forces the field to be wrapped in quotation marks, and some import tools read it as the end of a record — hence rows that arrive split in two. If the file is going to be read somewhere else, swap those breaks for a plain separator: =SUBSTITUTE(A2,CHAR(10)," — ").

10. Paste Special, values only

On recent Microsoft 365 builds, Ctrl + Shift + V pastes values on their own. On everything else, the old inherited sequence still works: Alt + E + S, then V, then Enter (Mac: Cmd + Ctrl + V opens the dialog box).

This is the move to make before sending somebody an extract from a workbook: it strips out formulas pointing at sheets that are not there, along with links to other files. Conditional formatting, on the other hand, survives the paste — to get rid of it, go through Home → Conditional Formatting → Clear Rules. A range pasted as values is also noticeably lighter than a range of formulas.

When a shortcut seems to do nothing

• The arrow keys scroll the sheet instead of moving the cursor: Scroll Lock is on. It shows in the status bar at the bottom; on a laptop with no dedicated key, use the Windows on-screen keyboard.
• Nothing happens on F2, F4 or F12: the Fn key is required, or the keyboard driver is giving priority to the media functions.
• Excel for the web: the browser intercepts several combinations before Excel ever sees them. Use the ribbon key tips (press Alt, then the letters that appear) or switch to the desktop app for those cases.
• The workbook is protected or opened read-only: entry and formatting shortcuts are simply ignored, with no error message.

What no shortcut will do for you

Some jobs are not typing-speed problems. Four common cases where stepping outside Excel is quicker than rigging up a helper column:

• Deduplicating a list pasted in from elsewhere. Data → Remove Duplicates changes the file in place and does not show you what it took out. For a list of addresses or reference codes to clean up before feeding it back in, a detour through the duplicate line remover is easier to follow: you see the result before you copy it across.
• Making capitalisation consistent. UPPER(), LOWER() and PROPER() mean a helper column and then a paste as values, and PROPER gets “McDonald”, “MacLeod” and names with particles such as “van der Berg” wrong. For a single column, changing the case of a text saves the detour.
• Checking a percentage. Ctrl + Shift + % applies the format, it calculates nothing — and applying a 20% rise twice takes you to 1.44 times the original rather than 1.2, which is still a classic month-end slip. The percentage calculator gives you a cross-check in ten seconds.
• Counting the days between two dates. DATEDIF does not appear in Excel's function wizard and behaves surprisingly on part-months. For a one-off gap you want to verify, working out the difference between two dates gives you the answer directly.

All four of these tools run entirely in the browser: your data is not sent anywhere and there is nothing to install.

Where to start

Nobody remembers ten shortcuts at once. Take three of them this week — Ctrl + Shift + arrow, Ctrl + Enter and paste as values cover most of the mouse round trips on their own — and make yourself stop using the slow method, even when it feels quicker in the moment. The other seven will each turn up on the day you meet the repetitive movement it removes.