For Excel for Microsoft 365 on Windows, the most useful shortcuts include Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, Ctrl+Arrow key to jump to the edge of a data region, Ctrl+1 to format cells, and Alt+= to insert AutoSum. This cheat sheet groups practical shortcuts by task and notes where the Mac or web version differs.
How to use this cheat sheet
In the shortcuts below, Ctrl means the Control key and Shift means the Shift key. A plus sign means press the keys together: for example, Ctrl+S means hold Ctrl while pressing S. A comma between key combinations means press them in sequence, not simultaneously. Some shortcuts behave differently depending on whether you are editing a cell, selecting a range, or working inside a table.
Shortcuts are most useful when they replace a repeated mouse action. Start with a small set you use every day, then add task-specific combinations as needed. If a shortcut seems not to work, check that Excel has focus and that you are not currently typing inside a cell or a dialog box.
- File and editing basics: Ctrl+S, Ctrl+Z, Ctrl+C, and Ctrl+V.
- Moving around: Ctrl+Arrow keys, Ctrl+Home, and Ctrl+End.
- Working with cells: F2, Ctrl+1, Ctrl+D, and Ctrl+R.
- Tables and data: Ctrl+T and Ctrl+Shift+L.
Open, save, and manage workbooks
These combinations cover common workbook and window tasks. Saving regularly is especially important before making broad changes, such as replacing data across a sheet or sorting a large range.
- Ctrl+N: Create a new workbook.
- Ctrl+O: Open the file browser to choose a workbook.
- Ctrl+S: Save the current workbook. If it has not been saved before, Excel prompts you to choose a name and location.
- Ctrl+P: Open the print screen, where you can inspect print settings and preview pages.
- Ctrl+W: Close the current workbook window. It does not necessarily quit Excel.
- Ctrl+Z: Undo the most recent action, when that action can be undone.
- Ctrl+Y: Redo an action or repeat certain actions. What it does depends on what you just did.
Undo history is not a substitute for saving a recoverable copy before risky changes. Some operations, including running a macro, cannot be reversed with Ctrl+Z. For significant edits, save a separate copy or use version history where available.
Move through worksheets and select ranges
Navigation shortcuts can be more efficient than scrolling, especially in long sheets. Ctrl+Arrow moves to the edge of the current data region in the direction pressed. For example, from A2 in a continuous list in column A, Ctrl+Down moves to the last filled cell in that uninterrupted block. If a blank cell interrupts the list, the jump stops at the edge of the smaller region.
- Ctrl+Home: Move to the beginning of the worksheet, normally cell A1. With frozen panes, the destination can reflect the top-left cell of the scrollable area.
- Ctrl+End: Move to the last cell Excel considers used. That may be farther than the visible data if formatting or old entries remain elsewhere.
- Ctrl+Page Up / Ctrl+Page Down: Move to the previous or next worksheet tab.
- Ctrl+G or F5: Open Go To, where you can enter a cell reference such as D250 or choose a named range.
- Ctrl+Space: Select the current column.
- Shift+Space: Select the current row.
- Ctrl+Shift+Arrow key: Extend the selection to the edge of a data region.
Ctrl+A selects the current region in many ordinary worksheet contexts; pressing it again can expand the selection to the whole sheet. Inside an Excel table, selection behavior is table-aware and may select table sections instead. For large or irregular data, Ctrl+G can be a more predictable way to reach a known cell.
Edit cells and repeat common actions
Use these shortcuts to change cell contents without navigating through the ribbon. They are particularly helpful when cleaning up a list or entering the same value in several places.
- F2: Edit the active cell. The cursor appears within the existing content, allowing you to change part of a value or formula.
- Enter: Commit an entry and usually move the selection down one cell. Tab commits the entry and usually moves one cell to the right.
- Esc: Cancel an entry that has not yet been committed.
- Alt+Enter: Insert a line break within the current cell while editing it.
- Ctrl+Enter: Enter the same typed value or formula into every cell in a selected range. Select the range first, type the entry, then press Ctrl+Enter.
- Ctrl+D: Fill down, copying the top cell’s contents or formula into the selected cells below it.
- Ctrl+R: Fill right, copying the leftmost cell’s contents or formula across the selected cells to its right.
- Ctrl+E: Start Flash Fill, which can recognize and complete a pattern in adjacent data, such as separating a first name from a full name. Review the results because Flash Fill produces values rather than a live formula.
For example, to copy a formula from B2 down through B20, select B2:B20 and press Ctrl+D. Check that the formula references should adjust as they fill; if the source formula uses absolute references, those references remain fixed.
Format cells and enter dates or times
Formatting shortcuts change how information is displayed; they do not usually change the underlying value. A percentage format, for instance, can make 0.25 display as 25%, while the stored number remains 0.25.
- Ctrl+1: Open the Format Cells dialog, which includes number formats, alignment, fonts, borders, and protection settings.
- Ctrl+B: Toggle bold.
- Ctrl+I: Toggle italic.
- Ctrl+U: Toggle underline.
- Ctrl+Shift+$: Apply a currency format.
- Ctrl+Shift+%: Apply a percentage format.
- Ctrl+; Enter the current date as a fixed value.
- Ctrl+Shift+; Enter the current time as a fixed value.
A fixed date or time does not keep updating. If you need a value that recalculates, use an appropriate worksheet function instead, but remember that formula results can change when the workbook recalculates. On some keyboards, the punctuation keys are in different positions, so the shortcut may take practice.
Work with tables, filters, and data
Excel tables and filters help organize data, but shortcuts work best when the data has clear headers and each column contains one type of information. Avoid leaving blank rows or columns inside a dataset if you want Excel to recognize it as one continuous region.
- Ctrl+T: Turn a selected data range into an Excel table. Excel opens a dialog to confirm the range and whether it has headers.
- Ctrl+Shift+L: Turn AutoFilter on or off for a range. Filter arrows let you show rows that meet selected criteria.
- Alt+Down Arrow: Open a filter drop-down when the active cell is in a filtered header. In other contexts, it can open a cell’s data-validation list.
- Alt+=: Insert AutoSum. Excel proposes a range to total; check that the selected cells are the ones you intend to add before accepting.
- Shift+F11: Insert a new worksheet.
Filtering hides rows; it does not delete them. Before copying or deleting filtered data, confirm whether the action applies only to visible cells or to a broader selection. Likewise, sorting one column by itself can separate values from the records they belong to. Select the full dataset or use a table so each row stays together.
Write and inspect formulas
Several high-value shortcuts help while building formulas. Press F2 to edit a formula in place. While creating or editing a formula, F4 can cycle through reference styles for a selected cell reference: for example, changing A1 to $A$1, A$1, or $A1. The exact behavior depends on having a reference selected in the formula.
Absolute references are useful when a formula should keep pointing to one cell as it is copied. For example, if a tax rate is stored in F1, a formula copied down a column may need to preserve that reference as $F$1 while allowing the row reference for the item to change. F4 cycles the reference markers; it does not insert a complete formula for you.
Ctrl+` toggles the display of formulas in place of their calculated results in many Windows Excel configurations. The grave-accent key can be in different locations depending on the keyboard layout. This view is handy for checking whether a column contains formulas or fixed values, but it also changes the apparent width needed to read cells. Press the same shortcut again to return to normal results.
When a formula returns an unexpected result, first check the cell references, parentheses, and whether numbers are stored as text. Shortcuts speed up entry, but they do not verify that a formula represents the intended calculation.
Windows, Mac, and Excel for the web
This guide is written for Excel for Microsoft 365 on Windows. On a Mac, many familiar editing shortcuts use Command instead of Ctrl: for example, Command+S saves and Command+C and Command+V copy and paste. However, not every Windows shortcut has a direct one-for-one replacement. Some combinations use Control or Option on Mac, and function keys may require holding Fn because macOS or the keyboard may assign them other actions.
Ribbon key tips also differ. Windows users can press Alt to display key tips for ribbon commands, then follow the letters or numbers shown on screen. Do not assume that the same Alt sequence works on Mac. Check Excel’s current shortcut help for your platform and keyboard layout, especially for navigation, date entry, and function-key commands.
Excel for the web runs in a browser, so a shortcut can be intercepted by the browser or operating system instead of Excel. The available combinations may also vary by browser and whether the workbook is in editing mode. If a Windows shortcut fails there, use the on-screen ribbon or consult Excel’s web-specific shortcut list rather than assuming the desktop behavior is identical.
Common shortcut problems and useful habits
A shortcut that appears to do nothing often has a simple explanation. Excel may be in cell-edit mode, a dialog may be active, the wrong worksheet may have focus, or the keyboard layout may place a symbol on a different key. Protected sheets and workbooks can also restrict edits regardless of which shortcut you use.
- Check the active cell: Look at the Name Box and formula bar before applying a change to a large selection.
- Confirm selection size: Ctrl+Enter, Ctrl+D, and Ctrl+R act on selected cells, so an unexpectedly large selection can affect more cells than intended.
- Use the ribbon as a check: If you are unsure what a command does, find it on the ribbon and compare the displayed command or tooltip.
- Save before bulk edits: Sorting, filling, replacing, and pasting can change many cells at once. A saved copy gives you a recovery option.
- Learn in groups: Practice navigation first, then editing and formatting. Memorizing a few dependable shortcuts is more useful than trying to learn an entire list at once.
There is no single shortcut that is best for every workflow. A keyboard-heavy user may prefer Ctrl+G to jump directly to cells, while someone reviewing a report may rely more on Ctrl+1, filters, and print preview. Choose shortcuts based on repeated tasks, and verify the result after any action that affects many rows or columns.
Frequently Asked Questions
What is the shortcut for copy and paste in Excel?
On Windows, use Ctrl+C to copy and Ctrl+V to paste. On Mac, the usual equivalents are Command+C and Command+V. You can use Ctrl+X on Windows or Command+X on Mac to cut selected cells.
How do I go to the last used cell in Excel?
Press Ctrl+End on Windows. Excel moves to the last cell it considers used, which can include cells with leftover formatting. If the destination seems too far away, inspect and clear unnecessary formatting or content beyond your real dataset.
How do I insert the current date in an Excel cell?
In Windows desktop Excel, press Ctrl+; to enter today’s date as a fixed value. It will not automatically change tomorrow. Keyboard layouts and Mac shortcuts can differ, so consult the shortcut list for your version if the punctuation combination is not recognized.
Can I create my own Excel keyboard shortcuts?
Excel does not provide a general built-in editor for assigning any shortcut to any command. You can customize the Quick Access Toolbar, and some commands or macros can be launched with assigned shortcuts, but macro shortcuts require care and macros cannot be undone with Ctrl+Z.
Why does Ctrl+End take me past my data?
Excel may still consider cells beyond your visible records to be used because they contain old values or formatting. Inspect the extra rows or columns before deleting anything; save a copy first if you are unsure whether that content is needed.
Related
- Excel: How to Paste in Filtered Cells Only
- Excel How to Paste in Merged Cells Without Errors
- Excel: How to Reverse the Order of Data in a Column
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Confidential Watermark in Word DocumentsTo add a CONFIDENTIAL watermark in Microsoft Word for Microsoft 365 on Windows, open the document and choose…
- Box Plot Worksheet: How to Read and Make OneA box plot worksheet helps you organize numerical data, calculate its five-number summary, and display its distribution as…
- Duplicates in Google Sheets: Copy Cells and Rows SafelyTo put duplicate data in Google Sheets, select the cells or row you want to copy, press Ctrl+C,…
- Excel Cell Width in Inches: What the Number Really MeansExcel does not measure column width directly in inches: its width setting is based on the number of…
- Data Validation and Verification in Excel ExplainedData validation checks whether data follows defined rules, while data verification checks whether it is accurate and matches…
- Excel Conditional Formatting Number Formats ExplainedYes—Excel conditional formatting can apply a number format when a rule is true, without changing the cell’s underlying…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.