Top Shortcut Keys for Word and Excel

 Here are the absolute best shortcuts for Microsoft Word and Excel that you should start using today.


The "Universal Six" (Work in Both)


Ctrl + Z

Undo last action


Ctrl + Y

Redo last action


Ctrl + F

Find text


Ctrl + H

Find and Replace

.

Ctrl + K

Insert a hyperlink


Ctrl + P

Print preview 



Shortcuts for Microsoft Word

  • Ctrl + A : Select All Text
  • Ctrl + B : Bolds selected Texts
  • Ctrl + I : Italic Font
  • Ctrl + U : Underlines Text
  • Ctrl + C : Copy Selected Text
  • Ctrl + V : Paste Copied Text
  • Ctrl + ] : Increase font size
  • Ctrl + [ : Decrease font size
  • Ctrl + L : Aligns Text at left
  • Ctrl + R : Aligns Text at right
  • Ctrl + E : Aligns Text at center
  • Ctrl + J : Justify the alignment
  • Ctrl+O : Open a document.
  • Ctrl+S : Save the document
  • Ctrl + N :Create a new document.
  • Ctrl + Backspace: Deletes an entire word at a time instead of one single letter.
  • Ctrl + 1 / Ctrl + 2: Changes line spacing to single or double spacing instantly. 
  • Shift + F3: Toggles text case.
  • Ctrl + Enter: Inserts a clean Page Break. 
  • Shift+Enter : Insert a line break.
  • Ctrl+Shift+Enter : Insert a column break.
  • Ctrl+Alt+T : Insert a trademark symbol (™).
  • Press (, C, ) : Insert a copyright symbol (©).
  • Alt + = : Opens equation editor.
  • Windows Key + V : Open clipboard
  • Windows Key + . : Open emoji panel 


Shortcuts for Microsoft Excel

  • Ctrl + Space: Select the entire column
  • Shift + Space: Select the entire row
  • Ctrl + A: Select the entire sheet or data region
  • Alt + = : AutoSum selected cells
  • Ctrl + ; : Insert the current date
  • Ctrl + Shift + ; : Insert the current time
  • Ctrl + 1: Open the Format Cells dialog box
  • Ctrl + T: Convert data into a formatted Table
  • Ctrl + Enter: Fill the selected cell range with the current entry
  • Alt + Enter: Start a new line inside a cell
  • Ctrl+O : Open a workbook.
  • Ctrl+S : Save a workbook.
  • Ctrl+C : Copy selection.
  • Ctrl+V : Paste selection
  • Ctrl + Arrow Keys: Go to first or last cell
  • Ctrl + Shift + Arrow Keys: Selects every cell between your current position
  • Ctrl + Shift + 1: Instantly formats a number as a standard currency / decimal format ($#,##0.00).




Post a Comment

Previous Post Next Post