Google Sheets keyboard shortcuts
Sheets deliberately borrows most of Excel's keys, so almost everything you already know still works. This page concentrates on the places where Excel's keys do not carry over, and on the handful of shortcuts Sheets has that Excel does not.
Checked against Google — Keyboard shortcuts for Google Sheets. Version: Google Sheets on the web.
Showing the Windows keyboard. Showing the Mac keyboard.
69 shortcuts
The top 18 are the Sheets shortcuts this page marks as the ones to learn first, in the order they appear here. The drill asks the marked ones first too, shuffled. Or tick your own and print those.
The 18 to learn first: the shortcuts the Sheets page marks as the ones to learn first, in the order they appear on it.
Your own sheet: the Sheets shortcuts you ticked.
Start here
Practise theseShow every shortcut Sheets knows # Sheets has a built-in list. This page is the one you can print.WinControl plusSlashMacCommand plusSlash
Jump to the edge of the data # Stops at the last filled cell before a gap, so one blank row in the middle of the data stops it early.WinControl plusarrow keyMacCommand plusarrow key
Select from here to the edge of the data #WinControl plusShift plusarrow keyMacShift plusCommand plusarrow key
Paste values only, without the formatting # Drops the formulas as well: what lands is the result each formula showed.WinControl plusShift plusVMacShift plusCommand plusV
Fill down # Copies the top cell of the selection into every cell below it. Select the whole range first, starting from the cell to copy.WinControl plusDMacCommand plusD
Fill right # The same, from the leftmost cell of the selection across.WinControl plusRMacCommand plusR
Insert today's date # Types a fixed date that never changes. =TODAY() in the cell updates every day instead.WinControl plusSemicolonMacCommand plusSemicolon
Insert the time now # Ctrl+Alt+Shift+; inserts the date and the time together. In Portugal, Italy, Germany and Spain Google lists Ctrl+Alt+Shift+N for that instead.WinControl plusShift plusSemicolonMacShift plusCommand plusSemicolon
Moving around
Practise theseGo to cell A1 # On a Mac keyboard without a Home key, Fn+Left stands in for Home.WinControl plusHomeMacFunction key plusCommand plusLeft arrow
Go to the last row with data #WinControl plusEndMacFunction key plusCommand plusRight arrow
Move to the start of the row #WinHomeMacFunction key plusLeft arrow
Next sheet #WinAlt plusDown arrowMacOption plusDown arrow
Previous sheet #WinAlt plusUp arrowMacOption plusUp arrow
Open the list of sheets #WinAlt plusShift plusKMacOption plusShift plusK
Move to the next open workbook # A browser shortcut, not a Sheets one.WinControl plusShift plusTabMacShift plusCommand plusTab
Scroll to the active cell #WinControl plusBackspaceMacCommand plusDelete
Selecting
Practise theseSelect the column # On a Mac with more than one keyboard language, Ctrl+Space may switch the input source instead.WinControl plusSpace barMacControl plusSpace bar
Select the row #WinShift plusSpace barMacShift plusSpace bar
Select everything #WinControl plusAMacCommand plusA
Select to the start of the sheet #WinControl plusShift plusHomeMacFunction key plusShift plusCommand plusLeft arrow
Select to the end of the data #WinControl plusShift plusEndMacFunction key plusShift plusCommand plusRight arrow
Extend one screen down #WinShift plusPage DownMacFunction key plusShift plusDown arrow
Editing
Practise theseEdit the cell in place # Typing straight into a selected cell replaces what was there. This keeps the contents and puts the cursor at the end.WinF2orEnterMacControl plusUorReturn
Start a new line inside the cell #WinAlt plusEnterMacOption plusReturn
Insert rows above #WinControl plusAlt plusPlusthenRMacOption plusCommand plusPlusthenR
Insert columns to the left #WinControl plusAlt plusPlusthenCMacOption plusCommand plusPlusthenC
Delete rows #WinControl plusAlt plusMinusthenRMacOption plusCommand plusMinusthenR
Delete columns #WinControl plusAlt plusMinusthenCMacOption plusCommand plusMinusthenC
Hide the row # Ctrl+Shift+9 unhides the rows either side of the selection.WinControl plusAlt plus9MacOption plusCommand plus9
Hide the column # Ctrl+Shift+0 unhides. Windows can reserve that combination for switching the input language, in which case it does nothing here.WinControl plusAlt plus0MacOption plusCommand plus0
Undo #WinControl plusZMacCommand plusZ
Redo # Ctrl+Shift+Z and F4 do the same.WinControl plusYMacCommand plusY
Find and replace # Cmd+Shift+H on a Mac, because Cmd+H hides the window there. Ctrl+F on its own only searches.WinControl plusHMacShift plusCommand plusH
Formatting
Practise theseBold #WinControl plusBMacCommand plusB
Italic #WinControl plusIMacCommand plusI
Underline #WinControl plusUMacCommand plusU
Strikethrough #WinAlt plusShift plus5MacShift plusCommand plusX
Centre the contents #WinControl plusShift plusEMacShift plusCommand plusE
Align left #WinControl plusShift plusLMacShift plusCommand plusL
Align right #WinControl plusShift plusRMacShift plusCommand plusR
Clear the formatting # Leaves the values and formulas. Only the formatting goes.WinControl plusBackslashMacCommand plusBackslash
Apply the number format #WinControl plusShift plus1MacControl plusShift plus1
Apply the time format #WinControl plusShift plus2MacControl plusShift plus2
Apply the date format #WinControl plusShift plus3MacControl plusShift plus3
Apply the currency format #WinControl plusShift plus4MacControl plusShift plus4
Apply the percentage format # Changes the display, not the number: 0.25 shows as 25%.WinControl plusShift plus5MacControl plusShift plus5
Apply the exponent format #WinControl plusShift plus6MacControl plusShift plus6
Put borders around the selection #WinAlt plusShift plus7MacOption plusShift plus7
Remove the borders #WinAlt plusShift plus6MacOption plusShift plus6
Formulas, filters and comments
Practise theseShow every formula instead of its result # The same key switches back. It changes the view only, not the sheet.WinControl plusBacktickMacControl plusBacktick
Insert an array formula # Wraps the formula in ARRAYFORMULA(). Many newer functions return a range on their own and do not need it.WinControl plusShift plusEnterMacShift plusCommand plusReturn
Collapse an expanded array formula #WinControl plusEMacCommand plusE
Show or hide the formula help #WinShift plusF1MacFunction key plusShift plusF1
Turn filters on or off #WinControl plusShift plusFMacControl plusShift plusF
Insert a comment # A comment starts a thread and can notify people with @. A note, on Shift+F2, is plain text on the cell with no thread.WinControl plusAlt plusMMacOption plusCommand plusM
Open the comment thread #WinControl plusAlt plusShift plusAMacOption plusShift plusCommand plusA
Insert a note #WinShift plusF2MacFunction key plusShift plusF2
Insert a link #WinControl plusKMacCommand plusK
Open the version history # Shows who changed what and when. Any earlier version can be restored, or copied into a new file.WinControl plusAlt plusShift plusHMacOption plusShift plusCommand plusH
Next
Excel
Excel rewards the keyboard more than any other program on this site: the difference between a competent user and a fast one is almost entirely in this list.
Docs
In Google Docs the key worth learning first is Alt+/, or Option+/ on a Mac, which finds any menu command when you type its name.
Chrome
Most of these hold in Edge, Brave, Opera and Vivaldi too, because they all share the same engine and the same conventions.
Word
Most of Word's shortcuts are decades old, but Microsoft has moved a few, and this page follows its current list, except where a row's note says otherwise.
Google Sheets keyboard shortcuts — comboshelf.com. Checked 23 September 2026 against Google — Keyboard shortcuts for Google Sheets.