For Excel for Microsoft 365 on Windows, start with these essentials: Ctrl+C, Ctrl+V, and Ctrl+Z to copy, paste, and undo; Ctrl+Arrow keys to move through data; F2 to edit a cell; Ctrl+1 to format cells; and Ctrl+S to save. The shortcuts below cover common tasks and note where Mac or web use can differ.
Start with the everyday shortcuts
Keyboard shortcuts are key combinations that trigger commands without requiring a ribbon click. They are especially useful for repeated actions, such as entering values, checking a formula, or moving through a large worksheet. The most useful first group handles basic editing and file work:
- Ctrl+C, Ctrl+X, Ctrl+V: Copy, cut, and paste the selected cells or content.
- Ctrl+Z and Ctrl+Y: Undo and redo, respectively. Excel cannot undo every action, and some actions—such as running a macro—cannot be reversed with Ctrl+Z.
- Ctrl+S: Save the workbook. In a new workbook, this opens the Save As flow if a file name or location is needed.
- Ctrl+F and Ctrl+H: Find and replace text or values.
- Ctrl+P: Open the print screen, where you can review print settings and preview pages.
These commands act on the current selection. For example, copying a cell copies its contents and formatting; selecting a whole row before copying applies the action to that row. If a shortcut appears to do nothing, first check which cell, range, sheet, or dialog currently has focus.
Move around a worksheet quickly
Scrolling is fine for small sheets, but navigation shortcuts are faster when a worksheet has many rows or columns. Click a cell in the relevant area before using these keys:
- Arrow keys: Move one cell in the indicated direction.
- Ctrl+Arrow: Move to the edge of the current block of data in that direction. A blank cell can change where the block ends, so this is not always a jump to the final row of a worksheet.
- Home: Move to the beginning of the current row.
- Ctrl+Home: Move to the beginning of the worksheet, normally cell A1.
- Ctrl+End: Move to the last cell Excel regards as used. This may be farther down or across than the visible data if formatting remains in otherwise empty cells.
- Page Up and Page Down: Move up or down by roughly one screen. Alt+Page Up and Alt+Page Down move horizontally by roughly one screen.
- Ctrl+Page Up and 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 and jump directly there.
For example, if a sales list occupies a continuous block, Ctrl+Down from a cell in its first column can take you to the bottom of that block. If there is a blank row within the list, the shortcut may stop at the blank boundary; use Ctrl+G and a cell reference when you know the exact destination.
Select cells, rows, and columns
Selection shortcuts pair naturally with navigation. Hold Shift while moving to extend a selection, rather than replacing it. This makes it possible to select a range without dragging across the screen:
- Shift+Arrow: Extend the selection by one cell in the chosen direction.
- Ctrl+Shift+Arrow: Extend the selection to the edge of a contiguous data region. Empty cells can affect the endpoint.
- Ctrl+Space: Select the entire column of the active cell.
- Shift+Space: Select the entire row of the active cell.
- Ctrl+A: Select the current data region; pressing it again can expand the selection, often to the whole worksheet. The exact result depends on where the active cell is and whether the data is in a table.
These distinctions matter before deleting or formatting. Pressing Delete clears the contents of selected cells but does not remove the cells themselves or shift other data into their place. To remove an entire row or column, select it first and use the delete command from the Home tab or its context menu; check the selection before confirming a structural change.
Edit cells and enter data
Excel separates selecting a cell from editing its contents. A common source of confusion is typing while a cell is selected: that usually replaces the existing entry. Use these shortcuts to control the difference:
- F2: Edit the active cell’s contents. In a formula, this lets you inspect or change the expression directly.
- Enter: Commit an entry and move to another cell, usually the cell below.
- Esc: Cancel an edit that has not been committed.
- Alt+Enter: Insert a line break inside a cell while editing it.
- Ctrl+Enter: Enter the same value or formula into all cells in a selected range.
- Ctrl+;: Insert the current date as a fixed value. Ctrl+Shift+; inserts the current time as a fixed value.
For instance, select a range of blank cells, type a label, and press Ctrl+Enter to put that label in every selected cell. This is different from filling a series: it repeats the entry rather than automatically creating a sequence such as 1, 2, 3. For a line break in a long note, use Alt+Enter while the cell is being edited; simply pressing Enter normally commits the entry.
Work with formulas and calculations
Several shortcuts help build or inspect formulas without replacing the need to understand what a formula calculates:
- Alt+=: Insert an AutoSum formula, typically using nearby numbers in the suggested range. Check the highlighted range before accepting it.
- F4: While editing a formula reference, cycle through relative and absolute forms, such as A1, $A$1, A$1, and $A1. Outside formula editing, F4 can repeat the last eligible action.
- Ctrl+`: Toggle the display of formulas in place of their calculated results. The accent key is usually near the upper-left area of a Windows keyboard.
- F9: Recalculate formulas in open workbooks. Shift+F9 recalculates the active worksheet.
Suppose a formula refers to A1 and you plan to copy it down a column. A1 is a relative reference, so it normally changes as the formula is copied. Pressing F4 while editing that reference can make it $A$1, which stays fixed when copied. The dollar signs lock the column and row; they do not change the value in the referenced cell. AutoSum is similarly a time-saver, not a guarantee: a blank row or an unexpected neighboring number can cause Excel to suggest a range you should adjust.
Format cells and manage data
Formatting and data-management shortcuts reduce trips to the ribbon, but the formatting choices still need to fit the data. These are useful starting points:
- Ctrl+1: Open the Format Cells dialog, which includes number formats, alignment, fonts, borders, and other options.
- Ctrl+B, Ctrl+I, Ctrl+U: Toggle bold, italic, and underline for the selected cells or text.
- Ctrl+Shift+$: Apply a currency number format. Ctrl+Shift+%: Apply a percentage format.
- Ctrl+T: Create a table from a selected data range. Confirm the range and whether the first row contains headers.
- Ctrl+Shift+L: Turn filters on or off for a data range. In a table, filter controls are generally available in the header row.
- Alt+Down Arrow: Open a cell’s filter menu when focus is in a filtered header, or open a drop-down list in supported data-validation cells.
Number formatting changes how a value is displayed, not necessarily the underlying value. For example, applying a percentage format to 0.25 displays 25%; applying it to 25 displays 2500%. If the display looks wrong, check both the stored value and the selected number format. Tables and filters also have different roles: a table organizes a range and can expand with new rows, while a filter temporarily hides rows that do not match chosen criteria.
Windows, Mac, and Excel for the web
This list is written for Excel for Microsoft 365 on Windows, where Ctrl and Alt are common modifier keys and Alt sequences can access ribbon commands. On a Mac, many familiar actions use Command instead of Ctrl: for example, Command+C, Command+V, Command+Z, Command+S, and Command+F are common Mac equivalents for copy, paste, undo, save, and find. However, it is not safe to replace every Ctrl with Command. Navigation, function keys, ribbon access, and some editing shortcuts differ, and function keys may require the Fn key depending on the Mac’s keyboard settings.
Excel for the web runs in a browser, so a browser or operating system can intercept some key combinations. Available shortcuts can also differ from the desktop app. If a shortcut conflicts or does not work, use Excel’s visible ribbon command or its in-product shortcut help for the version and operating system in use. Keyboard layouts can change the key used for punctuation shortcuts, including Ctrl+`.
Common shortcut problems and practical habits
A shortcut can be correct but still produce an unexpected result because Excel responds to context. A cell in edit mode, a selected chart, an open dialog, or a different worksheet can change what the keys do. Check the active cell and selection before actions that overwrite or remove data. Undo immediately when a result is unintended, but remember that not every operation is undoable.
- Ctrl+End lands too far away: Excel may consider cells with leftover formatting to be used. Inspect the intervening rows and columns before deleting anything, and save a copy before substantial cleanup.
- A shortcut types a character instead: The cell may be in edit mode, or a dialog may have focus. Press Esc if you need to cancel an unfinished entry, then select the intended cell.
- A key combination does nothing: Check whether the feature applies to the current selection and whether another app or the browser captured the shortcut.
- Alt sequences feel unfamiliar: On Windows, press Alt to show ribbon Key Tips, then follow the letters or numbers shown on screen. The sequence can depend on the current ribbon layout and language.
Build a small personal routine rather than memorizing every shortcut at once. Learn save, undo, navigation, cell editing, and formatting first; then add shortcuts for the tasks you repeat, such as filtering or inserting a table. A shortcut is most valuable when it prevents a repetitive action, not when it makes a one-off task harder to remember.
Frequently Asked Questions
What is the most useful Excel shortcut? There is no single best shortcut for everyone. Ctrl+Z is widely useful for undoing a recent mistake, while Ctrl+Arrow is a strong choice for moving through large, continuous data blocks.
How do I quickly find a value in Excel? Press Ctrl+F, enter the text or value, and use the Find controls to move through matches. Use Ctrl+H when you want to replace matching content, and review the replacement scope before applying it.
How do I jump to a specific cell? Press Ctrl+G or F5, type a reference such as D250, and confirm. Excel moves the active selection to that cell.
How do I make a new line inside an Excel cell? While editing the cell, press Alt+Enter on Windows. On Mac, the equivalent key combination can differ by Excel version and keyboard, so use the in-app shortcut help if that combination does not work.
Are Excel keyboard shortcuts the same on Mac? No. Many common commands use Command on Mac where Windows uses Ctrl, but navigation and other shortcuts vary. Check the shortcuts for your Excel version and operating system rather than substituting keys mechanically.
Related
- Excel Dependent Drop-Down Lists in Tables
- Excel Date Number to Text: Convert Dates Clearly
- Excel Data Validation List: Create a Yes/No Dropdown
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Table Dropdown List: Create and Manage ListsTo add a dropdown list to an Excel table, select the cells in its column, choose Data >…
- Can You Shade Half a Cell in Excel? Options ExplainedExcel does not have a built-in cell format that fills exactly half of a cell with one color…
- How to Calculate a Percentage of a Number in ExcelTo get a percentage of a number in Excel, multiply the number by the percentage: enter the number…
- Excel Keyboard Shortcut to Reduce Decimal Places in CellsIn Excel for Microsoft 365 for Windows, select the cells and press Alt+H, 9 to reduce the number…
- Combine Excel Files into One: Methods and Best PracticesTo combine Excel files into one, either copy sheets or data into a new workbook, or use Power…
- Jotform to Google Sheets: Setup, Syncing, and FixesTo send Jotform responses to Google Sheets, open the form in Jotform, go to Settings > Integrations, search…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.