Excel keyboard shortcuts worth learning, and how to make them stick

Watch someone who is fast in Excel and you will notice that their hands rarely leave the keyboard. They jump to the bottom of a 3,000-row column in a fraction of a second, select a whole table without dragging, fill a formula down and lock a reference while they type. None of it is magic. It is about twenty-five shortcuts, used so often that they stopped being a conscious decision.

You don't need to learn the hundreds of shortcuts in Excel's lists. Most of them you will never use. This guide covers the ones that save real time in everyday work and in timed tests, for Windows and for Mac, grouped in the order that makes sense to learn them. At the end is a simple way to practice them until they stick, which is the part most shortcut lists leave out.

Why it is worth the effort

Speed is the obvious reason, and it is real. A trip to the mouse and back costs a second or two, and someone who works in spreadsheets all day makes that trip hundreds of times. But speed is not the only reason, and for many people not the main one.

Shortcuts are more precise. Dragging down a long column, you stop a row too early or a row too late, and the formula is wrong by one row without any warning. Ctrl+Shift+Down stops exactly at the last filled cell, every time. Many of the range errors in real workbooks come from a mouse that slipped.

They keep you in the flow. When your hands stay on the keyboard, your attention stays on the numbers. Hunting for a button on the ribbon breaks the train of thought more than you notice.

They show. In an interview task or a screen-share with a new manager, fluent use of the keyboard is one of the clearest signs that someone actually works in Excel, not just with it.

How to read a shortcut

Shortcuts are written in two ways, and they mean different things:

• Keys joined with + are held down together. Ctrl+Shift+Down means: hold Ctrl and Shift, press Down, let go.
• Keys separated by commas are pressed one after another. Alt, H, O, I means: press and release Alt, then H, then O, then I. These are the ribbon's key tips on Windows, covered further down.

On a Mac, Cmd (⌘) usually takes the place of Ctrl, Option (⌥) the place of Alt, and Return the place of Enter. Usually, but not always: some Mac shortcuts use Ctrl, and some use a completely different key, so this guide gives both. Every shortcut has its own page in our shortcut list with the Windows and Mac keys side by side.

Moving around

The first group replaces the mouse and the scroll bar for getting from one place to another. These are the ones to learn first, because you use them every few seconds.

• Enter confirms what you typed and moves down; Tab confirms and moves right. Shift+Enter and Shift+Tab go the other way. Typing a row of data with Tab and then pressing Enter takes you back to the first column of the next row, just like a typewriter.
• Ctrl+Arrow (Cmd+Arrow on a Mac) jumps to the edge of the data: the last filled cell before a blank in that direction. In a column of 3,000 numbers, Ctrl+Down takes you to the bottom at once. Press it again and you jump to the next block of data, or to the very last row of the sheet if there is none.
• Ctrl+Home goes to A1 and Ctrl+End goes to the last used cell, the bottom-right corner of everything that has been used. On a Mac they are Fn+Ctrl+Left and Fn+Ctrl+Right. If Ctrl+End lands far below your data, something down there was once filled in or formatted.
• F5 (Ctrl+G on a Mac) opens Go To, where you type a cell address such as K250 and press Enter. Faster than scrolling for any cell you can name.
• Ctrl+PageDown and Ctrl+PageUp move to the next and previous sheet. On a Mac, Option+Right and Option+Left.

The jump to the end of your data lesson puts the most important one into practice.

Selecting

The second group is about selecting ranges without dragging, which is slow and imprecise on anything longer than a screen.

• Shift+Arrow extends the selection one cell at a time.
• Ctrl+Shift+Arrow (Cmd+Shift+Arrow on a Mac) selects to the edge of the data. This is how you select a whole column of numbers, exactly, in one move. It is also how you avoid the most common range mistake in formulas: =SUM(B2:B99) when the data goes to row 100.
• Ctrl+A (Cmd+A) selects the current region, the whole block of data around the active cell. Press it again to select the entire sheet.
• Ctrl+Space selects the whole column and Shift+Space the whole row. On a Mac, Ctrl+Space may be taken by the keyboard language switcher; you can change that in System Settings.

These combine with the moving keys. To select from the active cell to the end of a table, press Ctrl+Shift+Down and then Ctrl+Shift+Right. The select a whole table and select rows, columns and everything lessons drill them.

Editing

The third group is about changing what is in the cells.

• F2 edits the active cell with the cursor at the end, so you can fix a formula without retyping it or reaching for the formula bar. On a Mac, Ctrl+U. Inside the cell, the arrow keys now move the cursor through the text instead of moving to another cell.
• Esc cancels the entry and puts back what was there before. Use it when you have started typing in the wrong cell.
• Ctrl+Enter fills every selected cell with what you typed. Select a range, type a value or a formula, press Ctrl+Enter, and it goes into all of them at once, with relative references adjusted for each cell.
• Alt+Enter (Option+Return on a Mac) starts a new line inside the cell, for an address or a longer note.
• Ctrl+Z undoes and Ctrl+Y redoes. Excel remembers many steps, so you can undo a whole sequence of changes.
• Ctrl+C, Ctrl+X and Ctrl+V copy, cut and paste, as everywhere else.
• Ctrl+Alt+V (Ctrl+Cmd+V on a Mac) opens Paste Special, where you choose to paste only values, only formats, or to transpose rows into columns. Pasting values is how you turn formulas into fixed numbers.
• Ctrl+- (Cmd+- on a Mac) deletes the selected rows or cells. Select a whole row with Shift+Space first and it deletes the row without asking.

Practice the first of these in editing a cell without retyping it.

Filling and formulas

The fourth group is where shortcuts start to change how you build sheets, not just how fast you move.

• Ctrl+D fills down: it copies the cell above into the selected cells. Select the formula and the empty cells under it and press Ctrl+D, and the whole column is filled, with references shifted for each row. Ctrl+R fills right in the same way. On a Mac, Cmd+D and Cmd+R.
• Alt+= (Cmd+Shift+T on a Mac) inserts AutoSum. In the cell under a column of numbers, it writes the SUM and guesses the range:

• F4 toggles absolute references while you edit a formula. With the cursor on a reference, press it once for $E$1, again for E$1, again for $E1, and once more to go back to E1. On a Mac, Cmd+T. It is the fastest way to lock a reference to a fixed cell before you fill a formula down:

• Shift+F3 opens Insert Function, which shows the arguments of the function you are typing. Useful when you can't remember the order of SUMIFS's arguments.

The fill a formula down and right and AutoSum, undo and redo lessons drill this group, and the summary table lesson combines F4 and Ctrl+D the way you would in a real report.

A tip that saves a lot of time: while typing a formula, you can select its ranges with the keyboard. Type the equals sign, SUM and the opening parenthesis, press the arrow keys to move to the first cell, hold Shift and press Ctrl+Down to select to the end, then type the closing parenthesis and press Enter. The click cells into a formula lesson shows the mouse version of the same idea.

Checking formulas

Two more shortcuts are worth knowing for when a sheet gives a number you don't trust:

• Ctrl+` (the grave accent, on the key to the left of 1 on a US keyboard) shows every formula on the sheet instead of its result. Press it again to go back. It is the quickest way to spot a cell where someone typed a number over a formula.
• Ctrl+[ on Windows selects the cells the active formula reads from, even on another sheet. Use it to follow a number back to where it comes from.

Formatting

You will use these less often, but they replace several clicks each time:

• Ctrl+1 (Cmd+1) opens Format Cells, where every number, date, alignment and border format lives. It is the quickest fix for a date that shows as a number.
• Ctrl+Shift+5 applies the percent format, on both Windows and Mac.
• Ctrl+9 hides the selected rows and Ctrl+0 hides the selected columns.

Tables and filters

• Ctrl+T turns a range into an Excel table, with headers, filter buttons and banded rows, and ranges that grow when you add data. It is the same on a Mac.
• Ctrl+Shift+L (Cmd+Shift+F on a Mac) turns filters on or off for the current range. Opening a filter's drop-down is also the quickest way to see every distinct value in a column.

Workbooks and sheets

• Ctrl+S saves. Press it often. If the workbook lives in OneDrive or SharePoint with AutoSave on, it saves continuously anyway.
• Shift+F11 inserts a new sheet.
• Ctrl+N creates a new workbook, Ctrl+W closes the workbook and Ctrl+Tab switches to the next open workbook.

The last three are also browser shortcuts: new window, close tab and next tab. That is why no web page can catch them, including our grid and many online Excel tests. Their pages explain them, and you try them in Excel itself. Ctrl+T has the same problem in a browser, so learn that one in Excel too.

Freeze Panes, which keeps the header row on screen while you scroll, has no shortcut of its own, but the key tips below reach it. The guide to locking cells covers freezing rows, protecting sheets and the F4 lock in formulas.

The ribbon from the keyboard

On Windows, press and release Alt and letters appear on every tab and button of the ribbon. Press the letters in turn to reach any command without the mouse. Alt, H, O, I autofits the width of the selected columns, for example: H for the Home tab, O for Format, I for AutoFit Column Width.

You don't need to memorize these. Press Alt and read the letters as you go. After a few times, the sequences for the commands you use most become muscle memory on their own, and they work for commands that have no other shortcut. Key tips are a Windows feature; on a Mac, the menu bar and the shortcuts in this guide do the same job.

Shortcuts on a Mac

Excel for Mac has nearly all the same shortcuts, but three things trip up people who switch:

• Cmd and Ctrl are not interchangeable. Most shortcuts that use Ctrl on Windows use Cmd on a Mac (Cmd+C, Cmd+D, Cmd+1), but some still use Ctrl (Ctrl+U to edit, Ctrl+G for Go To, Ctrl+9 to hide rows). When a shortcut doesn't work, try the other key.
• The function keys belong to the Mac by default: F2 changes the screen brightness instead of editing. Hold Fn while pressing them, or turn on "Use F1, F2, etc. keys as standard function keys" in System Settings.
• Control with the arrows switches desktops in macOS, so Excel for Mac uses Cmd+Arrow to jump to the edge of the data and Cmd+Shift+Arrow to select to it.

MacBooks have no Home, End or PageDown keys. Fn plus the arrow keys stands in for them, which is why going to A1 is Fn+Ctrl+Left.

Shortcuts in Google Sheets

Google Sheets uses most of the same everyday shortcuts as Excel: Ctrl+Arrow and Ctrl+Shift+Arrow, Ctrl+D and Ctrl+R, Ctrl+Enter, F2 to edit, F4 for absolute references, and Ctrl+Space and Shift+Space for columns and rows. Formatting and menu shortcuts differ more. Press Ctrl+/ (Cmd+/ on a Mac) in Google Sheets to see the full list for your browser. Our guide to Google Sheets and Excel covers the other differences.

The twenty to learn first

If you only learn a few, learn these, roughly in this order:

How to make shortcuts stick

Reading a list of shortcuts doesn't make you faster. Using them does, and the first few days are slower than using the mouse, which is why most people give up. A few habits get you through that stage:

• Learn in groups of three to five. Pick one group from this guide, such as moving around, and ignore the rest for a week. Shortcuts that belong together are easier to remember than a random list.
• Use them on real work at once. The moment you catch yourself reaching for the mouse to do something you have a shortcut for, stop and use the shortcut instead, even if it is slower this time.
• Drill them on purpose. Five or ten minutes a day of focused repetition beats an hour once. Every drillable shortcut page has a small grid where you practice the keys until your fingers do it without thinking.
• Measure yourself. The shortcut speed-run times you on a series of shortcuts. Do it before you start and again after two weeks, and you can see the difference.
• Take the mouse away. For ten minutes, put the mouse out of reach and do your normal work. It is frustrating, and it is the fastest way to find out which shortcuts you are still missing.

Two weeks of this is usually enough for a group to become automatic. Then pick the next one.

Shortcuts in Excel tests

Online Excel tests are timed, and the keyboard is where most of the spare minutes come from. Selecting a range with Ctrl+Shift+Down instead of dragging, filling with Ctrl+D instead of copying and pasting, and pressing F4 instead of typing dollar signs each save a few seconds, and in a test with twenty tasks those seconds add up to minutes.

Some tests also ask about shortcuts directly, as knowledge questions: "Which shortcut fills the selected cells with the content of the cell above?" or "What does F4 do while editing a formula?". If you have used them, these are free points.

Two things to watch for in browser-based tests. The browser shortcuts above (Ctrl+N, Ctrl+W, Ctrl+Tab) may close or change your test tab, so avoid them. And if you normally work on a Mac, check whether the test simulator expects Windows keys, because some do. Our job interview guide has more on how to prepare.

Summary

You don't need hundreds of shortcuts. About twenty-five cover nearly everything: Enter, Tab and Ctrl+Arrow to move, Ctrl+Shift+Arrow and Ctrl+A to select, F2, Esc and Ctrl+Enter to edit, Ctrl+D, F4 and Alt+= to build formulas, and Ctrl+1 and Ctrl+Shift+L for formats and filters. On a Mac, most of them use Cmd, and the arrow shortcuts always do.

Learn them a group at a time, use them on real work straight away, and drill them for a few minutes a day. The lessons and shortcut pages below are where to start.