Word and Excel Keyboard Shortcuts: Ways to Work Faster

Reaching for the mouse takes a few seconds every time. Repeated hundreds of times a day, that adds up to hours of lost time. The good news is that most of your work in Word and Excel can be handled with twenty or thirty shortcuts, and a week of regular use is enough to memorize them. In this article we have gathered the most useful ones, along with when to use them.

Shortcuts that work in both programs

The Office applications share a common shortcut foundation. Once you learn these, you will not tire mentally when switching between Word, Excel and PowerPoint.

• Ctrl+C, Ctrl+X, Ctrl+V: copy, cut, paste.
• Ctrl+Z and Ctrl+Y: undo and redo. Multiple undo is possible in both Excel and Word.
• Ctrl+S: save. Make it a habit while you work.
• Ctrl+F and Ctrl+H: find and replace. In long documents and large tables, this pair saves the most time.
• Ctrl+P: print screen and preview.
• F12: Save As window.
• Ctrl+A: select all. In Excel, a second press selects the entire sheet.

On a Turkish Q keyboard, some shortcuts that involve special characters may fall on different keys. If a shortcut does not work, the cause is usually the keyboard language setting, not the program settings.

Formatting and typing shortcuts in Word

The real value of shortcuts in Word is that you can keep the flow of your writing without taking your hands off the keyboard. Add a heading, make it bold, align it, and carry on.

• Ctrl+B, Ctrl+I, Ctrl+U: bold, italic, underline.
• Ctrl+L, Ctrl+E, Ctrl+R, Ctrl+J: align left, center, right, and justify.
• Ctrl+Alt+1, 2, 3: applies the Heading 1, 2 and 3 styles. A proper heading structure is essential for both the table of contents and the navigation pane.
• Ctrl+Shift+N: resets the selected text to the Normal style; it is a quick way to clean up broken formatting pasted from outside.
• Shift+F3: cycles the case of the selected text between uppercase, lowercase and capitalized forms.
• Ctrl+Enter: starts a new page. Use this instead of filling a page with blank lines.
• Ctrl+K: inserts a link.
• Ctrl+Shift+C and Ctrl+Shift+V: copy a format and apply it to another text.

Navigation and selection

Holding Ctrl with the arrow keys moves the cursor word by word or paragraph by paragraph. Adding Shift turns the same movement into a selection. Ctrl+Shift+Right arrow selects up to the end of the next word. Ctrl+Home takes you to the start of the document and Ctrl+End to the end. In a long report, you can jump directly to a page number with Ctrl+G.

Navigation and selection shortcuts in Excel

Scrolling through large tables with the mouse is a real waste of time in Excel. The shortcuts below take you to exactly where you want to go within seconds, even in a sheet with ten thousand rows.

• Ctrl+Arrow keys: jump to the cell where the data ends or begins.
• Ctrl+Shift+Arrow keys: select up to the same point. This is the fastest way to select a whole column from top to bottom.
• Ctrl+Space and Shift+Space: select the entire column or row.
• Ctrl+Home: returns to cell A1.
• Ctrl+Page Down and Page Up: switch between worksheets.
• F2: enters the cell so you can edit the formula.
• Alt+Enter: starts a new line within the same cell.

Formula and data shortcuts in Excel

When writing formulas, the real speed gain comes from the F4 key. If you press F4 while the cursor is on a cell reference in the formula bar, the reference cycles through absolute ($A$1), mixed (A$1, $A1) and relative forms. That is much faster than typing dollar signs by hand.

• Alt+=: inserts an automatic sum for the selected range.
• Ctrl+T: converts the range into a table, which brings filtering, sorting and automatic expansion.
• Ctrl+Shift+L: turns the filter on or off.
• Ctrl+D and Ctrl+R: fill the cell above downward, and the cell on the left to the right.
• Ctrl+; and Ctrl+Shift+;: insert today's date and the current time as fixed values.
• Ctrl+1: opens the Format Cells window.
• Ctrl+Shift+5: applies the percentage format; Ctrl+Shift+1 applies the number format.

Dynamic array functions that come with Excel 2021 and Microsoft 365 (such as XLOOKUP and FILTER) are not available in older versions. The shortcuts work in every version, but for the new functions the version you use matters.

Shortcuts that save time in long documents and large tables

In a short letter, the difference that shortcuts make is hardly noticeable. The real difference shows up when you work on a fifty-page report or a sales table with tens of thousands of rows. There, every repeated action adds up.

When writing a report in Word

• Ctrl+Alt+M: inserts a comment on the selected text; it is used a lot in internal review.
• Ctrl+Shift+E: turns track changes on or off. It is the safest way to see what has changed in a draft you send to someone else.
• Alt+Shift+Up/Down arrow: moves the selected paragraph up or down as it is; no need to cut and paste.
• F7: starts the spelling and grammar check.
• Ctrl+Shift+8: shows hidden formatting marks. It is ideal for finding stray spaces, tabs and paragraph mark problems.

When working with large data in Excel

• Ctrl+Shift+Arrow to select, then Ctrl+C: the way to copy hundreds of thousands of rows without dragging.
• Ctrl+Space, then Ctrl+Plus: inserts a new column to the left of the selected column. For rows, Shift+Space is used; Ctrl+Minus deletes.
• Alt+Down arrow: opens the filter or data validation list.
• Ctrl+Shift+V: in newer versions, opens the Paste Special options. It is often used to paste only the value instead of the formula.
• F5 or Ctrl+G: goes to a specific cell or range; the Special button here is also where you select blank cells.

What these shortcuts have in common is that they split the work into two steps: select first, then apply. When working with the mouse, people usually try to do both at the same time and end up clicking the wrong cell. With the keyboard, that risk drops considerably.

Shortcut summary table

Tips for making shortcuts stick

Trying to memorize fifty shortcuts in one sitting does not work. A more reliable method is to pick three or four a week and use only those. Whenever you notice yourself reaching for the mouse, stop and look for the shortcut for that action. A week later, add a new group.

Pressing the Alt key on its own shows letter tips for every command on the ribbon (for example, Alt, then H, then O and I to auto-fit the column width). This lets you work through commands that have no shortcut using only the keyboard. If you add frequently used commands that have no shortcut to the Quick Access Toolbar, you can run them with Alt+number.

Also check the Office version you use. Basic shortcuts are shared across versions, but the interface and new features differ. If you are on an older version, moving to a current one such as Office 2021 or Office 2024 brings both shortcut compatibility and new features. For those who want continuous updates and cloud storage, the Office 365 annual subscription is an option; for installation differences, you can also check the Office guide on our site.

Notes for teams and work environments

In offices where several people use the same files, sharing a standard shortcut sheet makes a real difference in productivity. Teaching new employees to use the Ctrl+Alt+1/2/3 heading styles in particular keeps documents consistent. If you need project planning, you will find that complementary applications such as Microsoft Project 2021 and Visio 2021 for flowcharts follow a shortcut logic similar to Office. You can reach all software options from the software licenses category; at LisansX, delivery is digital and the license information lands in your account after payment.

Frequently Asked Questions

Do the same shortcuts work on Mac?

Largely yes, but the Cmd (⌘) key is used instead of Ctrl. For example, copy becomes Cmd+C. Some Excel shortcuts (such as F2) work on Mac together with the fn key.

Why do shortcuts sometimes not work?

The most common reasons are a different keyboard language, another program reserving the same shortcut, and being in cell edit mode in Excel. Press Esc to leave the mode and try again.

Can I define my own shortcut?

In Word, you can customize keyboard shortcuts via File, Options, Customize Ribbon. In Excel, this requires assigning a macro; for most users, the Quick Access Toolbar is enough.

Do the shortcuts also work in older Office versions?

Almost all the basic shortcuts in this article work from Office 2013 onward. New features such as dynamic arrays, however, are only available in Office 2021 and Microsoft 365.