Google Sheets keyboard shortcuts

Sheets is easiest to use when the selection stays in the grid. These shortcuts move through cells, edit formulas and values, format a range, and open the tools that change how data is handled.

Sheets works best when the active cell stays under your hands. Start with navigation and selection, then move through editing, formatting, formulas, and the data commands that change a range into useful work.

Move through cells and ranges, jump to the edge of data, and extend the current selection.

ActionWindowsmacOSLinux
Move to the edge of the data regionWorks with each arrow key direction.CtrlArrowCmdArrowCtrlArrow
Select from here to the edge of the data regionCtrlShiftArrowCmdShiftArrowCtrlShiftArrow
Move to the beginning of the sheetCtrlHomeCmdHomeCtrlHome
Move to the next sheetThe same chord with Up or Page Up moves to the previous sheet.CtrlShiftPage DownCmdShiftFnDownCtrlShiftPage Down
Select the current columnCtrlSpaceCtrlSpaceCtrlSpace
Select the current rowShiftSpaceShiftSpaceShiftSpace
Open the Go to range dialogCtrlGCtrlGCtrlG
Move to the beginning of the current rowHomeFnLeftHome
Move to the end of the current rowEndFnRightEnd
Move to the previous sheetAltUpOptionUpAltUp
Display the list of sheetsAltShiftKOptionShiftKAltShiftK

Editing cells

Enter values and formulas, fill or repeat them, and undo changes while staying in the sheet.

ActionWindowsmacOSLinux
Edit the active cellF2 also edits on Windows and Linux.EnterEnterEnter
Start a new line inside the cellAltEnterOptionEnterAltEnter
Fill down from the cell aboveCtrlDCmdDCtrlD
Fill right from the cell to the leftCtrlRCmdRCtrlR
Insert today's dateCtrl;Cmd;Ctrl;
Insert the current timeCtrlShift;CmdShift;CtrlShift;
Clear formatting from the selectionCtrl\Cmd\Ctrl\
Fill the selected range with the current entryCtrlEnterCmdEnterCtrlEnter
Paste values onlyCtrlShiftVCmdShiftVCtrlShiftV
Show the keyboard shortcuts listCtrl/Cmd/Ctrl/
Open the tool finderAlt/Option/Alt/
Insert a new sheetShiftF11ShiftFnF11ShiftF11

Formatting

Apply number formats, text styles, borders, alignment, and other changes to the selection.

ActionWindowsmacOSLinux
BoldCtrlBCmdBCtrlB
ItalicCtrlICmdICtrlI
UnderlineCtrlUCmdUCtrlU
Apply the default number formatDigits 2 through 5 apply time, date, currency, and percentage formats.CtrlShift1CmdShift1CtrlShift1
StrikethroughAltShift5CmdShiftXAltShift5
Center alignCtrlShiftECmdShiftECtrlShiftE
Left alignCtrlShiftLCmdShiftLCtrlShiftL
Right alignCtrlShiftRCmdShiftRCtrlShiftR
Format as decimalCtrlShift1CtrlShift1CtrlShift1
Format as timeCtrlShift2CtrlShift2CtrlShift2
Format as dateCtrlShift3CtrlShift3CtrlShift3
Format as currencyCtrlShift4CtrlShift4CtrlShift4
Format as percentageCtrlShift5CtrlShift5CtrlShift5
Format as exponentCtrlShift6CtrlShift6CtrlShift6

Data and tools

Open menus, comments, links, filters, and spreadsheet tools without leaving the grid.

ActionWindowsmacOSLinux
Open find and replaceCtrlFCmdFCtrlF
UndoCtrlZCmdZCtrlZ
RedoCtrlYCmdYCtrlY
Open Explore for automatic analysisCtrlAltShiftECmdOptionShiftECtrlAltShiftE
Open find and replaceCtrlHCmdShiftHCtrlH
Insert or edit a noteShiftF2ShiftF2ShiftF2
Insert or edit a commentCtrlAltMCmdOptionMCtrlAltM
Open revision historyCtrlAltShiftHCmdOptionShiftHCtrlAltShiftH
Open the insert menuCtrlAlt=CmdOption=CtrlAlt=
Open the delete menuCtrlAlt-CmdOption-CtrlAlt-
Open the context menuCtrlShift\CmdShift\CtrlShift\
Show all formulasCtrl~Ctrl~Ctrl~
Cycle absolute and relative references while entering a formulaF4FnF4F4
Open a drop-down menu on a filtered cellCtrlAltRCtrlCmdRCtrlAltR
Hide the selected rowCtrlAlt9CmdOption9CtrlAlt9
Hide the selected columnCtrlAlt0CmdOption0CtrlAlt0
Group selected rows or columnsAltShiftRightOptionShiftRightAltShiftRight
Ungroup selected rows or columnsAltShiftLeftOptionShiftLeftAltShiftLeft
Insert an array formulaCtrlShiftEnterCmdShiftEnterCtrlShiftEnter

Make the useful keys stick

The useful Sheets habit is small and physical: keep the selection moving, edit in place, and let the grid stay under your hands. Learn a couple of keys from the section you use most, then return when a new kind of work appears.

You do not need this whole page in your head. Pick two shortcuts that remove a repeated hand movement, use them until they feel ordinary, and come back for the next pair.

Make a printable sheet for this app

Microsoft ExcelAll apps