Excel 365 keyboard shortcuts let you navigate, edit, format, and calculate without reaching for the mouse. On Windows, start with Ctrl+C and Ctrl+V for copying and pasting, Ctrl+Z to undo, Ctrl+Arrow keys to move to the edge of a data region, and Ctrl+1 to open Format Cells; on a Mac, many common commands use Command instead of Ctrl, but not every shortcut follows that pattern.
How Excel keyboard shortcuts work
A shortcut combines one or more keys to run a command. Some shortcuts work throughout Excel, while others depend on what you are doing: F2 edits the active cell, for example, and Ctrl+Shift+Arrow selects cells only when the worksheet has focus. Ribbon KeyTips offer another route on Windows. Press Alt to display letters for ribbon tabs and commands, then press the shown letters in sequence. The letters can depend on the command and interface, so follow what appears on screen rather than memorizing a sequence from another Excel version.
Excel for Microsoft 365 receives updates, and keyboard layouts, operating-system settings, and add-ins can affect what happens when keys are pressed. The Windows shortcuts below are the main reference. If a shortcut does not work, check that Excel has focus, that the selected cell or object is appropriate, and that your keyboard layout matches the key combination.
Everyday shortcuts for files and editing
These commands are useful in almost any workbook, whether you are entering a quick list or maintaining a large report:
- Ctrl+S: Save the workbook. For a new file, Excel may ask where to save it.
- Ctrl+Z: Undo the most recent action; Ctrl+Y generally repeats or redoes an action.
- Ctrl+C, Ctrl+X, Ctrl+V: Copy, cut, and paste the current selection.
- Ctrl+F: Find text or values; Ctrl+H opens Find and Replace.
- Ctrl+P: Open the print screen, where you can review print settings and preview.
- Ctrl+N: Create a new workbook; Ctrl+O open a workbook.
Clipboard shortcuts act on the selected cell, range, or object. If you copy a range, Excel usually shows a moving border around it until you paste or cancel the selection. Be cautious when pasting over existing data: paste replaces the contents of the destination cells. Use Undo promptly if a paste has an unintended result, though some actions cannot be undone.
Move around a worksheet and select data
For a large sheet, navigation shortcuts can save more time than any formatting command. Ctrl+Arrow moves to the edge of the current block of data in that direction. For instance, from a filled cell in a continuous column of sales figures, Ctrl+Down moves to the bottom of that block; if there is a blank cell in the way, it stops at the edge of the current region instead of skipping across the gap. Add Shift to select cells while moving: Ctrl+Shift+Down extends the selection to the edge of the region.
- Home: Move to the first column of the current row.
- Ctrl+Home: Go to the beginning of the worksheet.
- Ctrl+End: Go to the last cell Excel regards as used. Formatting left far below or to the right of visible data can make this cell seem unexpectedly distant.
- Ctrl+Page Up / Ctrl+Page Down: Move to the previous or next worksheet tab.
- Ctrl+Space: Select the current column; Shift+Space selects the current row.
- Ctrl+A: Select the current data region in many worksheet contexts. Pressing it again can expand the selection, and behavior may vary inside a table or other object.
To select a specific distant cell, you can also use the Name Box to the left of the formula bar: enter a reference such as G250 and press Enter. This is often clearer than repeatedly holding an arrow shortcut, especially when a worksheet contains blank rows or columns that interrupt a data block.
Enter and edit cell contents
When a cell is active, start typing to replace its contents. Press F2 to edit the existing cell contents rather than replace them. While editing a formula, the arrow keys can help move the insertion point or select cell references, depending on the editing state. Press Enter to commit an entry; by default, Excel moves the active selection down afterward.
- Alt+Enter: Insert a line break within a cell while entering or editing its contents. The cell may need Wrap Text enabled for multiple lines to display clearly.
- Ctrl+Enter: Enter the same typed value or formula into every cell in a selected range. Select the range first, type the entry, then use the shortcut.
- Ctrl+D: Fill down from the top cell of a selected range. Ctrl+R fills right from the leftmost cell.
- Delete: Clear the contents of selected cells without removing the cells themselves.
For example, if B2 contains a formula and you select B2:B20, Ctrl+D copies the top cell’s contents down through the selection. Relative cell references adjust as they are filled, just as they do when you drag the fill handle. Check the first and last filled results before relying on a copied formula in a report.
Format cells, rows, and columns quickly
Formatting shortcuts are handy when a workbook needs consistent presentation. Ctrl+1 opens the Format Cells dialog, where you can set number formats, alignment, fonts, borders, and protection. The dialog is useful when you need more control than a single ribbon button provides, such as showing a date in a chosen format or adding a custom border.
- Ctrl+B: Toggle bold for selected cells or text.
- Ctrl+I: Toggle italics; Ctrl+U toggles underline.
- Ctrl+Shift+L: Turn AutoFilter buttons on or off for a data range. Select a cell in the range first; a properly structured table is often easier to filter and expand.
- Ctrl+T: Create a table from a selected data range and review the range and header option in the dialog.
- Ctrl+9: Hide selected rows; Ctrl+0 hides selected columns. Excel also has unhide shortcuts, but key combinations can be affected by keyboard layout and system settings.
Shortcuts do not replace good data structure. A filter works best when each column has a header and the records form a continuous range. If the selection is wrong before you create a table, check the proposed range and whether the data has headers before confirming.
Shortcuts for formulas and calculations
Excel includes several useful calculation shortcuts. Press Alt+= to insert AutoSum in a suitable position. Excel proposes a range based on nearby data, but the highlighted range is only a suggestion: inspect it before pressing Enter, particularly if blank cells or other totals are nearby.
- F4: While editing a formula and a cell reference is selected, cycle through reference styles such as A1, $A$1, A$1, and $A1. This lets you lock a row, a column, or both when copying a formula. Outside formula editing, F4 can repeat the last action for commands Excel supports.
- Ctrl+;: Insert the current date as a fixed value.
- Ctrl+Shift+;: Insert the current time as a fixed value.
- Ctrl+`: Toggle the display of formulas in place of calculated results. The grave-accent key location varies by keyboard layout.
Dates and times entered with these shortcuts are static entries: they do not update continuously. That is different from a date or time produced by a formula. Likewise, showing formulas changes the worksheet display, not the formulas themselves. Use the same shortcut again to return to the regular results view.
Choose shortcuts that fit the task
There is no need to memorize every Excel shortcut. Choose a small group that matches your routine, then add more when a repeated task becomes frustrating. For data entry, F2, Ctrl+Enter, and Ctrl+D can be more valuable than chart shortcuts. For reviewing a long sheet, Ctrl+Arrow, Ctrl+Home, Ctrl+End, and the sheet-navigation commands are a practical set.
A useful way to build a habit is to replace one mouse action at a time:
- Identify an action you repeat, such as opening Format Cells or moving between sheets.
- Use the shortcut consistently for a few sessions, checking the result before moving on.
- Keep a short reference list beside your work until the combination becomes familiar.
- Add a shortcut only when you understand the selection it acts on; many errors come from applying a correct command to the wrong range.
Shortcuts can also make a workflow easier to repeat, but they are not automatically safer. Before using a fill, delete, or paste command on a large range, confirm the selection and consider saving the workbook. Undo is useful, but it is not a substitute for a checked backup when making important changes.
Windows, Mac, and Excel for the web
This guide prioritizes Excel 365 for Windows. In Excel for Mac, common commands such as copy, paste, save, undo, and find usually use Command in place of Ctrl: for example, Command+C copies and Command+Z undoes. That substitution is not universal. Some navigation, function-key, and ribbon shortcuts differ, and Mac function keys may require the Fn key depending on the keyboard and system settings. Check Excel’s Help shortcut list for the exact Mac command rather than assuming every Windows combination translates directly.
Excel for the web runs in a browser, so some key combinations may be intercepted by the browser or operating system, and available commands can differ from desktop Excel. If a shortcut opens a browser feature instead of acting in the sheet, use the relevant ribbon command or consult the web app’s shortcut list. The same principle applies to specialized keyboards: keys such as the grave accent and function keys are not positioned or configured identically everywhere.
Common shortcut problems and fixes
If a shortcut seems ineffective, first click a worksheet cell and try again. Excel may be in cell-editing mode, a dialog may have focus, or a chart or shape may be selected; the same keys can behave differently in those contexts. If Ctrl+Arrow stops early, look for a blank cell dividing the data region. If Ctrl+End lands far past the visible table, cells with leftover formatting may be extending Excel’s used range.
Some keys are also shared with Windows, macOS, or other programs. On a Mac, Control+Space can conflict with system input-source settings on some configurations, even though Excel uses it for column selection. Change the conflicting system shortcut or use the ribbon command if needed. Finally, check the active keyboard layout and whether a laptop requires Fn for function keys. A shortcut reference for a different platform or layout may show a combination that does not match your keyboard.
Frequently Asked Questions
What are the most useful Excel shortcuts for beginners?
Start with Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+S, Ctrl+F, Ctrl+Arrow, and Ctrl+1 on Windows. Together they cover copying, pasting, undoing, saving, finding, navigating, and formatting without requiring a long list to memorize.
How do I move to the last row of data in Excel?
Select a cell in the relevant column and press Ctrl+Down on Windows. Excel moves to the edge of the current continuous data region, so a blank cell can stop the movement early. Ctrl+End instead goes to Excel’s last used cell, which may include formatted cells beyond the data.
How do I switch between sheets with the keyboard?
In Excel for Windows, use Ctrl+Page Down for the next worksheet and Ctrl+Page Up for the previous one. These commands move among worksheet tabs in the workbook; they do not switch between separate workbook windows.
Why does Ctrl+Arrow stop before the end of my data?
That shortcut stops at the boundary of a continuous region. A blank cell in the column or row can create a boundary, so Excel may stop before the final record. Move past the gap and use Ctrl+Arrow again, or use the Name Box to jump to a known cell reference.
Are Excel shortcuts the same on Windows and Mac?
No. Many common editing commands use Command instead of Ctrl on Mac, but navigation and other shortcuts can differ. Consult the shortcut list for your version and platform, especially for function keys and combinations that may conflict with system settings.
Related
- Unmerge Cells in Excel: Keyboard Shortcuts and Steps
- How to Unmerge Cells in Excel and Keep Data
- Unmerge Cells in Excel on iPad: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets: How to Freeze the Top Two Rows on ScreenTo freeze the top two rows in Google Sheets, open the spreadsheet in a web browser and choose…
- How to Sum in Excel Using the Keyboard: Quick StepsTo sum a column quickly in Excel for Microsoft 365 on Windows, select the blank cell directly below…
- How to Add a Colored Header in Microsoft Word DocumentsTo add a colored header in Word, open the header area, insert a rectangle shape, choose a fill…
- Count Excel Without Blanks: COUNTA and Other MethodsTo count cells that are not blank in Excel, use =COUNTA(A2:A20), replacing A2:A20 with your range. COUNTA counts…
- Add a Checkbox to the Excel Toolbar in Microsoft 365To add a checkbox to a worksheet in Microsoft 365, select the target cell or range and choose…
- How to Flip an Excel Sheet Upside Down by Reversing RowsTo flip an Excel sheet upside down, reverse the order of its rows: add a temporary helper column,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.