Excel Shortcut Keys Cheat Sheet: Essential Windows Keys

For Excel for Microsoft 365 on Windows, the most useful shortcut keys are Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, Ctrl+Arrow to move through a data region, F2 to edit a cell, and Ctrl+1 to open Format Cells. This cheat sheet groups practical shortcuts by task, explains where Mac and web versions differ, and offers a way to learn the keys you will use most.

Everyday editing and workbook shortcuts

These are the keys to learn first because they work across many common spreadsheet tasks. A shortcut usually acts on the selected cell or range, so check the selection before using commands that replace, delete, or format data.

Ctrl+C, Ctrl+X, and Ctrl+V: copy, cut, and paste the selected cells or content.
Ctrl+Z and Ctrl+Y: undo the last action and redo an action that was undone. Redo behavior can depend on what you did after undoing.
Ctrl+S: save the workbook. With AutoSave enabled for a supported cloud file, changes may also save automatically, but saving explicitly remains useful.
Ctrl+P: open the print screen, where you can check the preview and print settings.
Ctrl+F and Ctrl+H: open Find and Replace. Use Find to locate text or values, and Replace to change matching content.
Ctrl+1: open the Format Cells dialog for number formats, alignment, fonts, borders, and other cell formatting.
Ctrl+K: open the link-insertion dialog when you want to add a hyperlink.
Esc: cancel an in-progress entry or close many menus and dialogs without confirming the current action.

Copying a cell can also copy its formula, formatting, and other attributes. If you need only the displayed result, use the paste options after Ctrl+V or open Paste Special rather than assuming a regular paste will transfer values alone. Keyboard shortcuts speed up actions, but they do not change what an action means.

Moving around a worksheet and selecting data

Navigation shortcuts help most when a worksheet has more rows or columns than fit on screen. Excel interprets many movement commands in relation to the current data region: a continuous block of populated cells bounded by blank cells.

Arrow keys: move one cell in the chosen direction.
Ctrl+Arrow: jump to the edge of a data region in that direction. If the adjacent cell is blank, Excel may move to the next occupied cell or the worksheet edge, depending on the surrounding data.
Ctrl+Home: move to the beginning of the worksheet, usually cell A1.
Ctrl+End: move to the last cell Excel considers used. This may be beyond the visible data if cells farther down or across were previously formatted or edited.
Ctrl+Shift+Arrow: extend the selection to the edge of a data region.
Ctrl+Shift+End: extend the selection from the active cell toward the worksheet’s last used cell.
Ctrl+Space and Shift+Space: select the current column and current row, respectively.
Ctrl+Page Up and Ctrl+Page Down: move to the previous or next worksheet tab in the workbook.
Ctrl+A: select the current data region, or the worksheet in some contexts. Pressing it again can expand the selection, so confirm what is highlighted.

For example, to select a long list in column B, click its first data cell and press Ctrl+Shift+Down. If there is a blank cell within the list, the shortcut stops at that break. For a more predictable selection, use the Name Box to enter a range such as B2:B500, or select the first cell and use Ctrl+Shift+End only when the worksheet’s used range is appropriate.

Entering, editing, and filling cells

Small input shortcuts can make data entry more consistent, especially when entering the same value in multiple cells or adding dates and times.

F2: edit the active cell’s contents. In a formula, this can help inspect or adjust references.
Enter: commit an entry and usually move the selection down one cell; Tab commits and usually moves right.
Alt+Enter: insert a line break within a cell while editing its contents.
Ctrl+Enter: enter the same value or formula into all cells in a selected range. Type the entry, then press this combination instead of ordinary Enter.
Ctrl+D: fill the selected range downward using the top cell’s contents.
Ctrl+R: fill the selected range to the right using the leftmost cell’s contents.
Ctrl+;: enter the current date as a fixed value.
Ctrl+Shift+;: enter the current time as a fixed value.
F4: repeat the last action in many situations. While editing a formula reference, it cycles through relative and absolute reference styles, such as A1 and $A$1.

A fixed date entered with Ctrl+; does not update tomorrow. That differs from a formula such as TODAY(), which recalculates. Similarly, Ctrl+Shift+; inserts a time value at the moment you press it. To create a two-line label, edit the cell, place the cursor where the break belongs, and press Alt+Enter; the row may need additional height to display both lines.

Formatting numbers, tables, and filters

Formatting shortcuts can make a report easier to scan without changing the underlying value. The following number-format combinations are useful for common display styles:

Ctrl+Shift+1: apply Number format with two decimal places.
Ctrl+Shift+4: apply Currency format.
Ctrl+Shift+5: apply Percentage format.
Ctrl+Shift+~: apply General format.
Ctrl+T: create a table from a selected data range and open the Create Table dialog if needed.
Ctrl+Shift+L: turn filters on or off for a selected range or table.
Alt+Down Arrow: open a filter menu when the active cell is in a filtered column header; it can also open a data-validation list in a cell that has one.

Number formatting changes how a value is displayed, not necessarily the stored value. Applying Percentage to 0.25 displays 25%, while applying it to 25 displays 2500%. A table created with Ctrl+T can provide filter buttons and structured formatting, but check that the selected range includes the intended headers and excludes unrelated notes. Turning on filters with Ctrl+Shift+L is not the same as creating a table.

Formula and calculation shortcuts

Excel shortcuts can speed up formula entry and make formulas easier to inspect, but they do not replace understanding cell references. When editing a formula, F4 can change a selected reference from relative to absolute or mixed. For example, a reference may cycle among A1, $A$1, A$1, and $A1. The dollar signs keep the marked row or column fixed when a formula is copied.

Alt+=: insert AutoSum. Excel proposes a range of adjacent numbers, which you should review before accepting.
F2: edit the formula in the active cell, making it easier to inspect its references.
Ctrl+`: toggle the display of formulas in place of their results. The grave-accent key is commonly near the top-left of a US keyboard; the key location can differ on other layouts.
F9: in formula-editing contexts, calculate selected parts of a formula. Used outside formula editing, it can recalculate workbooks depending on calculation settings.

AutoSum is a convenience, not a guarantee that Excel has chosen the right cells. If a blank cell or text label interrupts a column of values, the proposed range may not match your intent. Inspect the highlighted range and the formula bar before pressing Enter. Also distinguish calculation from display: a workbook set to manual calculation may not refresh every formula immediately when inputs change.

Mac and Excel for the web differences

This list is for Excel for Microsoft 365 on Windows. On a Mac, many familiar editing shortcuts use Command instead of Ctrl; for example, Command+C, Command+V, Command+Z, and Command+S are common equivalents for copy, paste, undo, and save. Not every Windows shortcut maps by simply replacing Ctrl with Command, however. Function keys, symbols, keyboard layouts, and macOS system shortcuts can also affect behavior. Check Excel’s menus or Microsoft’s shortcut reference for the exact Mac command you need.

In Excel for the web, browser shortcuts can compete with Excel shortcuts. A browser may intercept a key combination for a new tab, search, or navigation, and some desktop commands behave differently online. Excel for the web also displays keyboard tips for ribbon commands when you press Alt+Windows logo key in supported Windows browsers. If a shortcut does not work, check whether the browser captured it, whether a cell is being edited, and whether the command is available in the web version. For shortcuts that depend on function keys, a laptop’s Fn key or system settings may change what is sent to Excel.

Common shortcut problems and safe habits

A shortcut that seems incorrect often depends on selection, editing mode, or the keyboard itself. Before repeating a command, identify which cell or range is active and whether the insertion cursor is inside a cell, formula bar, menu, or dialog.

The command affected too much: a whole-row or whole-column selection may have been active. Click a single cell and check the highlighted area before deleting or formatting.
A jump stopped early: Ctrl+Arrow and related selection shortcuts treat blank cells as boundaries within a data region.
The function key did something else: press Fn with the function key if required by the computer, or check the device’s function-key setting.
A shortcut opened a browser feature: this is common in Excel for the web. Try Excel’s ribbon key tips or open the workbook in the desktop application.
Typing replaced existing content: the selected cell may not have been in edit mode. Use F2 or double-click the cell to edit within its contents rather than replace them.
Undo is unavailable: some actions, including running a macro, cannot be reversed with Ctrl+Z. Save a backup before operations that may make broad changes.

When trying an unfamiliar shortcut, test it on a copy of the workbook or a small sample range first. This is especially sensible for commands that fill, delete, replace, or apply formatting across a large selection. A few seconds spent checking the selection can prevent a much longer cleanup.

How to choose which shortcuts to learn

Memorizing every combination is unnecessary. Choose shortcuts that replace actions you repeat often, then add more when a real task calls for them. A practical starting sequence is copy and undo, navigation, editing, and finally formatting or filtering.

Start with Ctrl+C, Ctrl+V, Ctrl+Z, and Ctrl+S for everyday work.
Add Ctrl+Arrow, Ctrl+Home, and Ctrl+Shift+Arrow when moving through large lists.
Learn F2, Ctrl+D, and Ctrl+; if you often edit cells, fill repeated values, or enter dates.
Add Ctrl+1, Ctrl+T, and Ctrl+Shift+L when formatting data and working with filters.

Keep a short reference beside your desk or in a notes file, but group it by task rather than trying to study a long alphabetical list. Repetition builds recall: use one new shortcut regularly for a week, then add another. If you switch between Windows and Mac, keep separate notes for the combinations that differ instead of assuming all keys translate directly.

Frequently Asked Questions

What is the most useful Excel shortcut?
Ctrl+Z is a useful first choice because it can undo many recent actions. For frequent data entry, Ctrl+Arrow may save more time by moving quickly through a worksheet’s data regions.

How do I select an entire column or row in Excel?
Click a cell in the column and press Ctrl+Space to select the column. Press Shift+Space to select the row containing the active cell.

How do I insert a line break inside an Excel cell?
Edit the cell, place the cursor where the break should go, and press Alt+Enter on Windows. Increase the row height or use Wrap Text if the full entry is not visible.

Why does Ctrl+End go past my data?
Ctrl+End moves to Excel’s last used cell, which can include cells that were formatted or edited earlier even if they look blank now. Review the worksheet’s used area rather than assuming the shortcut identifies the last meaningful value.

Are Excel shortcuts the same on Mac?
No. Many basic commands use Command on Mac where Windows uses Ctrl, but other combinations differ or depend on the keyboard. Check the command in Excel for Mac instead of applying a blanket key substitution.

Can I use these shortcuts in Excel for the web?
Many work, but browser shortcuts may take priority and some desktop behaviors differ. If a combination does not respond as expected, use the ribbon or its key tips, or open the workbook in desktop Excel.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.