Excel Shortcut Keys: The Daily Hotkeys That Save Real Time

Excel shortcut keys are the small habits that separate a spreadsheet user from someone who actually moves through a sheet. You can do every job on the ribbon, sure. But Ctrl+C, Ctrl+V, F2, F4, Ctrl+Arrow — those are the keys people press without thinking, and they are the reason long sheets feel manageable instead of exhausting.

This guide walks through the daily set: copy, paste, undo, redo, edit, absolute references, navigation, formatting, inserting rows, merging cells, subscript, and the Mac equivalents. Nothing here is exotic. The goal is the set most accountants, analysts, and admins reach for every hour, written out with the keys, the context, and the small footnotes that matter when you switch from a desktop Windows machine to a MacBook on the train.

If you remember half the shortcuts on this page you will already feel faster. If you remember them all, you are using Excel the way the keyboard team intended.

A quick note on layout. Most of the keystrokes here use the main keyboard row, not the numeric keypad. Some shortcuts behave differently on the keypad, especially the plus and minus keys around Ctrl+Shift++. If a shortcut feels broken, try the version on the main row first. The other note is that older Excel versions sometimes kept legacy shortcuts that newer versions retired. Where that matters, both keystrokes are listed, with the modern one first.

The starter pack: copy, paste, cut, undo, redo

Every Excel session starts here. Ctrl+C copies the selected cells, Ctrl+X cuts them, and Ctrl+V pastes them in. The clipboard handles values, formulas, and formatting in one go, which is why your conditional formats sometimes travel along whether you wanted them to or not. When that happens, switch to Ctrl+Alt+V to open Paste Special, then pick Values, Formulas, or Formats from the dialog.

Ctrl+Z undoes. Ctrl+Y redoes. Both step through the same history stack, and Excel keeps roughly the last 100 actions in memory. Hold down Ctrl+Z and watch the sheet unwind one move at a time. If you have ever lost a tab full of work to a stray Delete key, this is the shortcut that pulls it back from the brink.

On macOS the layout barely changes. Cmd replaces Ctrl on most edit keys, so Cmd+C, Cmd+V, Cmd+X, Cmd+Z, and Cmd+Y do exactly what their Windows cousins do. There is no Insert key on a MacBook, which trips up new switchers, but the shortcuts you actually use stay almost identical. See excel for mac for the full list of differences.

F-keys: small buttons, big help

The function row across the top of the keyboard is where Excel hides some of its sharpest tools. F2 is the one you will reach for most. Tap F2 and Excel drops you into edit mode at the end of the active cell, cursor blinking, ready for tweaks. No double-click. No re-typing the whole formula because you fat-fingered one bracket.

F4 has two jobs. Inside a formula, it cycles through absolute reference styles: A1, then $A$1, then A$1, then $A1, then back to A1. Outside a formula, it repeats the last action. Apply a fill colour to one cell, click somewhere else, hit F4 and the same fill drops onto the new selection. The reference trick alone is the reason you should keep one finger near F4 whenever you are building formulas. See absolute reference for a deep dive.

The rest of the row carries useful but rarer tools. F1 opens Help. F5 opens Go To. F7 launches spell check. F9 recalculates the workbook. F11 builds a chart on a new sheet from the current selection. F12 opens Save As. On a Mac, you may need to press fn at the same time, since the function row is mapped to brightness and volume by default unless you have flipped the setting in System Preferences.

Navigation: moving without the mouse

Long sheets punish anyone who navigates with the scroll wheel. The keyboard is the answer. Ctrl+Arrow jumps to the edge of the current data block in any direction. Press Ctrl+Down on a column of 50,000 rows and you are at the last populated row instantly. Press it again and Excel jumps to the next empty cell below, then the next data block, and so on.

Ctrl+Home returns to A1 from anywhere. Ctrl+End jumps to the bottom-right cell of the used range, which is usually further out than you would think. Add Shift to any of these and you select as you move, so Ctrl+Shift+End grabs everything from the cursor to the last cell of the used range in one keystroke. Combined with Ctrl+Shift+Arrow, you can select a 10,000-row column in two keystrokes.

Page Up and Page Down scroll a screen at a time. Alt+Page Down moves a screen right, Alt+Page Up moves a screen left. Ctrl+Page Down jumps to the next sheet tab, Ctrl+Page Up to the previous. The tab shortcuts are gold when you are flicking between source data, calculations, and an output sheet. The arrow keys themselves are sometimes broken by Scroll Lock — see arrow keys not working in excel if your cells stop moving on press.

Inserting rows, columns, and cells

The insert shortcut is one keystroke that solves three jobs. Select a row header and press Ctrl+Shift++ (Ctrl, Shift, and the plus key together) and Excel inserts a blank row above. Select a column header and the same shortcut inserts a column to the left. Select a single cell and a dialog asks whether you want to shift cells down, shift cells right, insert an entire row, or insert an entire column. Ctrl+- (Ctrl and minus) does the opposite for delete.

The Alt key gives you ribbon access by pressing the underlined letter on each menu. Alt, then I, then R inserts a row in older Excel. Alt, then H, then I, then R works in modern Excel ribbon mode. The keystrokes look long, but Excel highlights each letter as you press it, so you do not have to memorise the whole chord at once. Hit Alt and the on-screen hints appear above every ribbon tab.

Custom shortcuts are also fair game. Add an Insert Row icon to the Quick Access Toolbar and Excel assigns it Alt+1 through Alt+9 in order. That puts a one-handed insert on the keyboard for the action you reach for most. The same trick works for Format Cells, Filter, or any ribbon command that lacks a short, sharp shortcut. See excel insert for the row-only walkthrough.

Merge cells: the keystroke that almost exists

Excel does not ship a single shortcut key for Merge Cells, which is a regular complaint. The way round it is the ribbon access combo. Press Alt, then H, then M, then M and Excel merges the selected range and centres the text. The same menu has variations: Alt, H, M, A merges across rows; Alt, H, M, C is merge and centre; Alt, H, M, U unmerges. The letters spell out the underlined hints on the Home tab Merge & Center button.

On macOS the path is Ctrl+Option+M, which is mapped to merge and centre by default. Cmd+1 opens Format Cells if you would rather build the merge from the Alignment tab. Either way, plan ahead before merging — merged cells break sorting, filtering, and any formula that copies down the column. The polite habit is to merge only at the very top of a sheet for headings and never inside data.

If you find yourself merging a lot, add the Merge & Center button to the Quick Access Toolbar. Excel assigns it Alt+1, Alt+2, and so on depending on its position, and you end up with a single one-handed shortcut for the most common merge scenarios. Full step-by-step in excel merge and merge cells in Excel.

Subscript, superscript, strikethrough

Word handles subscript and superscript with Ctrl+= and Ctrl+Shift++ directly. Excel makes you take one extra step. Select the characters you want to subscript inside a cell, open Format Cells with Ctrl+1, switch to the Font tab, tick Subscript, click OK. Tedious if you do it twice in a row, which is why the Quick Access Toolbar trick comes up so often. Add the Subscript command to the Quick Access Toolbar and Excel assigns it a number-based shortcut: Alt+1, Alt+2, or Alt+3 depending on its position.

Strikethrough is the friendlier one. Ctrl+5 toggles strikethrough on the selected cells or characters. The keystroke is the same on Windows and Mac, and it works for a single character inside a cell as well as for whole cells. Superscript uses the same Format Cells routine as subscript — Ctrl+1, Font tab, tick Superscript, OK. Build the Quick Access Toolbar habit once and you save dozens of clicks a week. See excel strikethrough shortcut for the full path.

Cell formatting in general lives behind Ctrl+1. Once the Format Cells dialog is open, every tab is one Alt+letter away: Alt+N for Number, Alt+A for Alignment, Alt+F for Font, Alt+B for Border, Alt+P for Fill, Alt+R for Protection. Memorise Ctrl+1 first. The rest fall out naturally.

Mac shortcuts: what changes, what does not

Most Mac shortcuts replace Ctrl with Cmd. Copy is Cmd+C, paste is Cmd+V, undo is Cmd+Z, redo is Cmd+Y, edit is fn+F2 (or Control+U as a Mac-only alternative). Find is Cmd+F. Save is Cmd+S. Bold is Cmd+B. Italic is Cmd+I. The pattern holds for almost every Windows shortcut you already know.

Where Mac diverges is the F-keys. By default the function row on a MacBook controls brightness, volume, Mission Control, and so on. To use F2 in Excel you press fn+F2. The fix is in System Settings → Keyboard → “Use F1, F2, etc. keys as standard function keys.” Flip the toggle and the F-keys behave the way they do on Windows.

The hardware brightness keys then need fn to work, which most Excel users find a fair trade. Once flipped the change is sticky: every Mac app that expects F1–F12 (Word, browsers, Visual Studio Code) gets the same treatment, which is usually what power users want anyway.

The Insert key does not exist on a Mac keyboard. Workarounds: Ctrl+Option+M for merge and centre, Cmd+Shift++ for inserting rows or columns from the row and column headers, and the right-click context menu for the rest. Cmd+T toggles the formula bar focus on Mac, which is the closest thing to F2 if your fn key is awkward to reach. See mac version of excel for the side-by-side list.

Redo on Mac is Cmd+Y in modern Excel, although older versions and some other Mac apps use Cmd+Shift+Z. Excel sticks with Cmd+Y to match Windows. Undo is always Cmd+Z. If Cmd+Y opens a different window, you are probably outside of Excel — Safari, for instance, uses Cmd+Y for history. See redo and undo for the full undo and redo behaviour.

Build your own shortcuts with the Quick Access Toolbar

The Quick Access Toolbar sits above or below the ribbon, holding any commands you pin to it. Right-click any ribbon button and choose Add to Quick Access Toolbar. Excel adds a small icon to the bar, and every icon there gets a keyboard shortcut: Alt+1 for the first item, Alt+2 for the second, and so on up to Alt+9. Drag items into the order that suits the work you do most.

The trick scales. Want a one-key strikethrough? Add the Strikethrough command to slot 1 and press Alt+1. Want a subscript shortcut Excel never built? Add Subscript to slot 2 and press Alt+2. Want Filter, Sort, Merge & Center, and Paste Values on Alt+3 through Alt+6? Add them in order. The toolbar saves with the workbook, or with your user profile if you tick “For all documents” when you customise it. Either way, your most-used shortcuts move to your fingertips.

Power users sometimes hide the ribbon entirely and rely on the Quick Access Toolbar plus keyboard shortcuts. Ctrl+F1 collapses the ribbon, Ctrl+F1 brings it back. The screen real estate jumps, and you still have full access through Alt and the Alt+number toolbar shortcuts. For a longer reference of the keystrokes behind every command, the excel shortcuts and excel hotkeys guides break it down by job.

One last piece. Excel for the web supports most of the same Ctrl shortcuts, but the Alt-ribbon path is replaced by Alt+Windows on Windows and Option+Control on Mac. The web app lists every supported shortcut behind Help → Keyboard Shortcuts (Ctrl+/), which is itself a shortcut worth learning.

The cross-platform behaviour is consistent enough that switching between desktop and browser does not throw off muscle memory after the first session. A nice bonus is that the web app exposes Alt+Q to jump straight to the Tell-Me search box, which finds any command by name and shows the keystroke next to the result. Handy when you forget where Excel hides a one-off action you only use twice a year.

The deeper you go, the more obvious it becomes that shortcuts are not about speed alone. They keep you in flow. Every trip to the mouse breaks attention. Every shortcut keeps your eyes on the data. By the time the daily set is automatic, you will reach for keys you used to ignore and wonder how you ever got through a month-end without them.

The full excel keyboard shortcuts reference is worth bookmarking for the ones you do not yet use every day, and the cheat sheet is the page to print and pin above your monitor while the habits settle.