Excel with Prajakta

Complete List of Google Sheets Shortcuts (Windows & Mac)

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

ActionWindows / Chrome OSMac
Select entire rowShift + SpaceShift + Space
Select entire columnCtrl + Space⌘ + Space
Select allCtrl + A⌘ + A
Jump to beginning of rowHomeHome
Jump to end of rowEndEnd
Jump to beginning of sheetCtrl + Home⌘ + Home
Jump to end of sheetCtrl + End⌘ + End
Switch to next sheetAlt + ↓Option + ↓
Switch to previous sheetAlt + ↑Option + ↑
Show sheet listAlt + Shift + KOption + Shift + K

Editing & Data Entry

ActionWindows / Chrome OSMac
CopyCtrl + C⌘ + C
CutCtrl + X⌘ + X
PasteCtrl + V⌘ + V
Paste values onlyCtrl + Shift + V⌘ + Shift + V
Fill downCtrl + DCtrl + D
Fill rightCtrl + RCtrl + R
UndoCtrl + Z⌘ + Z
RedoCtrl + Y / Ctrl + Shift + Z⌘ + Y / ⌘ + Shift + Z
Insert current dateCtrl + ;⌘ + ;
Insert current timeCtrl + Shift + ;⌘ + Shift + ;
Insert date & timeCtrl + Alt + Shift + ;⌘ + Option + Shift + ;

Formatting

ActionWindows / Chrome OSMac
BoldCtrl + B⌘ + B
ItalicCtrl + I⌘ + I
UnderlineCtrl + U⌘ + U
StrikethroughAlt + Shift + 5Option + Shift + 5
Align leftCtrl + Shift + L⌘ + Shift + L
Align centerCtrl + Shift + E⌘ + Shift + E
Align rightCtrl + Shift + R⌘ + Shift + R
Format as decimalCtrl + Shift + 1Ctrl + Shift + 1
Format as timeCtrl + Shift + 2Ctrl + Shift + 2
Format as dateCtrl + Shift + 3Ctrl + Shift + 3
Format as currencyCtrl + Shift + 4Ctrl + Shift + 4
Format as percentageCtrl + Shift + 5Ctrl + Shift + 5
Format as scientificCtrl + Shift + 6Ctrl + Shift + 6
Clear formattingCtrl + \⌘ + \

Sheets, Filters & Views

ActionWindows / Chrome OSMac
Insert new sheetShift + F11Fn + Shift + F11
Apply / remove filterCtrl + Shift + L⌘ + Shift + F
Show formulas instead of resultsCtrl + ` (backtick)⌘ + `
Open sheet listAlt + Shift + KOption + Shift + K
Open version historyCtrl + Alt + Shift + H⌘ + Option + Shift + H

Leave a Comment

Scroll to Top