For Microsoft Word and Excel on Windows, the most useful shortcuts to start with are Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo, and Ctrl+S to save. Word shortcuts focus on writing and document formatting; Excel shortcuts also help you move around a worksheet, enter data, and work with tables and formulas. The lists below cover practical everyday combinations, explain where the two programs differ, and note the main Mac variations.
How keyboard shortcuts work
A keyboard shortcut combines keys to carry out an action without choosing it from a ribbon or menu. In most Windows shortcuts, you hold Ctrl or Alt while pressing another key. For example, hold Ctrl and press B to apply bold formatting. When two keys are joined by a plus sign, press and hold the first key, tap the next, and then release them; a sequence such as Alt, H, O, I is different, because you press those keys one after another to move through ribbon commands.
Shortcuts can be context-sensitive. Ctrl+B makes selected text bold in Word, while in Excel it can bold selected cell content. The same key may also behave differently depending on whether you are editing a cell, selecting a range, or working in a dialog box. If a shortcut seems not to work, first check where the insertion point or selection is.
Some keyboards require an Fn key for function keys such as F2, especially on laptops where the top row controls brightness or volume by default. Keyboard layouts and language settings can also affect punctuation-based shortcuts. The commands described here are for Microsoft 365 on Windows unless a Mac difference is mentioned.
Shared shortcuts for everyday editing
These combinations are useful in both Word and Excel, though the exact result can depend on what is selected:
- Ctrl+N: Create a new document or workbook.
- Ctrl+O: Open a file, and Ctrl+S saves the current file.
- Ctrl+P: Open the print screen.
- Ctrl+C, Ctrl+X, and Ctrl+V: Copy, cut, and paste.
- Ctrl+Z and Ctrl+Y: Undo and redo or repeat an action, depending on the program and the action.
- Ctrl+A: Select content. In Excel, repeated presses can expand the selection to a larger current region or the worksheet.
- Ctrl+F: Find text or values; Ctrl+H opens Find and Replace.
Clipboard shortcuts are not the same as moving content between applications. You can copy text from Word and paste it into Excel, but Excel may interpret line breaks and tabs as rows and columns. When formatting from a source document is unwanted, use the paste options that appear after pasting or choose a suitable option in the application’s paste controls. Ctrl+Alt+V opens Paste Special in many Office workflows, but the available choices depend on the copied material and destination.
Word shortcuts for writing and navigation
Word’s strongest shortcuts help you edit text without repeatedly reaching for the mouse. Use Ctrl+Backspace to delete the preceding word and Ctrl+Delete to delete the following word. Ctrl+Home moves to the beginning of the document, while Ctrl+End moves to its end. With text selected, the arrow keys can extend or change the selection; holding Shift while pressing an arrow selects characters or lines.
For document structure, Ctrl+Enter inserts a page break at the cursor. This is usually more reliable than pressing Enter repeatedly to push text onto a new page: if earlier content changes, a run of blank paragraphs can shift unpredictably. Ctrl+F opens the Navigation pane for searching, and Ctrl+H opens the replacement controls. Search is useful for locating a word; Replace is useful for consistently changing a term throughout a long document, but review replacements carefully when a word appears in different contexts.
- Ctrl+L: Align the paragraph left.
- Ctrl+E: Center the paragraph.
- Ctrl+R: Align the paragraph right.
- Ctrl+J: Justify the paragraph.
- Ctrl+Shift+N: Apply the Normal style.
- Ctrl+Alt+1: Apply the Heading 1 style.
Heading styles do more than change a line’s appearance: they give a document a navigable outline and make it easier to build a table of contents. A heading made large and bold manually may look similar, but it does not automatically provide the same document structure.
Word shortcuts for formatting and review
For quick character formatting, use Ctrl+B for bold, Ctrl+I for italics, and Ctrl+U for underline. These are toggles: select text and press the shortcut to apply the style, or place the cursor in formatted text and use it to turn the style off for subsequent typing. Ctrl+K opens the link dialog so you can add a hyperlink to selected text.
Ctrl+Shift+8 shows or hides formatting marks, including paragraph marks, spaces, and tab symbols. These marks do not print; they help explain layout problems such as an unexpected blank paragraph or extra spacing. For example, if a heading appears on a new page, showing marks can help reveal whether a page break or a group of paragraph marks caused it.
Word also supports keyboard access to ribbon commands through Key Tips. Press Alt to display letters or letter combinations, then press the displayed keys to reach a command. Key Tips can vary with the ribbon layout and language, so follow what appears on screen rather than memorizing a sequence from a different installation.
Excel shortcuts for moving around a worksheet
Excel’s large grid makes navigation shortcuts especially valuable. Press Ctrl+Arrow to move toward the edge of a continuous block of data in that direction. For example, from a filled cell in a column, Ctrl+Down generally moves to the last filled cell in that contiguous block. If the next cell is blank, the movement stops at the edge of the current block instead. Add Shift to select cells along the movement: Ctrl+Shift+Arrow extends the selection to the edge of the data region.
Ctrl+Home moves toward the beginning of the worksheet, and Ctrl+End moves to the last cell Excel considers used. The latter can be beyond the visible data if formatting or old content remains in distant cells. F2 edits the active cell, letting you change its contents without replacing them. Alt+Enter inserts a line break within a cell while editing its contents.
- Ctrl+Space: Select the entire column of the active cell.
- Shift+Space: Select the entire row of the active cell.
- Ctrl+Page Up and Ctrl+Page Down: Move to the previous or next worksheet tab.
- Ctrl+T: Turn a selected data range into an Excel table; check the detected range and whether the data has headers in the dialog.
- Ctrl+Shift+L: Toggle filter buttons for a data range.
Selection shortcuts work best when a data set has a clear layout. A fully blank row or column can divide a region, so Ctrl+Arrow may stop sooner than expected. Likewise, a table with consistent headers and no accidental gaps is easier to navigate and filter than an unstructured range.
Excel shortcuts for formulas and data entry
Alt+= inserts an AutoSum formula for a nearby range that Excel detects. Check the highlighted cells before pressing Enter; the suggested range is convenient, not a guarantee that Excel has selected exactly the values you intended. When you copy a formula, relative references usually adjust to the new location. While editing a formula, press F4 to cycle through reference styles for a selected cell reference, such as changing a relative reference to an absolute one. Outside formula editing, F4 can repeat the last action in many Excel situations.
To enter a fixed date in the active cell, press Ctrl+;. To enter the current time, press Ctrl+Shift+;. These shortcuts insert values rather than a continuously updating date or time formula. If you need a date that changes automatically, use a suitable worksheet formula instead; decide whether you need a fixed entry or a changing result before choosing.
Ctrl+1 opens the Format Cells dialog, where you can change number formats, alignment, borders, and other cell settings. This is often faster than navigating several ribbon controls when you need a specific number format. The number format changes how a value is displayed, not necessarily the underlying value. For instance, formatting a decimal as a percentage affects its display, so confirm the result is appropriate for your data.
Press Ctrl+` to switch between displaying formulas and displaying their results. The key shown here is the grave accent, usually near the upper-left area of a US keyboard; its position can differ on other layouts. This view is useful for reviewing a sheet’s formulas, but it changes how the sheet is displayed, not the formulas themselves.
Windows and Mac differences
On a Mac, the Command key commonly replaces Ctrl for everyday commands: use Command+C to copy, Command+V to paste, Command+Z to undo, and Command+S to save in Word and Excel for Mac. Command+F is the familiar search shortcut. This substitution is a helpful starting point, not a rule for every command; some Excel and Word functions use Control, Option, or different combinations on Mac.
For example, in Word for Mac, Command+Return inserts a page break, rather than the Windows Ctrl+Enter combination. In Excel for Mac, function-key behavior can depend on macOS keyboard settings and whether the keyboard’s Fn or Globe key is needed. Excel for the web can also differ from the desktop applications, and a browser may reserve some key combinations for its own commands. If a shortcut is unavailable, check the application’s menus or shortcut help for that version and platform.
There is no separate shortcut list that is universally correct for every keyboard layout, operating system, and Office edition. Microsoft can also adjust commands over time. The most dependable check is the command’s menu or ribbon Key Tip on the device you are using, especially for less common actions.
How to learn shortcuts without slowing down
Start with a small set tied to work you do every day rather than trying to memorize a long chart. A writer might begin with saving, undoing, finding, applying headings, and inserting a page break. Someone managing a worksheet might learn navigation, cell editing, formatting, filtering, and AutoSum first.
- Choose two or three repeated mouse actions and learn their shortcuts.
- Use each shortcut deliberately for a few days, checking that it did the intended action.
- Add a new shortcut once the first set feels familiar.
- Keep a short reference list beside your computer for uncommon commands.
It is useful to understand the command as well as the key combination. Ctrl+T in Excel, for instance, creates a table from a suitable selection; it is not simply a shortcut for adding borders. Knowing what the command changes helps prevent mistakes and makes it easier to find the equivalent through the ribbon when your keyboard or version differs.
Common shortcut problems
If a shortcut does something unexpected, check the active application and the current focus. A cursor in a cell’s formula bar is different from a selected cell, and a search box may capture keystrokes instead of the document. Make sure you are not holding a modifier key longer than needed, and check whether a function-key row requires Fn.
In Excel, a navigation shortcut may stop at a blank cell because it is designed to move across a contiguous region. In Word, formatting may appear not to apply if the selection includes a paragraph mark or if a style overrides direct formatting. In either program, the Undo command can reverse many recent actions, but not every action in every circumstance. Save important work regularly, particularly before using unfamiliar commands or editing a large range.
Finally, shortcuts do not always transfer exactly between Windows, Mac, and browser versions. When a familiar combination is intercepted by the operating system or browser, use the visible menu command, then look for the shortcut shown beside it. That confirms the available command in your current environment.
Frequently Asked Questions
What are the most important keyboard shortcuts for Word and Excel?
Start with Ctrl+S to save, Ctrl+Z to undo, Ctrl+C and Ctrl+V to copy and paste, and Ctrl+F to find. For Word, add Ctrl+Enter for a page break. For Excel, learn Ctrl+Arrow for data navigation and Ctrl+1 for Format Cells.
Are Word and Excel shortcuts the same?
Many basic editing shortcuts are shared, including copy, paste, save, and find. Program-specific shortcuts differ because Word works with documents and text, while Excel works with cells, ranges, and worksheets.
What is the Mac equivalent of Ctrl in Office?
For many common commands, Command replaces Ctrl, such as Command+C and Command+S. Not every shortcut follows that pattern, so check the relevant command in the Mac application, particularly for Excel navigation and function keys.
Why does Ctrl+Arrow stop before the end of my Excel data?
It moves to the edge of a continuous block, not always to the bottom of the worksheet. A blank cell can split the block, so inspect the data for gaps or use another navigation method if the range is not continuous.
Can I use these shortcuts in Excel for the web?
Many familiar shortcuts work, but browser-reserved keys and web-app differences can affect some combinations. If one does not work, check Excel for the web’s help or use the corresponding ribbon command.
Related
- How to Find a Circular Reference in Excel Step by Step
- Find a Circular Reference in Excel and Trace Its Source
- Identify Circular References in Excel: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Regression Analysis in Excel: Steps, Results, and MeaningTo run regression analysis in Excel for Microsoft 365 on Windows, enable the Analysis ToolPak if needed, then…
- Excel Timesheet: How to Add Up Hours CorrectlyTo add up timesheet hours in Excel, put each shift’s worked duration in a cell and total the…
- Excel: Copy Subtotal Rows Only Without Detail RowsYes. In Excel for Microsoft 365 on Windows, collapse the outline to level 2, select the range you…
- Excel Modify Drop-Down Lists: Steps, Tips and FixesTo modify an Excel drop-down list, select a cell that uses it, open Data > Data Validation, and…
- Excel Day Based on Date: Find the WeekdayTo show the weekday for a date in Excel, enter =TEXT(A2,"dddd") in another cell, assuming A2 contains a…
- How to Delete Subtotal Rows in Excel Without Losing DataTo remove subtotals created with Excel’s Subtotal command, click a cell in the list, choose Data > Subtotal,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.