Google Sheets Windows Shortcuts

120 shortcuts · View all OS →

WindowsmacOSLinuxCompare all
Google Sheets Windows keyboard shortcuts
ActionWindows Shortcut
Navigation
Move to beginning of rowHome
Move to beginning of sheetCtrlHome
Move to end of sheetCtrlEnd
Move to next sheetCtrlPageDown
Move to previous sheetCtrlPageUp
Jump to rangeCtrlG
Go to cell A1CtrlHome
Scroll to active cellCtrlBackspace
Select all cellsCtrlACtrlShiftSpace
Show keyboard shortcutsCtrl/
Toggle compact controlsCtrlShiftF
Open tool finderAlt/
Move to end of rowEnd
Show sheet listAltShiftK
Cell link: open hyperlinkAltEnter
Go to side panelCtrlAlt.CtrlAlt,
Move focus out of spreadsheetCtrlAltShiftM
Selected range: focus quicksumAltShiftQ
Focus link or image popupCtrlAltECtrlAltP
Open filtered cell dropdownCtrlAltR
File menu in ChromeAltF
Edit menu in ChromeAltE
View menu in ChromeAltV
Insert menu in ChromeAltI
Format menu in ChromeAltO
Data menu in ChromeAltD
Tools menu in ChromeAltT
Form menu in Chrome with linked formAltM
Add-ons menu in ChromeAltN
Help menu in ChromeAltH
Accessibility menu in Chrome with screen readerAltA
Enable screen reader supportCtrlAltZ
Enable braille supportCtrlAltH
Screen reader: read columnCtrlAltShiftC
Screen reader: read rowCtrlAltShiftR
Editing
Edit active cellF2
UndoCtrlZ
RedoCtrlY
CutCtrlX
CopyCtrlC
PasteCtrlV
Paste values onlyCtrlShiftV
Fill downCtrlD
Fill rightCtrlR
Insert new line in cellAltEnter
Delete cell contentsDelete
Find and replaceCtrlH
FindCtrlF
Fill selected rangeCtrlEnter
Save spreadsheetCtrlS
Open spreadsheetCtrlO
Print spreadsheetCtrlP
Toggle input tools for non-Latin textCtrlShiftK
Choose input toolsCtrlAltShiftK
Insert cell linkCtrlK
Open version historyCtrlAltShiftH
Close drawing editorShiftEsc
Insert or edit cell noteShiftF2
Open comment threadCtrlAltShiftA
Enter current commentCtrlAltECtrlAltC
Next commentCtrlAltNCtrlAltC
Previous commentCtrlAltPCtrlAltC
Selected comment: replyR
Selected comment: nextJ
Selected comment: previousK
Selected comment: resolveE
Selected comment: exitU
Selected cells: delete menuCtrlAlt-
Open context menuCtrlShift\ShiftF10
Formatting
BoldCtrlB
ItalicCtrlI
UnderlineCtrlU
StrikethroughAltShift5
Format as currencyCtrlShift4
Format as percentageCtrlShift5
Format as dateCtrlShift3
Align leftCtrlShiftL
Align centerCtrlShiftE
Align rightCtrlShiftR
Clear formattingCtrl\
Apply top cell borderAltShift1
Apply right cell borderAltShift2
Apply bottom cell borderAltShift3
Apply left cell borderAltShift4
Remove cell bordersAltShift6
Apply outer cell borderAltShift7CtrlShift7
Format as decimalCtrlShift1
Format as timeCtrlShift2
Format as exponentCtrlShift6
Rows & Columns
Insert row aboveCtrlAltShift=
Insert column leftCtrlAlt=
Delete rowCtrlAlt-
Select entire rowShiftSpace
Select entire columnCtrlSpace
Hide rowCtrlAlt9
Hide columnCtrlAlt0
Group rows/columnsAltShiftRight
Insert new sheetShiftF11
Rename sheetAlt1
Convert range to tableCtrlAltT
Open sheet actions menuAltShiftS
Open table column menuCtrlAlt\
Unhide rowCtrlShift9
Unhide columnCtrlShift0
Ungroup rows or columnsAltShift←
Expand grouped rows or columnsAltShift↓
Collapse grouped rows or columnsAltShift↑
Formulas
Show all formulasCtrl`
Insert current dateCtrl;
Insert current timeCtrlShift;
Toggle absolute/relative referenceF4
Sum selected cellsAlt=
Insert commentCtrlAltM
Insert array formulaCtrlShiftEnter
Collapse expanded array formulaCtrlE
Formula entry: toggle helpShiftF1
Formula entry: full or compact helpF1
Formula entry: toggle result previewF9
Resize formula barCtrl↑Ctrl↓
Formula entry: toggle range selectionF2CtrlE