Excel Shortcuts Cheat Sheet: 80+ Keyboard Shortcuts for 2026

Why Excel Keyboard Shortcuts Matter

If you're still reaching for your mouse every time you want to bold a cell, copy a range, or move between worksheets, you're leaving significant time on the table. Excel keyboard shortcuts let you execute the same actions in a fraction of the time — and when you're working with large datasets or building complex spreadsheets, those seconds add up fast. Professional Excel users who've mastered the keyboard can work 30-50% faster than mouse-dependent colleagues doing the same tasks.

This cheat sheet covers the most useful Excel shortcuts organized by task category. You don't need to memorize all 80+ shortcuts at once — start with the navigation and selection shortcuts, add the formatting ones, and let muscle memory build naturally. The goal isn't to be a shortcut collector; it's to eliminate the specific friction points in your daily Excel workflow. Review our Excel formulas guide alongside this shortcut reference to combine formula knowledge with faster execution.

All shortcuts are listed for both Windows and Mac. Where shortcuts differ between Excel versions (Microsoft 365, Excel 2019, Excel 2016), any differences are noted. Most shortcuts in this guide work across all modern Excel versions on both platforms.

One effective way to build shortcut habits is to print a cheat sheet and tape it to your monitor for one week. Look at it every time you reach for the mouse, and instead try the keyboard equivalent. After a week of deliberate practice, the shortcuts you use most will start to feel automatic. After three weeks, you won't be able to remember why you ever clicked the Bold button in the Ribbon.

Excel power users typically distinguish between "always use keyboard" shortcuts (navigation, selection, undo, save) and "situational" shortcuts (chart creation, pivot table operations) where the mouse might still be faster. Focusing your initial practice on the always-use-keyboard shortcuts gives you the biggest productivity gain per hour of learning investment.

Customizing your Quick Access Toolbar (QAT) is another way to create personal shortcuts. The QAT is the small row of icons above the Ribbon in Excel. Press Alt+1 to activate the first QAT button, Alt+2 for the second, and so on. Adding your most-used commands (Paste Special, Filter, Sort, Print Preview) to the QAT gives you single-keystroke access via Alt+number. This effectively creates custom shortcuts for operations that don't have default keyboard shortcuts.

Navigation Shortcuts

Navigation shortcuts replace almost all mouse-based cell movement. Once these become muscle memory, you'll rarely need to click to move around a spreadsheet. The Ctrl+Arrow shortcut is especially powerful — it jumps to the edge of a data region, so you can move from the first row to the last row of a 50,000-row dataset in a single keystroke.

Windows / Mac navigation shortcuts:

• Ctrl+Home / Cmd+Home — Go to cell A1
• Ctrl+End / Cmd+End — Go to the last used cell in the sheet
• Ctrl+Arrow key / Cmd+Arrow key — Jump to the edge of the current data region
• Ctrl+G / Cmd+G or F5 — Open Go To dialog (jump to any named range or cell address)
• Ctrl+Page Up / Fn+Ctrl+Up — Move to the previous worksheet tab
• Ctrl+Page Down / Fn+Ctrl+Down — Move to the next worksheet tab
• Ctrl+F6 — Switch between open workbooks
• Alt+Tab — Switch between Excel and other applications (Windows)
• F6 — Move between panes in a split window

The Ctrl+Arrow combination with Shift added becomes a selection shortcut: Ctrl+Shift+Arrow selects from the current cell to the edge of the data region. This is the fastest way to select an entire column of data without scrolling. If you're looking to manage data cleaning alongside navigation, our guide on how to find duplicates in Excel covers detection methods that pair well with these navigation techniques.

One navigation feature that often goes unnoticed is the Name Box on the left side of the formula bar. You can click the Name Box and type any cell address (like "AA1000" or "Sheet2!B5") to jump there instantly — no scrolling required. You can also type a range address like "A1:Z100" and press Enter to select that entire range.

This isn't a keyboard shortcut per se, but using Ctrl+G (Go To) achieves a similar result without the mouse. The Go To Special option (Ctrl+G, then click Special) lets you select cells by type — blanks, formulas, constants — which is invaluable for data cleaning work.

For spreadsheets with multiple frozen rows or split panes, F6 cycles between different pane sections. If you have both frozen header rows and frozen left columns (creating a locked quadrant), F6 moves your cursor between the unlocked scrollable area and the frozen sections. This isn't commonly needed, but knowing it exists saves significant frustration if you encounter a frozen-pane spreadsheet and can't figure out why Ctrl+Home isn't going where you expect it to.

Selection Shortcuts

The most valuable selection shortcuts extend your range selection without the mouse. Ctrl+Shift+Arrow selects from the current cell to the last non-empty cell in the direction of the arrow. If you're in cell A1 and press Ctrl+Shift+Down, you select from A1 to the last row of data in column A — even if that's row 50,000. Combine this with Ctrl+Shift+Right to select the entire data region in a single move.

Essential selection shortcuts:

• Ctrl+A / Cmd+A — Select all (press once for current region, twice for entire worksheet)
• Ctrl+Shift+Arrow — Extend selection to the edge of the data region
• Shift+Arrow — Extend selection by one cell at a time
• Ctrl+Space / Ctrl+Space — Select the entire column of the active cell
• Shift+Space / Shift+Space — Select the entire row of the active cell
• Ctrl+Shift+End — Extend selection to the last used cell in the sheet
• Ctrl+Shift+Home — Extend selection to cell A1

When you need to select non-adjacent ranges — multiple separate columns or groups of cells — hold Ctrl while clicking each additional range with your mouse. This is one scenario where mouse clicks still make sense, since keyboard selection of non-adjacent ranges is cumbersome. Everything else, though, is faster with keys. If you're working on how to merge cells in Excel, mastering selection shortcuts first will make the process significantly faster.

One technique advanced Excel users rely on is selecting a range by entering it directly into the Name Box. Click the Name Box, type "A1:D500", and press Enter — the entire range is selected instantly. This bypasses scrolling entirely for known ranges. Combined with Ctrl+Shift+L to activate AutoFilter on that selection, you can set up filtered views of large datasets without any mouse interaction. The selection techniques in this guide also pair well with the how to unhide columns in Excel workflows, where selection accuracy matters for column operations.

The F5 key (or Ctrl+G) opens the Go To dialog, which has a Special button that many Excel users don't know about. Go To Special lets you select cells by type: blanks, cells with formulas, cells with constants, visible cells only (useful after filtering), cells with data validation, and more. Selecting blank cells then deleting them, or selecting formula cells to convert them to values — these are common data cleanup tasks that Go To Special handles in seconds.

Data Entry and Editing Shortcuts

Data entry shortcuts save time during repetitive input tasks and editing sessions. Alt+Enter (Windows) or Ctrl+Option+Enter (Mac) creates a new line within a cell — essential for multi-line cell content. Ctrl+; inserts the current date without typing it, and Ctrl+Shift+; inserts the current time. These are particularly useful for timestamped logs or tracking sheets.

Data entry shortcuts (Windows / Mac):

• F2 / F2 — Edit the active cell (places cursor at end of content)
• Alt+Enter / Ctrl+Option+Enter — Insert a line break within the cell
• Ctrl+; / Ctrl+; — Insert current date
• Ctrl+Shift+; / Ctrl+Shift+; — Insert current time
• Ctrl+D / Ctrl+D — Fill down — copy the content of the cell above into the selected range
• Ctrl+R / Ctrl+R — Fill right — copy the content of the left cell into the selected range
• Ctrl+" / Ctrl+" — Copy the value (not formula) from the cell above
• Escape — Cancel cell editing and discard changes
• Delete — Clear cell contents (keeps formatting)
• Ctrl+Delete — Delete from the cursor position to the end of the line within a cell

For removing duplicate entries across a large dataset, the delete duplicates in Excel guide covers both the built-in Remove Duplicates feature and formula-based approaches — shortcuts from this cheat sheet will help you navigate and select the ranges faster.

One often-overlooked data entry shortcut is Ctrl+Enter, which fills all selected cells with the same content. If you select 100 cells and type a value, then press Ctrl+Enter instead of just Enter, every selected cell receives that value simultaneously. This is far faster than fill-down for cases where you need to populate non-adjacent cells with the same content. It works for both static values and formulas — entering a formula with Ctrl+Enter while multiple cells are selected copies it to all of them at once, with relative references adjusting appropriately for each row and column position.

Paste Special deserves special mention in any shortcut discussion. Ctrl+Alt+V opens the Paste Special dialog on Windows (Ctrl+Cmd+V on Mac), which lets you paste only values, only formatting, only formulas, transpose rows to columns, or perform arithmetic operations on pasted values. Mastering Paste Special — particularly Paste Values Only (Ctrl+Alt+V, then V, Enter) — eliminates one of the most common Excel mistakes: pasting a formula somewhere that breaks its cell references.

Workbook and File Management Shortcuts

File management shortcuts handle the tedious but essential tasks of saving, opening, closing, and switching between workbooks. Ctrl+S should be muscle memory — save constantly. Excel's AutoSave in Microsoft 365 reduces the catastrophic file loss risk, but habits built for Excel 2019 and earlier (where AutoSave isn't available) carry over to 365 anyway. Ctrl+Z only helps if you haven't closed the file, so regular saves remain important even with AutoSave.

Workbook management (Windows / Mac):

• Ctrl+S / Cmd+S — Save
• F12 / F12 — Save As (open dialog to save with a new name or format)
• Ctrl+N / Cmd+N — New blank workbook
• Ctrl+O / Cmd+O — Open workbook
• Ctrl+W / Cmd+W — Close current workbook
• Ctrl+P / Cmd+P — Print (opens Print dialog)
• Ctrl+F4 / Cmd+W — Close the workbook window
• Ctrl+F6 — Switch between open Excel workbook windows

Worksheet tab shortcuts are often overlooked. Right-click any worksheet tab to rename it — or double-click the tab name directly for faster renaming. To move worksheets, Ctrl+drag a tab to duplicate it; plain drag to move it. The Excel sheet guide covers worksheet management in more depth, including naming conventions and organization strategies for multi-sheet workbooks.

For printing shortcuts: after Ctrl+P opens the Print dialog, most print settings require mouse interaction. The most useful print-related keyboard shortcut is Ctrl+F2 (Windows) to open Print Preview without going through the Ribbon. In Microsoft 365, you can set print area programmatically through the Page Layout tab, but for quick one-off print-area setting, the Page Layout menu is typically faster than a shortcut.

Version management is another area where shortcuts help. Ctrl+S is obvious, but F12 (Save As) is underused — pressing F12 immediately opens the Save As dialog, letting you save a versioned copy without navigating through File > Save As. Many Excel professionals develop a habit of pressing F12 at key milestones (before a major transformation, before sharing with a colleague) to preserve snapshots. Combined with a consistent naming convention, this creates a lightweight version history without dedicated version control software.

Advanced and Ribbon Shortcuts

On Windows, pressing Alt activates the Ribbon key tips — a letter or number appears over each Ribbon tab and element. Press the letter to activate that tab, then the next key for the specific function. For example, Alt+H opens the Home tab, then F+C opens the Font Color dropdown. These Ribbon shortcuts aren't as fast as direct keyboard shortcuts but give you access to every Ribbon function without the mouse — useful when no direct shortcut exists for what you need.

Some advanced shortcuts that experienced Excel users rely on daily:

• Ctrl+Shift+F3 — Create names from selection (name ranges based on row/column headers)
• Ctrl+F3 — Open Name Manager (manage all named ranges in the workbook)
• Ctrl+K / Cmd+K — Insert hyperlink
• Shift+F11 / Fn+Shift+F11 — Insert new worksheet
• F11 / Fn+F11 — Create a chart on a new chart sheet from selected data
• Alt+F8 — Open Macro dialog (run or edit macros)
• Alt+F11 — Open Visual Basic Editor (write VBA code)
• Ctrl+T / Cmd+T — Convert selected range to an Excel Table (enables AutoFilter and table formulas)

The Ctrl+T shortcut to create an Excel Table is underused and underrated. Excel Tables automatically expand when you add rows or columns, apply consistent formatting, enable structured references in formulas, and work with AutoFilter without setup. Once you convert your data ranges to Tables, many repetitive formatting and formula tasks become significantly simpler. Practice with our how to freeze a row in Excel guide, which shows another Excel feature that speeds up navigation in large tables.

For developers and advanced users, the Alt+F11 shortcut to open the Visual Basic Editor is worth knowing even if you never write VBA from scratch. You can open the editor, record a macro with the macro recorder, view the generated VBA code, and modify it to learn how Excel operations translate to code. This approach — record, view, modify — is one of the most effective ways to learn Excel VBA without a formal programming background. The Excel formulas guide covers the formula layer of Excel; VBA adds a full programming layer above that for automation of repetitive tasks.