Excel Keyboard Shortcuts: Essential Keys and How to Use Them

Excel keyboard shortcuts are key combinations that perform commands without requiring a ribbon click. On Windows, start with Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, Ctrl+S to save, Ctrl+Arrow to move to the edge of a data region, and Alt+= to insert AutoSum. The shortcuts below are for Excel for Microsoft 365 on Windows; Mac equivalents and important differences are noted where they apply.

How Excel keyboard shortcuts work

A shortcut usually combines a modifier key—such as Ctrl, Shift, or Alt—with a letter, number, or function key. Press and hold the modifier, tap the other key, and then release. For instance, Ctrl+B applies bold formatting to the selected cells. A shortcut may act on a cell, a range, a worksheet, or the whole workbook, depending on what is selected.

Some commands use a sequence rather than keys pressed together. In Windows Excel, pressing Alt displays Key Tips on the ribbon; pressing the letters shown afterward opens a tab or runs a command. The letters can vary with the ribbon layout and language, so follow the on-screen prompts rather than memorizing a sequence from a different installation. Esc generally backs out of a Key Tip sequence.

Shortcuts are context-sensitive. Ctrl+Arrow, for example, moves through a continuous block of data, but behaves differently when the adjacent cells are blank or when the active cell is at the edge of a sheet. If a shortcut seems to do nothing, check which cell or object is active, whether Excel is editing a cell, and whether another application has captured the keystroke.

Everyday shortcuts for editing and files

These combinations cover common actions when entering, changing, or moving workbook content:

Ctrl+C / Ctrl+X / Ctrl+V: Copy, cut, and paste the selected cells or object.
Ctrl+Z / Ctrl+Y: Undo the last action and redo an undone action. Redo behavior can depend on what has happened since the undo.
Ctrl+S: Save the current workbook. For a new workbook, Excel may ask for a file name and location.
Ctrl+O / Ctrl+N: Open a workbook and create a new workbook.
Ctrl+F / Ctrl+H: Find text or values, and open Find and Replace.
Delete: Clear the contents of selected cells without deleting the cells themselves.
F2: Edit the active cell. The insertion point appears in the cell’s contents or formula bar, where you can revise a value or formula.
Enter: Confirm an entry and move to another cell, commonly the cell below. Tab confirms an entry and moves to the next cell to the right.

Cutting or copying cells is not the same as deleting them. Delete clears cell contents; Ctrl+X followed by a paste moves the content and can affect formulas and references. If you want to remove cells and shift surrounding data, use the delete-cells command rather than the Delete key.

On Mac, the everyday file and clipboard equivalents commonly use Command: Command+C, Command+X, Command+V, Command+Z, Command+S, Command+O, Command+N, and Command+F. Shortcut assignments can differ by Excel release, keyboard layout, and macOS settings. Check Excel’s Help search or the menus if a Windows combination does not translate directly.

Moving around a worksheet

Navigation shortcuts are especially useful in large sheets, where scrolling by hand can make it difficult to keep track of the active cell. They move the selection or viewport; they do not change the worksheet’s data.

Arrow keys: Move one cell in the chosen direction.
Ctrl+Arrow: Move to the edge of a continuous data region in that direction. A blank cell or a gap changes where the movement stops.
Ctrl+Home: Go to the beginning of the worksheet, normally cell A1.
Ctrl+End: Go to the last cell Excel considers used on the sheet. This may be beyond the visible data if formatting or old content extends the used range.
Page Up / Page Down: Move the view up or down by approximately one screen.
Ctrl+Page Up / Ctrl+Page Down: Switch to the previous or next worksheet tab.
Ctrl+G or F5: Open Go To, where you can enter a cell reference such as D250 to jump directly to it.

Ctrl+End is not a reliable way to identify the last meaningful record in a workbook. If it lands far past the actual table, the sheet may contain leftover formatting or previously used cells. You can inspect the area between the real data and the reported last cell, remove unnecessary content or formatting, and save the workbook. This can also reduce confusion when navigating.

On a laptop, Page Up, Page Down, Home, and End may require holding an Fn key, depending on the keyboard. On Mac, the corresponding navigation may involve Control, Command, or Fn depending on the hardware and Excel version. Use the Go To command when you need a dependable way to reach a known cell reference.

Selecting cells, rows, and columns

Selection shortcuts make it easier to apply a change to a whole region without dragging the mouse. The active cell remains the anchor for many selections, so check the highlighted range before typing or formatting.

Shift+Arrow: Extend the selection by one cell in the chosen direction.
Ctrl+Shift+Arrow: Extend the selection to the edge of a continuous data region.
Ctrl+A: Select the current data region; pressing it again in some contexts can expand the selection. When the active cell is in a table or a data block, inspect the selection to confirm its boundaries.
Ctrl+Space: Select the entire column containing the active cell.
Shift+Space: Select the entire row containing the active cell.
Ctrl+Shift+End: Extend the selection to the worksheet’s last used cell.

For example, if a column contains a continuous list beginning at B2, Ctrl+Shift+Down can select from B2 to the bottom of that block. If there is a blank cell within the list, the selection stops at the blank instead of skipping over it. For a precise range, use the Name Box to the left of the formula bar: type a reference such as B2:B500 and press Enter.

Formatting and entering values faster

Formatting shortcuts can speed up routine presentation work, but they change how cells appear rather than the underlying value. Apply them deliberately, particularly when a selection includes a mixture of data types.

Ctrl+B, Ctrl+I, Ctrl+U: Toggle bold, italic, and underline for selected cells or text.
Ctrl+1: Open the Format Cells dialog, which includes number formats, alignment, font, borders, fill, and protection options.
Ctrl+Shift+~: Apply the General number format. This can remove displayed decimal or currency formatting without changing the stored value.
Ctrl+Shift+$: Apply a currency format; Ctrl+Shift+% applies a percentage format.
Ctrl+;: Enter the current date as a fixed value in the active cell.
Ctrl+Shift+: Enter the current time as a fixed value.
Alt+Enter: Start a new line within the same cell while editing its contents.

A fixed date entered with Ctrl+; does not update tomorrow. That differs from a formula that returns the current date, which can recalculate. Similarly, applying a percentage format changes the display: a stored value of 0.25 displays as 25%, while typing 25 and formatting it as a percentage displays 2500%. Confirm the underlying value before using number-format shortcuts.

Formulas, tables, and data commands

Several shortcuts help build or inspect common spreadsheet structures. They do not replace checking the result: formula references, selected ranges, and source data still need to be correct.

Alt+=: Insert AutoSum. Excel proposes a range of adjacent numbers, which you can review before pressing Enter.
F4: While editing a formula reference, cycle through relative and absolute reference forms, such as A1, $A$1, A$1, and $A1. Outside formula editing, F4 may repeat the last action in some contexts.
Ctrl+`: Toggle between displaying formula results and displaying formulas in cells. The grave accent key is usually near the top-left of a US keyboard; its location may differ on other layouts.
Ctrl+T: Create an Excel table from a selected data range and open the Create Table dialog. Confirm whether the range has headers before accepting.
Ctrl+Shift+L: Toggle filters for a data range. Filters hide rows that do not meet selected criteria; they do not delete those rows.
Ctrl+Shift++: Open the insert-cells options. Depending on the selection, Excel can insert cells, rows, or columns.
Ctrl+-: Open the delete-cells options for the selection.

For example, after selecting a cell at the bottom of a column of amounts, Alt+= may propose summing the numbers directly above. Look at the proposed range in the formula before confirming. If a heading, blank row, or unrelated value interrupts the region, edit the range rather than assuming Excel has identified the intended total.

Windows and Mac shortcut differences

Most shortcuts in this guide target Excel for Microsoft 365 on Windows. Excel for Mac shares many command names, but key combinations are not always a simple Ctrl-to-Command substitution. Copy, paste, undo, save, open, and find commonly use Command on Mac, while some navigation and editing commands use Control, Option, Fn, or function keys.

Hardware matters too. Many Mac keyboards require Fn or a system setting to use function keys such as F2 as standard function keys. Windows laptops may also assign media or brightness actions to those keys unless Fn is held. Keyboard layouts can place punctuation keys such as the grave accent in different positions, making a shortcut harder to reproduce even when its command is supported.

For a shortcut you cannot locate, use the command’s ribbon or menu path as a fallback, or search Excel Help for the command name. The menu is also a useful way to verify what Excel calls an action before searching for its platform-specific shortcut. Excel for the web can have additional browser or operating-system conflicts, so a shortcut may behave differently there than in the Windows desktop application.

Why a shortcut may not work

A shortcut that appears unresponsive does not necessarily mean Excel lacks the command. Common causes include a different active pane, a cell being edited, a keyboard layout, a laptop Fn setting, or another program using the same key combination.

Excel is editing a cell: Press Esc to cancel the edit or Enter to accept it, then try the command again. Some shortcuts behave differently while the cursor is inside a cell’s text.
The wrong range is selected: Click a cell or select the intended range first. Shortcuts such as Ctrl+B and Ctrl+Shift+L depend on what is selected.
A key is handled by the system: Check the Fn key or function-key setting, especially for F2, F5, and other function keys.
The data has gaps: Ctrl+Arrow and Ctrl+Shift+Arrow stop at region boundaries. A blank row can split what looks like one list.
The application differs: Excel for Mac, Excel for the web, and other spreadsheet programs may use different combinations or reserve keys for system commands.

When troubleshooting, try the command from the ribbon or menu first. If the menu command works, the issue is likely the key combination, focus, or keyboard setup—not the underlying feature. Avoid assuming that a familiar shortcut has the same effect in every spreadsheet application.

Building a useful shortcut routine

There is no need to memorize every shortcut at once. Pick a few that match repetitive tasks and practice them on a copy or a noncritical worksheet. Editing and navigation shortcuts usually provide the quickest benefit because they reduce repeated mouse movement across almost any kind of workbook.

Start with copy, paste, undo, save, find, and Go To.
Add Ctrl+Arrow and Shift+Arrow for moving and selecting through data.
Learn Ctrl+1 for number formats and Alt+= for reviewing a proposed total.
Use shortcuts on a small, clearly understood selection before applying them to a large range.
Keep a short reference list for commands used only occasionally, and verify platform-specific keys in Excel Help.

Shortcuts are most effective when paired with good spreadsheet habits. Use clear headers, avoid accidental blank rows in a data list, and check the selected range before running a command that changes many cells. Keyboard speed is useful, but a quick visual check can prevent a much larger cleanup later.

Frequently Asked Questions

What is the most useful Excel shortcut for beginners?
There is no single best choice, but Ctrl+Z is valuable because it undoes many recent actions, while Ctrl+S helps save work. Ctrl+F is useful for finding a value, and Ctrl+Arrow helps move through a data region.

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. Confirm the highlighted area before making changes.

What shortcut opens Format Cells?
In Excel for Microsoft 365 on Windows, Ctrl+1 opens the Format Cells dialog. On Mac, Command+1 commonly opens the corresponding dialog, although assignments can depend on the Excel version and keyboard setup.

How do I insert a line break inside an Excel cell?
While editing a cell on Windows, press Alt+Enter to insert a line break without moving to another cell. On Mac, the combination can differ by version and keyboard; check Excel Help for the in-cell line-break command if Alt+Enter does not work.

Do Excel shortcuts work the same in Google Sheets?
No. Some common combinations overlap, but the available commands and key behavior can differ, and a browser may intercept shortcuts. Use the keyboard shortcut help for the spreadsheet application you are using rather than assuming Excel instructions apply unchanged.

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.