Keyboard Shortcuts Flashcards
Expand or Collapse Ribbon
Ctrl + F1
Go to Search Bar
Alt + Q
Open File Menu
Alt + F
Go to Home Tab
Alt + H
Go to Insert Tab
Alt + N
Go to Page Layout Tab
Alt + P
Go to Formula Tab
Alt + M
Go to Data Tab
Alt + A
Go to Review Tab
Alt + R
Go to View Tab
Alt + W
Go to Help Tab
Alt + Y1
Open “Format Cells” Dialog Box
Ctrl + 1
Apply/Unapply Bold
Ctrl + B
Apply/Unapply Italics
Ctrl + I
Apply/Unapply Underline
Ctrl + U
Apply/Unapply Strikethrough
Ctrl + 5
Apply Currency Format
Ctrl + Shift + $
Apply Percentage Format
Ctrl + Shift + %
Apply Date Format
Ctrl + Shift + #
Apply Time Format
Ctrl + Shift + @
Apply Number Format
Ctrl + Shift + !
Apply General Format
Ctrl + Shift + ~
Center Align Cell Contents
Alt + H + A + C
Left Align Cell Contents
Alt + H + A + L
Right Align Cell Contents
Alt + H + A + R
Autosum All Selected Cells
Alt + =
Add Function Arguments
Ctrl + Shift + A
Toggle Formula Bar
Ctrl + Shift + :
Toggle Cell Formulas and Values
Ctrl + `
Copy Selected Cells
Ctrl + C
Paste Clipboard Contents
Ctrl + V
Display “Paste Special”
Ctrl + Alt + V
Cut Selection
Ctrl + X
Undo Previous Action
Ctrl + Z
Redo Previous Action
Ctrl + Y
Display Find Dialog
Ctrl + F
Display Replace Dialog
Ctrl + H