keyboard shortcuts for Word and Excel

83 keyboard shortcuts for Word and Excel

Reading Time: 4 minutes

Here you will find 83 keyboard shortcuts for Word and Excel. If you are working regularly in Microsoft Word or Microsoft Excel, learning some of these shortcuts are guaranteed to make your work easier.

 

Keyboard shortcuts for Word and Excel

The below keyboard shortcuts for Word and Excel are for the Windows versions.

Picture: Microsoft.

 

This article covers keyboard shortcuts for Word and Excel only. For general shortcuts, take a look at the below blog post.

time-saving keyboard shortcuts

55 time-saving keyboard shortcuts for PC that will boost your productivity

Here are 55 time-saving keyboard shortcuts that work in Windows and most programs. With these, you can work faster, be more precise, and avoid health issues.
Read More

 

Keyboard shortcuts for Word

Basics

  • CTRL + N: Create a new document of the same type as the current or most recent document
  • CTRL + O: Open a document
  • CTRL + W: Close a document
  • CTRL + S: Save a document

Views

  • ALT + CTRL+P: Switch to print layout view
  • ALT + CTRL+O: Switch to outline view
  • ALT + CTRL+N:  Switch to normal view

Actions

  • ESC: Cancel an action
  • CTRL + Z: Undo an action
  • CTRL + Y: Redo or repeat an action

Searching and replacing

  • CTRL + F: Find text, formatting, and special items
  • ALT + CTRL + Y: Repeat find (after closing Find and Replace window)
  • CTRL + H: Replace text, specific formatting, and special items

Formatting

  • CTRL + SHIFT + C: Copy formatting from text
  • CTRL + SHIFT + V: Apply copied formatting to text
  • CTRL + SHIFT + F: Change the font
  • CTRL + SHIFT + P: Change the font size
  • CTRL + SHIFT + >: Increase the font size
  • CTRL + SHIFT + <: Decrease the font size
  • CTRL + ]: Increase the font size by 1 point
  • CTRL + [: Decrease the font size by 1 point
  • SHIFT + F3: Change the case of letters
  • CTRL+SHIFT+K Format letters as small capitals
  • CTRL + SHIFT + A: Format letters as all capitals
  • CTRL + B: Apply bold formatting
  • CTRL + I: Apply italic formatting
  • CTRL + U: Apply an underline
  • CTRL + SHIFT + W: Underline words but not spaces
  • CTRL + SHIFT + D: Double-underline text
  • CTRL+EQUAL SIGN: Apply subscript formatting (automatic spacing)
  • CTRL+SHIFT+PLUS SIGN: Apply superscript formatting (automatic spacing)
  • CTRL + SHIFT + H: Apply hidden text formatting
  • CTRL+SPACEBAR: Remove manual character formatting
  • CTRL+SHIFT+Q: Change the selection to the Symbol font
  • CTRL+SHIFT+C: Copy formats
  • CTRL+SHIFT+V: Paste formats

Line spacing

  • CTRL+1: Single-space lines
  • CTRL+2: Double-space lines
  • CTRL+5: Set 1.5-line spacing
  • CTRL+0: (zero) Add or remove one line space preceding a paragraph

Document window

  • ALT + CTRL + S: Split the document window
  • ALT + SHIFT + C: Remove the document window split

Navigation

  • CTRL + G: Go to a page, bookmark, footnote, table, comment, graphic, or other location
  • ALT + CTRL + Z: Go back to a page, bookmark, footnote, table, comment, graphic, or other location
  • ALT+CTRL+HOME Browse through a document
keyboard shortcuts for Word and Excel
Picture: Microsoft.

 

Keyboard shortcuts for Excel

Some useful keyboard shortcuts in Microsoft Excel.

Basics

  • CTRL + N: Creates a new, blank file.
  • CTRL + O: Displays the Open dialog box to open or find a file.
  • CTRL + P: Displays the Print dialog box.
  • CTRL + S: Saves the active file with its current file name, location, and file format.
  • CTRL + W: Closes the selected workbook window.

Hiding

  • CTRL + (: Unhides any hidden rows within the selection.
  • CTRL + ): Unhides any hidden columns within the selection.

Borders

  • CTRL + &: Applies the outline border to the selected cells.
  • CTRL + _: Removes the outline border from the selected cells.

Formats

  • CTRL + $: Applies the Currency format with two decimal places (negative numbers in parentheses).
  • CTRL + %: Applies the Percentage format with no decimal places.

Formulas

  • CTRL + ‘: Copies a formula from the cell above the active cell into the cell or the Formula Bar.
  • CTRL + “: Copies the value from the cell above the active cell into the cell or the Formula Bar.

Formatting

  • CTRL + 1: Displays the Format Cells dialog box.
  • CTRL + 2: Applies or removes bold formatting.
  • CTRL + 3: Applies or removes italic formatting.
  • CTRL + 4: Applies or removes underlining.
  • CTRL + 5: Applies or removes strikethrough.
  • CTRL + B: Applies or removes bold formatting.
  • CTRL + I: Applies or removes italic formatting.
  • CTRL + U: Applies or removes underlining.

Show

  • CTRL + 6: Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
  • CTRL + 7: Displays or hides the Standard toolbar.
  • CTRL + 8: Displays or hides the outline symbols.
  • CTRL + 9: Hides the selected rows.
  • CTRL + 0: Hides the selected columns.

Find and replace

  • CTRL + F: Displays the Find dialog box.
  • SHIFT + F5: also displays this dialog box, while SHIFT+F4 repeats the last Find action.
  • CTRL + G: Displays the Go To dialog box.
  • F5: also displays the Go To dialog box.
  • CTRL + H: Displays the Find and Replace dialog box.

Other

  • F2: Edit cell
  • CTRL + +: Displays the Insert dialog box to insert blank cells.
  • CTRL + -: Displays the Delete dialog box to delete the selected cells.
  • CTRL + D: Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
  • CTRL + R: Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
  • CTRL + K: Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
  • CTRL + L: Displays the Create List dialog box.
Picture: Microsoft.

Have you seen my FOCUS page for keyboard shortcuts?

 

 

 

 

LIKE THIS POST?

Say something