If you use Google Sheets daily, keyboard shortcuts are the fastest way to save time. Instead of digging through menus, a few keystrokes can copy, paste, filter, or format your data instantly.
Navigation Shortcuts
Action | Windows / Chrome OS | Mac |
Select entire row | Shift + Space | Shift + Space |
Select entire column | Ctrl + Space | ⌘ + Space |
Select all | Ctrl + A | ⌘ + A |
Jump to beginning of row | Home | Home |
Jump to end of row | End | End |
Jump to beginning of sheet | Ctrl + Home | ⌘ + Home |
Jump to end of sheet | Ctrl + End | ⌘ + End |
Switch to next sheet | Alt + ↓ | Option + ↓ |
Switch to previous sheet | Alt + ↑ | Option + ↑ |
Show sheet list | Alt + Shift + K | Option + Shift + K |
Editing & Data Entry
Action | Windows / Chrome OS | Mac |
Copy | Ctrl + C | ⌘ + C |
Cut | Ctrl + X | ⌘ + X |
Paste | Ctrl + V | ⌘ + V |
Paste values only | Ctrl + Shift + V | ⌘ + Shift + V |
Fill down | Ctrl + D | Ctrl + D |
Fill right | Ctrl + R | Ctrl + R |
Undo | Ctrl + Z | ⌘ + Z |
Redo | Ctrl + Y / Ctrl + Shift + Z | ⌘ + Y / ⌘ + Shift + Z |
Insert current date | Ctrl + ; | ⌘ + ; |
Insert current time | Ctrl + Shift + ; | ⌘ + Shift + ; |
Insert date & time | Ctrl + Alt + Shift + ; | ⌘ + Option + Shift + ; |
Formatting
Action | Windows / Chrome OS | Mac |
Bold | Ctrl + B | ⌘ + B |
Italic | Ctrl + I | ⌘ + I |
Underline | Ctrl + U | ⌘ + U |
Strikethrough | Alt + Shift + 5 | Option + Shift + 5 |
Align left | Ctrl + Shift + L | ⌘ + Shift + L |
Align center | Ctrl + Shift + E | ⌘ + Shift + E |
Align right | Ctrl + Shift + R | ⌘ + Shift + R |
Format as decimal | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
Format as time | Ctrl + Shift + 2 | Ctrl + Shift + 2 |
Format as date | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
Format as currency | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
Format as percentage | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
Format as scientific | Ctrl + Shift + 6 | Ctrl + Shift + 6 |
Clear formatting | Ctrl + \ | ⌘ + \ |
Sheets, Filters & Views
Action | Windows / Chrome OS | Mac |
Insert new sheet | Shift + F11 | Fn + Shift + F11 |
Apply / remove filter | Ctrl + Shift + L | ⌘ + Shift + F |
Show formulas instead of results | Ctrl + ` (backtick) | ⌘ + ` |
Open sheet list | Alt + Shift + K | Option + Shift + K |
Open version history | Ctrl + Alt + Shift + H | ⌘ + Option + Shift + H |