I made a quick overview of the most essential microsoft excel keyboard shortcuts. It is part of my series of productivity enhancement keyboard shortcuts for productivity software. They work on both windows and mac.
Excel keyboard shortcuts pdf
Click download pdf version to print.
General Shortcuts:
New Workbook: Ctrl/⌘ + N
Open Workbook: Ctrl/⌘ + O
Save Workbook: Ctrl/⌘ + S
Save As: F12 / Cmd + Shift + S
Print: Ctrl/⌘ + P
Close Workbook: Ctrl/⌘ + W
Undo: Ctrl/⌘ + Z
Redo: Ctrl + Y / Cmd + Shift + Z
Cut: Ctrl/⌘ + X
Copy: Ctrl/⌘ + C
Paste: Ctrl/⌘ + V
Select All: Ctrl/⌘ + A
Find: Ctrl/⌘ + F
Replace: Ctrl/⌘ + H
Navigation:
Move to Next Cell: Arrow Keys
Move to the Last Cell in Data Region: Ctrl + Arrow Keys / Cmd + Arrow Keys
Go to First Cell (A1): Ctrl + Home / Cmd + Home
Go to Last Cell with Data: Ctrl + End / Cmd + End
Move Between Worksheets: Ctrl + Page Up/Page Down / Option + Up/Down Arrow
Move to Next Worksheet: Ctrl + Shift + Page Down / Cmd + Shift + Down Arrow
Move to Previous Worksheet: Ctrl + Shift + Page Up / Cmd + Shift + Up Arrow
Selection Shortcuts:
Select Entire Worksheet: Ctrl/⌘ + A
Select Row: Shift + Space
Select Column: Ctrl + Space / Cmd + Space
Select to the End of Data: Ctrl + Shift + Arrow Keys / Cmd + Shift + Arrow Keys
Select a Range: Shift + Arrow Keys
Select Non-Adjacent Cells: Ctrl + Click / Cmd + Click
Editing:
Edit Active Cell: F2 / Ctrl + U
Fill Down: Ctrl + D / Cmd + D
Fill Right: Ctrl + R / Cmd + R
Insert Row: Ctrl + Shift + “+” / Cmd + Shift + “+”
Delete Row: Ctrl + “-” / Cmd + “-”
Insert Comment: Shift + F2 / Cmd + Shift + A
Formatting Shortcuts:
Bold: Ctrl/⌘ + B
Italic: Ctrl/⌘ + I
Underline: Ctrl/⌘ + U
Open Format Cells Dialog: Ctrl + 1 / Cmd + 1
Increase Font Size: Ctrl/⌘ + Shift + >
Decrease Font Size: Ctrl/⌘ + Shift + <
Center Align: Ctrl/⌘ + E
Left Align: Ctrl/⌘ + L
Right Align: Ctrl/⌘ + R
Add Border: Ctrl + Shift + & / Cmd + Option + 0
Formulas:
Start a Formula: Equals (=)
AutoSum: Alt + = / Cmd + Shift + T
Show Formulas: Ctrl + / Cmd +
Insert Function: Shift + F3 / Cmd + Shift + A
Absolute References (Toggle $): F4 / Cmd + T
Calculate Workbook: F9 / Cmd + =
Data Handling:
Apply Filter: Ctrl + Shift + L / Cmd + Shift + F
Remove Filter: Ctrl + Shift + L / Cmd + Shift + F
Sort Ascending: Alt + A + S + A / Cmd + Shift + A
Sort Descending: Alt + A + S + D / Cmd + Shift + D
Insert Table: Ctrl + T / Cmd + T
Viewing and Reviewing:
Zoom In: Ctrl + Plus (+) / Cmd + Option + Plus (+)
Zoom Out: Ctrl + Minus (-) / Cmd + Option + Minus (-)
Freeze Panes: Alt + W + F + F / Cmd + Shift + U
Switch to Full-Screen View: Ctrl + F1 / Cmd + Option + R
Mini review Logitech MX Keys S Wireless Keyboard the best keyboard I ever owned here.
Comments