Excel PC Keyboard Shortcuts: Essential Keys and Tips

For Excel for Microsoft 365 on a Windows PC, start with Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+S to save, Ctrl+Arrow keys to move across a data region, and Ctrl+1 to open Format Cells. These shortcuts work without the mouse for many everyday tasks; the exact behavior can depend on what is selected and whether you are editing a cell.

How Excel keyboard shortcuts work

A shortcut combines keys to ask Excel to perform an action. In Windows shortcuts, Ctrl usually means the Control key, while Shift and Alt may be used alone or in a combination. A plus sign in a shortcut description means to hold the listed keys together: Ctrl+Shift+L means hold Ctrl and Shift, then press L.

Some shortcuts act immediately, while others open a dialog or begin an action that needs another key. For instance, Ctrl+1 opens the Format Cells dialog, where you can choose a number format, alignment, font, border, or fill. Pressing Alt in Excel displays Key Tips over ribbon tabs and commands; press the indicated letters in sequence to reach a command. Those letters can vary with Excel’s language and interface version, so follow the on-screen prompts instead of memorizing a fixed sequence.

Shortcuts are context-sensitive. Ctrl+Arrow moves between the edges of a populated region, but in a blank area it behaves differently. F4 can repeat an action in some situations, yet while editing a formula it cycles through reference styles. Understanding the context is often more useful than memorizing a long list.

Essential shortcuts for everyday work

These Windows shortcuts cover common workbook, clipboard, and search tasks:

Ctrl+N: create a new workbook. Ctrl+O: open a workbook. Ctrl+S: save. F12: open Save As.
Ctrl+P: open the print screen. Review the preview and settings before printing, especially if the worksheet spans multiple pages.
Ctrl+C, Ctrl+X, Ctrl+V: copy, cut, and paste the current selection. Ctrl+Alt+V opens Paste Special, where available options depend on what was copied.
Ctrl+Z: undo the previous action. Ctrl+Y: redo an undone action or repeat some actions.
Ctrl+F: find text or values. Ctrl+H: find and replace. Check the search options if Excel is looking in formulas, values, or the current sheet when you expected a different scope.

For example, if a range contains formulas and you want to copy only the displayed results, copy the cells, open Paste Special with Ctrl+Alt+V, and select Values in the dialog. This avoids replacing the destination with formulas that may refer to different cells. The available dialog choices can differ depending on the copied content.

Navigate around a worksheet

Moving efficiently matters most in large sheets. The arrow keys move one cell at a time; adding Ctrl or Shift changes the distance or selection:

Ctrl+Arrow: move to the edge of a continuous block of data in that direction. If a blank cell interrupts the block, Excel stops at the boundary rather than jumping to the end of the worksheet.
Home: move to the beginning of the current row. Ctrl+Home: go to the start of the worksheet. Ctrl+End: go to the last cell Excel considers used, which can include cells with leftover formatting.
Ctrl+Page Up and Ctrl+Page Down: move to the previous or next worksheet tab in the workbook.
Ctrl+G or F5: open Go To. Enter a cell reference such as D250 to jump directly to that address.
Alt+Page Up and Alt+Page Down: scroll one screen left or right in a wide worksheet.

Ctrl+End can land farther down or across than the visible data because formatting or previous entries may have extended Excel’s used range. If that happens, inspect the area between the real data and the reported last cell; deleting genuinely unused rows or columns and saving may help, but do not remove cells that contain information you still need.

Select cells, rows, and columns

Selection shortcuts are useful before formatting, copying, or deleting data. Start from the cell or range that should anchor the selection:

Shift+Arrow: extend a selection by one cell. Ctrl+Shift+Arrow: extend it to the edge of the data region in that direction.
Shift+Space: select the entire row containing the active cell. Ctrl+Space: select its entire column.
Ctrl+A: select the current data region in many worksheet contexts; pressing it again can select the whole worksheet. In a table or other context, selection behavior may differ.
Ctrl+Shift+End: extend the selection from the active cell to Excel’s last used cell.

To select a rectangular range quickly, click its first cell, hold Shift, and click its last cell; Excel selects the cells between them. For keyboard-only selection, move to the first cell and use Shift with the arrow keys. Be cautious with Ctrl+Shift+End: if the used range is oversized, the selection may include many blank-looking cells.

Enter and edit data faster

Excel has separate actions for entering a value and changing a value that is already in a cell. Knowing the difference helps prevent accidental overwrites:

F2: edit the active cell’s contents. Use the arrow keys to move within the entry when the cell is in edit mode.
Enter: accept an entry and usually move down one cell. Tab: accept it and move to the right. Esc: cancel the current edit.
Alt+Enter: insert a line break inside a cell while editing text.
Ctrl+Enter: enter the same typed content into all cells in a selected range. Select the range first, type the entry, then press Ctrl+Enter.
Ctrl+D and Ctrl+R: fill down and fill right from the adjacent top or left cell into the selected range.
Ctrl+; insert the current date as a fixed value. Ctrl+Shift+: insert the current time as a fixed value.

A fixed date inserted with Ctrl+; does not automatically update tomorrow. That differs from a formula-based date, which recalculates. Also distinguish replacing a cell from editing it: typing while a cell is selected starts a new entry, whereas pressing F2 edits the existing contents.

Format cells and work with data

Formatting shortcuts make common adjustments without opening multiple ribbon tabs. Their effect is usually to apply a format, not change the underlying value:

Ctrl+1: open Format Cells for detailed number, alignment, font, border, and fill settings.
Ctrl+B, Ctrl+I, Ctrl+U: toggle bold, italic, and underline for selected cells or selected text.
Ctrl+Shift+$: apply a currency format. Ctrl+Shift+%: apply a percentage format. These are display formats; they do not convert the stored value.
Alt+=: insert an AutoSum formula for a nearby range. Check the suggested range before accepting it, since blank cells or adjacent values can affect what Excel selects.
Ctrl+T: create a table from a selected data range. Confirm that the range and header option are correct in the dialog.
Ctrl+Shift+L: turn AutoFilter buttons on or off for a data range. In a table, filter controls are part of the table experience.

For a practical example, select a cell in a list with column headings and press Ctrl+T. If Excel identifies the header row correctly, confirm the dialog; the table then provides filter buttons and expands more naturally when rows are added. Ctrl+Shift+L is useful for a simple filtered range, but it is not the same as converting that range into a table.

Function keys and ribbon access

Function keys can provide quick access to tasks, although laptop keyboards may require holding Fn as well. Check the keyboard’s function-row setting if an F-key changes screen brightness or volume instead of acting in Excel.

F1: open Excel Help. F2: edit the active cell.
F4: repeat the last action when that action can be repeated. While editing a formula and the cursor is on a cell reference, F4 cycles through relative and absolute reference forms, such as A1 and $A$1.
F5: open Go To. F12: open Save As.
Alt: show ribbon Key Tips. Continue with the letters displayed on the screen to navigate tabs and commands.
Ctrl+E: run Flash Fill in supported desktop Excel versions, using a detected pattern to fill a column. Inspect the results because Excel’s pattern inference may not match every row.

When using F4 in a formula, the cursor must be positioned on or next to the reference you want to change. For example, if a formula contains A1 and you want that reference fixed when copied, F4 can change it to $A$1. A dollar sign fixes a row or column reference; it does not lock the cell from editing.

Common shortcut problems and fixes

If a shortcut appears not to work, the cause is often the active control or keyboard rather than a missing Excel feature. Try these checks before changing your workflow:

A cell is being edited: many navigation and selection shortcuts behave differently while the insertion cursor is inside a cell. Press Esc to cancel or Enter to commit, then try again.
A dialog or menu is open: the shortcut may apply to that window rather than the worksheet. Close or complete the dialog first.
A laptop uses media keys: press Fn with the function key, or change the keyboard’s function-row setting if appropriate.
The selection is not what you expect: Ctrl+Arrow and Ctrl+Shift+Arrow stop at data boundaries. Look for blank rows or columns breaking the region.
A browser or another app intercepts a key: Excel for the web runs inside a browser, and browser shortcuts can conflict. Use the desktop app for workflows that depend on a key combination the browser captures.
The keyboard layout differs: punctuation combinations such as Ctrl+Shift+: can require different physical keys on different layouts. Use Excel’s ribbon or menu command if the printed key does not produce the expected character.

Shortcuts can also be affected by add-ins, customized keyboards, and remote-desktop software. If a standard command behaves unexpectedly, test it in a blank workbook and check whether another application or add-in is intercepting the keystroke.

Windows, Mac, and Excel for the web

This guide focuses on Excel for Microsoft 365 on Windows PCs. On Mac, many familiar commands use Command instead of Windows Ctrl: for example, Command+C, Command+V, Command+Z, and Command+S are the usual Mac equivalents for copy, paste, undo, and save. That is a useful starting point, not a universal conversion rule. Excel has Mac-specific shortcuts, and macOS or other apps may reserve keys that Windows Excel uses.

Function keys on Mac keyboards may require Fn or a change to macOS keyboard settings. Ribbon access also differs: Windows users can press Alt to reveal Key Tips, while Mac users should use the menu bar or Excel’s displayed Mac shortcuts rather than assume the Windows Alt sequence applies. Exact behavior can depend on the Mac keyboard and Excel release.

Excel for the web shares many familiar shortcuts, but browser commands can take priority, and some desktop features or key combinations differ. If a shortcut opens a browser feature instead of acting on the sheet, use the ribbon command or open the workbook in the Windows desktop app. Microsoft’s current shortcut reference and the commands shown in Excel’s menus are useful checks when working across platforms.

Frequently Asked Questions

What is the shortcut to save an Excel file on a PC?
Press Ctrl+S to save the current workbook. For a new workbook or a new copy, press F12 to open Save As and choose the file name and location.

How do I select an entire column in Excel?
Click a cell in the column and press Ctrl+Space. To select a whole row instead, press Shift+Space.

How do I jump to the last row or cell in Excel?
Press Ctrl+End to go to the last cell Excel considers used, not necessarily the last row containing meaningful data. Use Ctrl+Arrow to jump to an edge of the current continuous data region.

What is the Excel shortcut for Find and Replace?
Press Ctrl+H to open Find and Replace. Press Ctrl+F for Find only; review the search scope and options if the expected text is not found.

Why does Ctrl+Arrow stop before the bottom of my data?
Excel treats blank cells as boundaries in a continuous data region. A blank cell in the column can stop the jump; use Ctrl+Arrow again or Go To with Ctrl+G to reach a known cell address.

Do Excel keyboard shortcuts work the same on Mac?
Not always. Common actions often use Command in place of Windows Ctrl, but some combinations are different or reserved by macOS. Check Excel’s Mac menu commands or its shortcut reference for the exact action.

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.