- Save as = F12
- Save = Ctrl + S
- Print = Ctrl + P
- Close Excel = Alt + F4
- New workbook = Ctrl + N
- Open workbook = Ctrl + O
- Close current window = Ctrl + W
8 Format Shortcuts:
- Bold = Ctrl + B
- Italics = Ctrl + I
- Underline = Ctrl + U
- Strikethrough = Ctrl + 5
- Date format = Ctrl + Shift + #
- Number format = Ctrl + Shift + !
- Percentage format = Ctrl + Shift + %
- Currency format = Ctrl + Shift + $
6 Navigation Shortcuts:
- Start of row = Home
- Start of worksheet = Ctrl + Home
- Prior sheet in workbook = Ctrl + Page Up
- Next sheet in workbook = Ctrl + Page Down
- Up or down to data edge = Ctrl + Up or Down Arrow
- Left or right to data edge = Ctrl + Left or Right arrow
6 Copy, paste and paste special Shortcuts:
- Copy = Ctrl + C
- Paste = Ctrl + V
- Paste value = Alt, H, V, V
- Paste format = Alt, H, V, R
- Paste formula = Alt, H, V, F
- Paste source + format = Alt, H, V, E
4 Insert and Delete Shortcuts:
- Select Row = Shift + Space Bar
- Select Column = Ctrl + Space Bar
- Delete Row or Column = Ctrl + -
- Insert Row or Column = Ctrl + Shift + +
5 Adjust, group and ungroup row and column Shortcuts:
- Remove groups = Alt, A, U, C
- Autofit row height = Alt, H, OA
- Autofit column width = Alt, H, O, I
- Group row or column = Shift + Alt + Right arrow
- Ungroup row or column = Shift + Alt + Left arrow
7 Formula Shortcuts:
- Edit formula = F2
- Autosum = Alt + =
- Toggle cell format = Ctrl + `
- Open insert function = Shift + F3
- Paste a formula as values = F2, F9
- Show formula bar = Ctrl + Shift + U
- Copy formula from cell above = Ctrl + '
7 Bonus Shortcuts:
- Redo = Ctrl + Y
- Undo = Ctrl + Z
- Zoom in = Ctrl + Alt + =
- Zoom out = Ctrl + Alt + -
- Insert current date = Ctrl + ;
- Insert current time = Ctrl + Shift + ;
- Add row of text in a cell = Alt + Enter
Now, Go Quiet and Start Building Yourself.
Keep Learning at LTY (Learn That Yourself).