Google Sheets keyboard shortcuts for Windows and Mac

Google Sheets shortcuts for the desktop browser, taken from Google's own PC and Mac lists: the Windows column follows the PC list, the Mac column the Mac list, row by row. The Chrome OS, Android and iPhone lists are left out. Menu keys on Windows depend on the browser, comment and popup navigation uses two-step keys held with Ctrl and Alt, and several Mac bindings, such as the number formats, keep Ctrl instead of Cmd.

140 shortcuts in 13 sections. Checked row by row against Google Docs Editors Help on . Edited by Jay.

Basic editing 20

Sheets can also accept the shortcuts of other companies' spreadsheet programs. The option is off until you open Help > Keyboard shortcuts and switch on "Enable compatible spreadsheet shortcuts" at the bottom of that window; those extra keys are not part of this table.

ActionWindowsMac
CopyCtrl+CCmd+C
CutCtrl+XCmd+X
PasteCtrl+VCmd+V
Paste values onlyCtrl+Shift+VCmd+Shift+V
UndoCtrl+ZCmd+Z
RedoThree bindings are listed; F4 redoes only outside formula entry, where it switches reference types instead.Ctrl+YorCtrl+Shift+ZorF4Cmd+YorCmd+Shift+ZorFn+F4
FindCtrl+FCmd+F
Find and replaceThe Mac binding adds Shift, so it is not a plain Cmd swap.Ctrl+HCmd+Shift+H
Edit cell contentsOpens what the focused cell already holds for editing; typing without it replaces the contents.EnterReturn
Edit cell, keep range selectedStarts editing the active cell while the surrounding range stays selected.F2F2
New line inside a cellWorks while a cell is being edited; with a range selected the same keys fill the range.Ctrl+EnterCmd+Return
Clear cell contentsEmpties the selected cells and leaves the neighbouring cells where they are.DeleteDelete
Fill rangeApplies to a selected range; during cell editing the same keys start a new line.Ctrl+EnterCmd+Return
Fill downCtrl+DCmd+D
Fill rightCtrl+RCmd+R
Autofill a seriesSelect the filled cells plus the empty ones after them; numbers and dates continue, repeating values repeat.Ctrl+Alt+EnterCmd+Option+Return
Smart FillAfter some example entries, Sheets looks for the pattern and suggests the remaining values.Ctrl+Shift+YCmd+Shift+Y
Insert linkCtrl+KCmd+K
Convert range to tableCtrl+Alt+TCmd+Option+T
Toggle a checkboxTicks or clears the checkbox in the focused cell.SpaceSpace

File and view controls 13

ActionWindowsMac
SaveNothing needs saving by hand: Drive stores each edit as it is made.Ctrl+SCmd+S
OpenCtrl+OCmd+O
PrintCtrl+PCmd+P
Show keyboard shortcutsOpens the in-app shortcut list, which can be searched for actions such as move or columns.Ctrl+/Cmd+/
Tool finderType a command name such as Rename or Insert, arrow to a result and press Enter.Alt+/Option+/
Compact controlsHides or shows the menus; the menu shortcuts only respond while the menus are visible.Ctrl+Shift+FCtrl+Shift+F
Turn input tools on or offOffered only when the spreadsheet language uses a non-Latin script.Ctrl+Shift+KCmd+Shift+K
Select input toolsCtrl+Alt+Shift+KCmd+Option+Shift+K
Open revision historyCtrl+Alt+Shift+HCmd+Option+Shift+H
Open ExploreCtrl+Alt+Shift+ICmd+Option+Shift+I
Go to side panelCtrl+Alt+.orCtrl+Alt+,Cmd+Option+.orCmd+Option+,
Move focus out of the gridFor leaving the cell grid with the keyboard; the Mac binding holds Ctrl and Cmd, not Cmd and Option.Ctrl+Alt+Shift+MCtrl+Cmd+Shift+M
Close drawing editorShift+EscCmd+EscorShift+Esc

Selecting cells 6

ActionWindowsMac
Select columnPressed once it selects the cells in the column; pressed a second time, the column itself.Ctrl+SpaceCtrl+Space
Select rowPressed once it selects the cells in the row; pressed a second time, the row itself.Shift+SpaceShift+Space
Select allCtrl+AorCtrl+Shift+SpaceCmd+AorCmd+Shift+Space
Extend selection by one cellGrows the selection one adjacent cell at a time in the arrow direction.Shift+Arrow keysShift+Arrow keys
Select to end of filled cellsStops at the last filled cell; pressing the arrow once more pushes the selection further.Ctrl+Shift+Arrow keys—
Focus the name boxType a range such as b2:f6, or part of a named range, and press Enter to select it.Ctrl+JCmd+J

Cell navigation 14

ActionWindowsMac
Go to beginning of rowHomeFn+Left
Go to end of rowEndFn+Right
Go to beginning of sheetCtrl+HomeCmd+Fn+Left
Go to end of sheetCtrl+EndCmd+Fn+Right
Scroll to active cellBrings the view back to the active cell after scrolling away from it.Ctrl+BackspaceCmd+Backspace
Move right within a rangeWith a range selected, focus steps left to right and wraps inside the range.TabTab
Move left within a rangeWith a range selected, focus steps right to left and wraps inside the range.Shift+TabShift+Tab
Move down within a rangeWith a range selected, focus steps top to bottom and wraps inside the range.EnterReturn
Move up within a rangeWith a range selected, focus steps bottom to top; an arrow key drops the selection.Shift+EnterShift+Return
Open hyperlinkFollows the link in the focused cell.Alt+EnterOption+Return
Move focus to popupTwo-step key: hold the modifiers, press E, then P. Reaches the popup of a link, bookmark, image or smart chip.Ctrl+Alt+EthenCtrl+Alt+PCtrl+Cmd+EthenCtrl+Cmd+P
Open filter drop-down menuUse it on the top cell of a filtered range to reach the filter options.Ctrl+Alt+RCtrl+Cmd+R
Move to quicksumNeeds a selected range; the list gives its sum, minimum, maximum, count and average.Alt+Shift+QOption+Shift+Q
Return focus to the cellsLeaves the quicksum list, the name box or a note box and goes back to the grid.EscEsc

Sheets and panels 7

ActionWindowsMac
Insert new sheetShift+F11Shift+Fn+F11
Rename sheetPrinted in the PC list only; the Mac list has no rename key.Alt+1—
Go to next sheetFor MacBook keyboards the Mac list gives the Right arrow version.Alt+DownOption+DownorOption+Right
Go to previous sheetFor MacBook keyboards the Mac list gives the Left arrow version.Alt+UpOption+UporOption+Left
Display list of sheetsArrow through the list and press Enter to switch to that sheet.Alt+Shift+KOption+Shift+K
Open sheet menuHolds the actions for the active sheet, such as duplicate, rename, copy and delete.Alt+Shift+SOption+Shift+S
Select adjacent sheet tabsAdds neighbouring sheet tabs to the selection so one sheet-menu action applies to them all.Ctrl+Alt+[orCtrl+Alt+]Cmd+Option+[orCmd+Option+]

Formatting 14

ActionWindowsMac
BoldFormats the whole cell, or only the part of its text selected while editing the cell.Ctrl+BCmd+BorCmd+2orCtrl+2
ItalicCtrl+ICmd+IorCmd+3orCtrl+3
UnderlineCtrl+UCmd+UorCmd+4orCtrl+4
StrikethroughAlt+Shift+5Cmd+Shift+XorCmd+5orCtrl+5
Center alignCtrl+Shift+ECmd+Shift+E
Left alignCtrl+Shift+LCmd+Shift+L
Right alignCtrl+Shift+RCmd+Shift+R
Apply top borderAlt+Shift+1Option+Shift+1
Apply right borderAlt+Shift+2Option+Shift+2
Apply bottom borderAlt+Shift+3Option+Shift+3
Apply left borderAlt+Shift+4Option+Shift+4
Remove bordersAlt+Shift+6Option+Shift+6
Apply outer borderAlt+Shift+7orCtrl+Shift+7Option+Shift+7orCmd+Shift+7orCtrl+Shift+7
Clear formattingCtrl+\Cmd+\

Number formats and dates 9

For Portugal, Italy, Germany and Spain Google lists different keys: Ctrl + Shift + H for the time, Ctrl + Shift + D for the date and Ctrl + Alt + Shift + N for both. The article adds that some shortcuts might not work for all languages or keyboards.

The Mac list of the shortcut article gives the six number-format keys with Ctrl, as shown here. Google's screen reader guide for Sheets prints the same formats with Command + Shift + 1 to 6.

ActionWindowsMac
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 exponentGoogle's screen reader guide calls this one Scientific formatting.Ctrl+Shift+6Ctrl+Shift+6
Insert dateCtrl+;Cmd+;
Insert timeCtrl+Shift+;Cmd+Shift+;
Insert date and timeCtrl+Alt+Shift+;Cmd+Option+Shift+;

Rows and columns 16

ActionWindowsMac
Insert rows aboveThe first key needs whole rows selected; the letter sequence walks the Insert menu.Ctrl+Alt+=orAlt+IthenRthenRorAlt+Shift+IthenRthenRCmd+Option+=orCtrl+Option+IthenRthenR
Insert rows belowA menu sequence only: Alt + I in Chrome, Alt + Shift + I in other browsers.Alt+IthenRthenBorAlt+Shift+IthenRthenBCtrl+Option+IthenRthenB
Insert columns leftThe first key needs whole columns selected; the letter sequence walks the Insert menu.Ctrl+Alt+=orAlt+IthenCthenCorAlt+Shift+IthenCthenCCmd+Option+=orCtrl+Option+IthenCthenC
Insert columns rightNo chord is listed for this direction, only the Insert-menu letter sequence.Alt+IthenCthenOorAlt+Shift+IthenCthenOCtrl+Option+IthenCthenO
Open insert menuWith cells selected instead of whole rows or columns, the key opens a menu of insert choices.Ctrl+Alt+=Cmd+Option+=
Delete rowsThe first key needs whole rows selected; the letter sequence walks the Edit menu.Ctrl+Alt+-orAlt+EthenDthenDorAlt+Shift+EthenDthenDCmd+Option+-orCtrl+Option+EthenDthenD
Delete columnsThe first key needs whole columns selected; the letter sequence walks the Edit menu.Ctrl+Alt+-orAlt+EthenDthenEorAlt+Shift+EthenDthenECmd+Option+-orCtrl+Option+EthenDthenE
Open delete menuWith cells selected instead of whole rows or columns, the key opens a menu of delete choices.Ctrl+Alt+-Cmd+Option+-
Hide rowCtrl+Alt+9Cmd+Option+9
Unhide rowCtrl+Shift+9Cmd+Shift+9
Hide columnCtrl+Alt+0Cmd+Option+0
Unhide columnCtrl+Shift+0Cmd+Shift+0
Group rows or columnsGroups the focused row or column with the one before it; select several cells to group more.Alt+Shift+RightOption+Shift+Right
Ungroup rows or columnsFocus must be on a cell of the group, and a collapsed group has to be expanded first.Alt+Shift+LeftOption+Shift+Left
Expand groupFocus has to be on the collapsed row or column.Alt+Shift+DownOption+Shift+Down
Collapse groupFocus has to be on the expanded row or column.Alt+Shift+UpOption+Shift+Up

Formulas 9

ActionWindowsMac
Show all formulasGoogle prints the key as the tilde; the Mac list keeps Ctrl here.Ctrl+~Ctrl+~
Insert array formulaCtrl+Shift+EnterCmd+Shift+Return
Collapse expanded array formulaCtrl+ECmd+E
Switch absolute and relative referencesWorks during formula entry; outside it F4 is one of the Redo keys.F4Fn+F4
Toggle formula range selectionOnly during formula entry; the Mac list keeps Ctrl + E for this.F2orCtrl+EF2orCtrl+E
Show or hide formula helpResponds only while a formula is being entered.Shift+F1Shift+Fn+F1
Full or compact formula helpSwitches the help box between its long and short form during formula entry.F1Fn+F1
Toggle formula result previewsF9Fn+F9
Resize formula barOne key moves the edge of the bar up, the other moves it down.Ctrl+UporCtrl+DownCtrl+Option+UporCtrl+Option+Down

Notes and comments 11

ActionWindowsMac
Insert or edit noteType in the box that opens and press Esc; emptying the text deletes the note.Shift+F2Shift+F2
Insert or edit commentCtrl+Alt+MCmd+Option+M
Open comment discussion threadCtrl+Alt+Shift+ACmd+Option+Shift+A
Enter current commentTwo-step key: hold the modifiers, press E, then C.Ctrl+Alt+EthenCtrl+Alt+CCtrl+Cmd+EthenCtrl+Cmd+C
Go to next commentTwo-step key: hold the modifiers, press N, then C.Ctrl+Alt+NthenCtrl+Alt+CCtrl+Cmd+NthenCtrl+Cmd+C
Go to previous commentTwo-step key: hold the modifiers, press P, then C.Ctrl+Alt+PthenCtrl+Alt+CCtrl+Cmd+PthenCtrl+Cmd+C
Reply to selected commentSingle letter, active while a comment is selected.RR
Next comment from a selected oneSingle letter, active while a comment is selected.JJ
Previous comment from a selected oneKK
Resolve selected commentEE
Exit selected commentUU

Screen reader support 4

ActionWindowsMac
Enable screen reader supportHas to be on before the Accessibility menu appears in the menu bar.Ctrl+Alt+ZCmd+Option+Z
Enable braille supportCtrl+Alt+HCmd+Option+H
Read columnSpeaks the column from its first row down to the current row.Ctrl+Alt+Shift+CCmd+Option+Shift+C
Read rowSpeaks the row from its first column across to the current column.Ctrl+Alt+Shift+RCmd+Option+Shift+R

Mac only 4

ActionWindowsMac
Select current regionSelects the block of cells around the selected cell; printed in the Mac list only.—Cmd+Shift+*orCtrl+Shift+*
Open Go to range dialogPrinted in the Mac list only; on Windows the name box takes a range.—Ctrl+G
Find and replace, Find tabOpens Find and replace with its Find tab in front; plain Find on a Mac is Cmd + F.—Ctrl+F
Show or hide the menusA second Mac key for the menu toggle that Ctrl + Shift + F also performs.—Cmd+Option+R

Notes

Moving and selecting

Ctrl + Home and Ctrl + End go to the beginning and end of the sheet, Home and End to the ends of the row. Ctrl + Space and Shift + Space select a column and a row: one press takes the cells in it, a second press the column or row itself. Holding Ctrl and Shift with an arrow key selects to the last filled cell. Ctrl + J puts focus in the name box, which accepts a cell reference, a range or a named range; Google's Mac list also has Ctrl + G for a Go to range dialog. Inside a selected range, Tab and Enter move across and down without dropping the selection.

Paste values, fills and array formulas

Ctrl + Shift + V pastes values only, the fix for pasting a calculated column somewhere it should be static. Ctrl + Shift + Enter inserts an array formula, and Ctrl + E collapses an expanded one. Smart Fill is Ctrl + Shift + Y: after a few examples of a pattern, such as first names taken from full names, Sheets suggests the rest of the column. Ctrl + Alt + Enter autofills a series across the selected empty cells. F4 switches the reference being typed between absolute and relative forms; outside formula entry the same key is one of the Redo bindings.

Formatting and dates

Ctrl + Shift + 1, Ctrl + Shift + 3, Ctrl + Shift + 4 and Ctrl + Shift + 5 apply the decimal, date, currency and percentage formats; Ctrl + Shift + 2 and Ctrl + Shift + 6 add time and exponent. The date goes in with Ctrl + ;, the time with Ctrl + Shift + ; and both together with Ctrl + Alt + Shift + ;. Ctrl + ~ shows all formulas instead of their results, useful for auditing what is calculated and what is typed. Ctrl + \ clears the formatting of the selection.

Rows, columns and the menus

Insert and delete share two keys whose result depends on the selection. With whole rows or columns selected, Ctrl + Alt + = inserts above or to the left and Ctrl + Alt + - deletes them; with plain cells selected the same keys open the insert and delete menus. Inserting below or to the right has no chord, only a menu sequence such as Alt + I, R, B / Alt + Shift + I, R, B. Ctrl + Alt + 9 and Ctrl + Alt + 0 hide a row and a column; Ctrl + Shift + 9 and Ctrl + Shift + 0 bring them back.

Questions

How do I paste values only in Google Sheets?

Ctrl + Shift + V on Windows and Cmd + Shift + V on a Mac. Google lists the action as Paste values only.

Which keys insert an array formula?

Ctrl + Shift + Enter on Windows and Cmd + Shift + Return on a Mac. Ctrl + E (Cmd + E on a Mac) collapses an expanded array formula again.

Does F4 work for absolute references like in Excel?

Yes, while a formula is being entered F4 switches between absolute and relative references; on a Mac the listed key is Fn + F4. Outside formula entry F4 is one of the Redo keys.

Is Ctrl + E the Smart Fill shortcut?

No. Google documents Smart Fill as Ctrl + Shift + Y on Windows and Chromebook and Cmd + Shift + Y on a Mac. In Sheets, Ctrl + E collapses an expanded array formula and, during formula entry, toggles formula range selection.

Why do the Alt menu shortcuts not open the menus?

Two documented causes. Outside Chrome the menu keys need Shift as well, for example Alt + Shift + F for the File menu. And when the menus are hidden the menu shortcuts do nothing: Ctrl + Shift + F turns the menus back on, on Windows and Mac alike.

Can I use Excel shortcuts in Google Sheets?

Sheets has an option for shortcuts from other companies' spreadsheet programs: open Help > Keyboard shortcuts and turn on "Enable compatible spreadsheet shortcuts" at the bottom of the window. Google's article does not list which keys that adds, so they are not in this table.

Sources and checks

Every row on this page was matched to a line in the documentation above on . A binding that could not be found there is not listed.

7 rows from the earlier version of this page were removed in that check: duplicates, and bindings the documentation does not list or lists differently.

Found a wrong or missing key? Tell us and it gets checked against the source. How we verify describes the process and its limits.