Google Sheets keyboard shortcuts

Google Sheets shortcuts cover selection, cell entry, formatting, sheet navigation, comments, menus, formulas, and accessibility. This reference keeps Google's PC bindings for Windows and Linux separate from its current Mac bindings.

Windows, macOS, Linux · 110 shortcuts

Common actions

Select, edit, save, print, copy, paste, and find in the grid with the bindings Google documents for PC, Mac, and Linux browsers.

ActionWindowsmacOSLinux
Select the current columnCtrlSpaceCtrlSpaceCtrlSpace
Select the current rowShiftSpaceShiftSpaceShiftSpace
Select allCtrl+Shift+Space on PC and Cmd+Shift+Space on Mac are also documented.CtrlACmdACtrlA
UndoCtrlZCmdZCtrlZ
RedoCtrl+Shift+Z, Cmd+Shift+Z, and F4 on PC or Fn+F4 on Mac are also documented.CtrlYCmdYCtrlY
FindCtrlFCmdFCtrlF
Find and replaceCtrlHCmdShiftHCtrlH
Fill the selected rangeCtrlEnterCmdEnterCtrlEnter
Fill downCtrlDCmdDCtrlD
Fill rightCtrlRCmdRCtrlR
Save changesSheets saves changes automatically in Drive.CtrlSCmdSCtrlS
OpenCtrlOCmdOCtrlO
PrintCtrlPCmdPCtrlP
CopyCtrlCCmdCCtrlC
CutCtrlXCmdXCtrlX
PasteCtrlVCmdVCtrlV
Paste values onlyCtrlShiftVCmdShiftVCtrlShiftV
Show keyboard shortcutsCtrl/Cmd/Ctrl/
Insert a new sheetShiftF11ShiftFnF11ShiftF11
Show or hide compact controlsCtrlShiftFCtrlShiftFCtrlShiftF
Open Tool finderAlt/Option/Alt/
Rename the current sheetAlt1Not documentedAlt1
Convert a range to a tableCtrlAltTCmdOptionTCtrlAltT

Format cells

Format text, alignment, borders, dates, numbers, and links without opening the toolbar menus.

ActionWindowsmacOSLinux
BoldCtrlBCmdBCtrlB
UnderlineCtrlUCmdUCtrlU
ItalicCtrlICmdICtrlI
StrikethroughAltShift5CmdShiftXAltShift5
Center alignCtrlShiftECmdShiftECtrlShiftE
Left alignCtrlShiftLCmdShiftLCtrlShiftL
Right alignCtrlShiftRCmdShiftRCtrlShiftR
Apply a top borderAltShift1OptionShift1AltShift1
Apply a right borderAltShift2OptionShift2AltShift2
Apply a bottom borderAltShift3OptionShift3AltShift3
Apply a left borderAltShift4OptionShift4AltShift4
Remove bordersAltShift6OptionShift6AltShift6
Apply an outer borderCtrl+Shift+7 and Cmd+Shift+7 are also documented.AltShift7OptionShift7AltShift7
Insert the current timeCtrlShift;CmdShift;CtrlShift;
Insert the current dateCtrl;Cmd;Ctrl;
Insert the current date and timeCtrlAltShift;CmdOptionShift;CtrlAltShift;
Format as decimalCtrlShift1CtrlShift1CtrlShift1
Format as timeCtrlShift2CtrlShift2CtrlShift2
Format as dateCtrlShift3CtrlShift3CtrlShift3
Format as currencyCtrlShift4CtrlShift4CtrlShift4
Format as percentageCtrlShift5CtrlShift5CtrlShift5
Format as exponentCtrlShift6CtrlShift6CtrlShift6
Clear formattingCtrl\Cmd\Ctrl\

Move to the edge of data, switch sheets, open links, reach the side panel, and return the viewport to the active cell.

ActionWindowsmacOSLinux
Move to the beginning of the rowHomeFnLeftHome
Move to the beginning of the sheetCtrlHomeCmdFnLeftCtrlHome
Move to the end of the rowEndFnRightEnd
Move to the end of the sheetCtrlEndCmdFnRightCtrlEnd
Scroll to the active cellCtrlBackspaceCmdBackspaceCtrlBackspace
Move to the next sheetOption+Right is also documented for MacBook keyboards.AltDownOptionDownAltDown
Move to the previous sheetOption+Left is also documented for MacBook keyboards.AltUpOptionUpAltUp
Display the list of sheetsAltShiftKOptionShiftKAltShiftK
Open ExploreCtrlAltShiftICmdOptionShiftICtrlAltShiftI
Move to the side panelThe comma variant is also documented.CtrlAlt.CmdOption.CtrlAlt.
Move focus out of the spreadsheetCtrlAltShiftMCtrlCmdShiftMCtrlAltShiftM
Move to Quick SumAltShiftQOptionShiftQAltShiftQ
Open the drop-down menu on a filtered cellCtrlAltRCtrlCmdRCtrlAltR
Open revision historyCtrlAltShiftHCmdOptionShiftHCtrlAltShiftH
Close the drawing editorShiftEscCmdEscShiftEsc

Notes and comments

Insert notes, open comment threads, and move through comments with the keyboard when reviewing a shared sheet.

ActionWindowsmacOSLinux
Insert or edit a noteShiftF2ShiftF2ShiftF2
Insert or edit a commentCtrlAltMCmdOptionMCtrlAltM
Open a comment discussion threadCtrlAltShiftACmdOptionShiftACtrlAltShiftA
Enter the current commentCtrlAltECCtrlCmdECCtrlAltEC
Move to the next commentCtrlAltNCCtrlCmdNCCtrlAltNC
Move to the previous commentCtrlAltPCCtrlCmdPCCtrlAltPC
Reply to a selected commentRRR
Resolve a selected commentEEE
Exit the selected commentUUU

Open menus and insert, delete, hide, group, or ungroup rows and columns using Google's documented menu sequences.

ActionWindowsmacOSLinux
Open the File menuAltFCtrlOptionFAltShiftF
Open the Edit menuAltECtrlOptionEAltShiftE
Open the View menuAltVCtrlOptionVAltShiftV
Open the Insert menuAltICtrlOptionIAltShiftI
Open the Format menuAltOCtrlOptionOAltShiftO
Open the Data menuAltDCtrlOptionDAltShiftD
Open the Tools menuAltTCtrlOptionTAltShiftT
Open the Sheet menuAltShiftSOptionShiftSAltShiftS
Open the context menuShift+F10 is also documented.CtrlShift\CmdShift\CtrlShift\
Open the insert menu for selected cellsCtrlAlt=CmdOption=CtrlAlt=
Open the delete menu for selected cellsCtrlAlt-CmdOption-CtrlAlt-
Insert rows aboveWith rows selected, Chrome also supports Alt+I, R, R; other browsers use Alt+Shift+I, R, R.CtrlAlt=CmdOption=CtrlAlt=
Insert rows belowAltIRBCtrlOptionIRBAltShiftIRB
Insert columns to the leftCtrlAlt=CmdOption=CtrlAlt=
Insert columns to the rightAltICOCtrlOptionICOAltShiftICO
Delete selected rowsCtrlAlt-CmdOption-CtrlAlt-
Delete selected columnsCtrlAlt-CmdOption-CtrlAlt-
Hide the selected rowCtrlAlt9CmdOption9CtrlAlt9
Unhide the selected rowCtrlShift9CmdShift9CtrlShift9
Hide the selected columnCtrlAlt0CmdOption0CtrlAlt0
Unhide the selected columnCtrlShift0CmdShift0CtrlShift0
Group rows or columnsAltShiftRightOptionShiftRightAltShiftRight
Ungroup rows or columnsAltShiftLeftOptionShiftLeftAltShiftLeft
Expand grouped rows or columnsAltShiftDownOptionShiftDownAltShiftDown
Collapse grouped rows or columnsAltShiftUpOptionShiftUpAltShiftUp

Formulas and accessibility

Show formulas, enter arrays, control formula help, and enable the screen-reader and braille features documented by Google.

ActionWindowsmacOSLinux
Show all formulasCtrl~Ctrl~Ctrl~
Insert an array formulaCtrlShiftEnterCmdShiftEnterCtrlShiftEnter
Collapse an expanded array formulaCtrlECmdECtrlE
Show or hide formula helpShiftF1ShiftFnF1ShiftF1
Toggle full or compact formula helpF1FnF1F1
Cycle absolute and relative referencesF4FnF4F4
Toggle formula result previewsF9FnF9F9
Move up or down in the formula barUse the corresponding down key to move down.CtrlUpCtrlOptionUpCtrlUp
Toggle formula range selectionF2F2F2
Turn on screen-reader supportCtrlAltZCmdOptionZCtrlAltZ
Enable braille supportCtrlAltHCmdOptionHCtrlAltH
Read the current columnCtrlAltShiftCCmdOptionShiftCCtrlAltShiftC
Read the current rowCtrlAltShiftRCmdOptionShiftRCtrlAltShiftR

Make a printable Google Sheets sheet