Excel Cell Shortcut Keys for Selecting and Editing Data

For Excel for Microsoft 365 on Windows, the most useful cell shortcuts are F2 to edit a cell, Ctrl+1 to format it, Ctrl+C/Ctrl+V to copy and paste, and Ctrl+Arrow to move through a block of data. Use Ctrl+Space to select a column and Shift+Space to select a row; Mac equivalents differ for some commands.

Essential Excel cell shortcuts

A keyboard shortcut usually combines a modifier key such as Ctrl or Shift with another key. A plus sign means to hold the keys together; a comma in a shortcut sequence means to press the keys in order. These Windows shortcuts work in the desktop version of Excel unless noted.

F2: Edit the active cell, placing the insertion point in its contents.
Ctrl+C, Ctrl+X, Ctrl+V: Copy, cut, and paste the selected cell or range.
Ctrl+Z, Ctrl+Y: Undo the last action and redo an undone action.
Ctrl+1: Open the Format Cells dialog for the selection.
Ctrl+Arrow key: Jump to the edge of the current data region in that direction.
Ctrl+Home: Move to the beginning of the worksheet, usually cell A1.
Ctrl+End: Move to the last cell Excel considers used on the worksheet.
Ctrl+Enter: Enter the current value or formula into every cell in a selected range.

These commands cover common tasks, but a shortcut is only useful when Excel has focus. If the formula bar, a dialog box, or another application has focus, the same keys may do something else.

Select cells, rows, columns, and ranges

Selection shortcuts help you act on a group of cells without dragging with the mouse. Click a starting cell, then extend the selection with a shortcut when a range has many rows or columns.

Shift+Arrow key: Extend the selection by one cell in the arrow’s direction.
Ctrl+Shift+Arrow key: Extend the selection to the edge of a contiguous data region in that direction. This is handy for selecting a column of uninterrupted entries.
Ctrl+Space: Select the entire column containing the active cell.
Shift+Space: Select the entire row containing the active cell.
Ctrl+A: Select the current data region; pressing it again can expand the selection to the whole worksheet, depending on where you are.
F5 or Ctrl+G: Open Go To, where you can enter a reference such as D25 to jump directly to that cell.

For example, if A1:A500 contains an uninterrupted list, click A1 and press Ctrl+Shift+Down to select to the edge of that block. If there are blank cells in the middle, the shortcut stops at a boundary rather than automatically selecting every entry below it. To select a fixed address range, use Go To and enter its address, such as A1:A500.

Enter, edit, and cancel cell contents

Excel separates entering a value from editing a value already in a cell. Select a cell and begin typing to replace its contents. Press F2 to edit the existing contents without replacing them; in many cases, you can also click the formula bar to make a more deliberate edit.

Enter: Commit the entry and move down one cell.
Tab: Commit the entry and move one cell to the right.
Shift+Enter or Shift+Tab: Commit the entry and move up or left, respectively.
Esc: Cancel an entry that has not been committed.
Alt+Enter: Insert a line break within the cell while editing its contents.
Ctrl+;: Insert the current date as a fixed value.
Ctrl+Shift+: Insert the current time as a fixed value.

The date and time shortcuts insert values; they do not create a live clock that updates continuously. For a multi-line label, such as an address, use Alt+Enter where you want the next line to begin, then make sure the row height allows the lines to show. If you accidentally start typing over a cell, press Esc before committing the entry.

Format cells and display values

Formatting changes how a value looks, not necessarily the value stored in the cell. For example, a date may be stored as a serial number and displayed as a calendar date. Press Ctrl+1 to open the Format Cells dialog, where you can choose number formats, alignment, fonts, borders, and other options for the selection.

Ctrl+B: Toggle bold formatting.
Ctrl+I: Toggle italic formatting.
Ctrl+U: Toggle underline formatting.
Ctrl+Shift+$: Apply the default currency format.
Ctrl+Shift+%: Apply the percentage format.
Ctrl+Shift+!: Apply the number format with two decimal places and a thousands separator.

Formatting shortcuts can make a value easier to read, but they do not convert text into a number or change the underlying arithmetic. If a value is left-aligned or Excel does not calculate with it as expected, check whether it was stored as text before applying a number format. Use Ctrl+1 when you need to inspect or choose a specific format instead of relying on a default.

Copy, fill, and repeat cell data

Copy and paste are useful for moving content, while fill shortcuts copy content or patterns through a selected range. Select the destination cells as well as the source cell when using a fill command.

Ctrl+D: Fill down from the top cell of the selected range.
Ctrl+R: Fill right from the leftmost cell of the selected range.
Ctrl+Enter: Put the same typed entry or formula into all cells in the current selection.
Ctrl+Alt+V: Open Paste Special after copying, so you can choose what to paste, such as values or formatting.

For example, to copy a heading from B2 into B3:B8, select B2:B8 and press Ctrl+D. Excel uses the top cell as the source. To enter the same label into several nonadjacent cells, select them together, type the label, and press Ctrl+Enter. This is different from filling a formula down a column: if you need formulas to use different row references, check the results after filling so you know each formula refers to the intended cells.

Move around a worksheet and work with references

Navigation shortcuts make it easier to move through large sheets and inspect formulas. Ctrl+Arrow moves across a data region, while Ctrl+Home and Ctrl+End jump to worksheet boundaries as Excel understands them. Ctrl+End can land farther down or across than expected if cells outside the visible data were previously used or formatted; it does not necessarily identify the last meaningful record.

When editing a formula that contains a cell reference, press F4 after selecting or placing the cursor on the reference to cycle through relative and absolute reference styles. A reference such as A1 can become $A$1, $A1, or A$1. The dollar signs control which part of the reference stays fixed when a formula is copied. On Mac, Command+T is commonly used to cycle reference styles in a formula; keyboard settings and Excel versions can affect function-key behavior.

Use Ctrl+` (the grave accent key, often near the top-left of a US keyboard) to switch between displaying formulas and their calculated results. This is useful when auditing a sheet or checking whether a formula was entered where expected. Press the same shortcut again to return to the normal results view.

Windows, Mac, and Excel for the web differences

The shortcuts above are for Excel for Microsoft 365 on Windows. On Mac, common editing commands often use Command instead of Ctrl: for example, Command+C copies, Command+X cuts, Command+V pastes, and Command+Z undoes. Some shortcuts do not follow that simple substitution. For instance, Ctrl+1 on Windows opens Format Cells, while Command+1 is the corresponding shortcut in Excel for Mac. Function keys may require holding Fn if the keyboard uses F2 for a hardware function.

Selection shortcuts can also interact with macOS settings. Ctrl+Space may be assigned to a system input-source command, so it might not select a column until that system shortcut is changed. If a shortcut differs, use Excel’s menus or check the shortcut reference for your installed Mac version rather than assuming every Ctrl key should become Command.

Excel for the web runs in a browser, where some key combinations may be intercepted by the browser or operating system. Click into the worksheet first, and use the web app’s Help or shortcut reference if a desktop command behaves differently. The same workbook can be edited in desktop Excel, but menu availability and keyboard behavior are not identical across Windows, Mac, and browser versions.

Common shortcut problems and practical fixes

A shortcut that appears not to work often has a simple cause. Check these points before assuming Excel does not support the command:

The wrong cell or range is selected: Fill and formatting commands act on the current selection. Confirm the outline around the intended cells before pressing a shortcut.
The formula bar or a dialog has focus: Press Esc to close or cancel the current interaction, then click the worksheet cell and try again.
A laptop uses media keys by default: Try Fn+F2 or adjust the keyboard’s function-key setting if F2 changes volume or brightness instead of editing the cell.
A blank cell interrupts navigation: Ctrl+Arrow and Ctrl+Shift+Arrow respond to data-region boundaries. A gap can make Excel stop earlier than expected.
Ctrl+End jumps too far: Excel may remember cells that were formatted or edited beyond the visible data. Inspect the intervening area, and remove unnecessary formatting or content if appropriate.
A keyboard layout changes a symbol key: Shortcuts that use punctuation, such as Ctrl+; or Ctrl+`, may require a different physical key combination on a non-US layout.

For reliability, try a shortcut on a small sample before using it across an important range. Undo with Ctrl+Z if the result is not what you intended. For commands you use rarely, the ribbon or Format Cells dialog can be easier to verify than memorizing a key combination.

Frequently Asked Questions

What is the shortcut to edit a cell in Excel?
Press F2 to edit the active cell’s existing contents. On some Mac keyboards, press Fn+F2 if the function key is assigned to a hardware control.

How do I select an entire column or row?
Press Ctrl+Space to select the active cell’s column, or Shift+Space to select its row in Windows Excel. On Mac, system settings can affect Ctrl+Space, so check for a shortcut conflict if it does not work.

How do I put the same value in several cells at once?
Select the cells, type the value, and press Ctrl+Enter. Excel enters that value into every cell in the selection; check that the selection contains only the cells you want to change.

What is the shortcut to open Format Cells?
Press Ctrl+1 in Excel for Windows. In Excel for Mac, use Command+1. The dialog lets you change number formats, alignment, fonts, borders, and related cell settings.

Why does Ctrl+End go to a blank-looking cell?
Ctrl+End moves to the last cell Excel considers used, which can include cells with formatting or past content beyond the visible records. It is a navigation shortcut, not a guaranteed way to find the last nonblank value in a particular column.

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.