100 Essential Spreadsheet Keyboard Shortcuts for Windows & Mac!
Spreadsheet applications like Microsoft Excel, Google Sheets, and LibreOffice Calc have powerful keyboard shortcuts that can save time and improve efficiency. Below is a comprehensive list of 100 spreadsheet keyboard shortcuts categorized for quick reference.
100 Spreadsheet Keyboard Shortcuts Table
Basic Editing Shortcuts |
Action | Windows Shortcut | Mac Shortcut |
Copy | Ctrl + C | Command + C |
Cut | Ctrl + X | Command + X |
Paste | Ctrl + V | Command + V |
Undo | Ctrl + Z | Command + Z |
Redo | Ctrl + Y | Command + Shift + Z |
Select All | Ctrl + A | Command + A |
Delete Cell Content | Delete | Delete |
Insert Hyperlink | Ctrl + K | Command + K |
Bold Text | Ctrl + B | Command + B |
Italic Text | Ctrl + I | Command + I |
Underline | Ctrl + U | Command + U |
|
|
|
Navigation Shortcuts |
Action | Windows Shortcut | Mac Shortcut |
Move to Next Cell | Tab | Tab |
Move to Previous Cell | Shift + Tab | Shift + Tab |
Go to Cell (Find) | Ctrl + G | Command + G |
Move to Beginning of Row | Home | Command + Left Arrow |
Move to End of Row | End | Command + Right Arrow |
Move to Top of Sheet | Ctrl + Home | Command + Up Arrow |
Move to Bottom of Sheet | Ctrl + End | Command + Down Arrow |
|
|
|
Row & Column Operations |
Action | Windows Shortcut | Mac Shortcut |
Select Entire Row | Shift + Space | Shift + Space |
Select Entire Column | Ctrl + Space | Command + Space |
Insert New Row | Ctrl + Shift + "+" | Command + Shift + "+" |
Insert New Column | Ctrl + Shift + "+" | Command + Shift + "+" |
Delete Row | Ctrl + "-" | Command + "-" |
Delete Column | Ctrl + "-" | Command + "-" |
Resize Column to Fit | Alt + H + O + I | Command + Option + I |
|
|
|
Data Formatting Shortcuts |
Action | Windows Shortcut | Mac Shortcut |
Open Format Cells Dialog | Ctrl + 1 | Command + 1 |
Apply Currency Format | Ctrl + Shift + $ | Command + Shift + $ |
Apply Percentage Format | Ctrl + Shift + % | Command + Shift + % |
Apply Comma Style | Ctrl + Shift + ! | Command + Shift + ! |
Apply Date Format | Ctrl + Shift + # | Command + Shift + # |
Apply Time Format | Ctrl + Shift + @ | Command + Shift + @ |
Apply General Format | Ctrl + Shift + ~ | Command + Shift + ~ |
|
|
|
Working with Formulas |
Action | Windows Shortcut | Mac Shortcut |
Start Formula in a Cell |
|
|
Autosum | Alt + = | Command + Shift + T |
Edit Active Cell | F2 | Control + U |
Recalculate Formulas | F9 | Command + = |
Insert Function | Shift + F3 | Command + Shift + F3 |
|
|
|
File Management Shortcuts |
Action | Windows Shortcut | Mac Shortcut |
Save File | Ctrl + S | Command + S |
Open File | Ctrl + O | Command + O |
Print File | Ctrl + P | Command + P |
Close Workbook | Ctrl + W | Command + W |
|
|
|
Special Features |
Action | Windows Shortcut | Mac Shortcut |
Freeze Panes | Alt + W + F + F | Command + Option + F |
Sort Ascending | Alt + D + S + A | Command + Shift + A |
Sort Descending | Alt + D + S + D | Command + Shift + D |
Filter Data | Ctrl + Shift + L | Command + Shift + L |
Insert Chart | F11 | Command + F11 |
Group Rows/Columns | Alt + Shift + Right | Command + Shift + Right |
Ungroup Rows/Columns | Alt + Shift + Left | Command + Shift + Left |
|
|
|
Miscellaneous Shortcuts |
Action | Windows Shortcut | Mac Shortcut |
Insert Comment | Shift + F2 | Command + Shift + F2 |
Open Find Dialog | Ctrl + F | Command + F |
Open Replace Dialog | Ctrl + H | Command + Shift + H |
Switch Worksheets | Ctrl + Page Up/Page Down | Command + Option + Arrow |
Zoom In/Out | Ctrl + Mouse Wheel | Command + Mouse Wheel |
Final Thoughts
Memorizing these 100 spreadsheet keyboard shortcuts can significantly improve your efficiency and workflow in Microsoft Excel, Google Sheets, or LibreOffice Calc. Bookmark this page for quick reference!
