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.
| Action | Windows | Mac |
|---|---|---|
| Copy | Ctrl+C | Cmd+C |
| Cut | Ctrl+X | Cmd+X |
| Paste | Ctrl+V | Cmd+V |
| Paste values only | Ctrl+Shift+V | Cmd+Shift+V |
| Undo | Ctrl+Z | Cmd+Z |
| RedoThree bindings are listed; F4 redoes only outside formula entry, where it switches reference types instead. | Ctrl+YorCtrl+Shift+ZorF4 | Cmd+YorCmd+Shift+ZorFn+F4 |
| Find | Ctrl+F | Cmd+F |
| Find and replaceThe Mac binding adds Shift, so it is not a plain Cmd swap. | Ctrl+H | Cmd+Shift+H |
| Edit cell contentsOpens what the focused cell already holds for editing; typing without it replaces the contents. | Enter | Return |
| Edit cell, keep range selectedStarts editing the active cell while the surrounding range stays selected. | F2 | F2 |
| New line inside a cellWorks while a cell is being edited; with a range selected the same keys fill the range. | Ctrl+Enter | Cmd+Return |
| Clear cell contentsEmpties the selected cells and leaves the neighbouring cells where they are. | Delete | Delete |
| Fill rangeApplies to a selected range; during cell editing the same keys start a new line. | Ctrl+Enter | Cmd+Return |
| Fill down | Ctrl+D | Cmd+D |
| Fill right | Ctrl+R | Cmd+R |
| Autofill a seriesSelect the filled cells plus the empty ones after them; numbers and dates continue, repeating values repeat. | Ctrl+Alt+Enter | Cmd+Option+Return |
| Smart FillAfter some example entries, Sheets looks for the pattern and suggests the remaining values. | Ctrl+Shift+Y | Cmd+Shift+Y |
| Insert link | Ctrl+K | Cmd+K |
| Convert range to table | Ctrl+Alt+T | Cmd+Option+T |
| Toggle a checkboxTicks or clears the checkbox in the focused cell. | Space | Space |
File and view controls 13
| Action | Windows | Mac |
|---|---|---|
| SaveNothing needs saving by hand: Drive stores each edit as it is made. | Ctrl+S | Cmd+S |
| Open | Ctrl+O | Cmd+O |
| Ctrl+P | Cmd+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+F | Ctrl+Shift+F |
| Turn input tools on or offOffered only when the spreadsheet language uses a non-Latin script. | Ctrl+Shift+K | Cmd+Shift+K |
| Select input tools | Ctrl+Alt+Shift+K | Cmd+Option+Shift+K |
| Open revision history | Ctrl+Alt+Shift+H | Cmd+Option+Shift+H |
| Open Explore | Ctrl+Alt+Shift+I | Cmd+Option+Shift+I |
| Go to side panel | Ctrl+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+M | Ctrl+Cmd+Shift+M |
| Close drawing editor | Shift+Esc | Cmd+EscorShift+Esc |
Selecting cells 6
| Action | Windows | Mac |
|---|---|---|
| Select columnPressed once it selects the cells in the column; pressed a second time, the column itself. | Ctrl+Space | Ctrl+Space |
| Select rowPressed once it selects the cells in the row; pressed a second time, the row itself. | Shift+Space | Shift+Space |
| Select all | Ctrl+AorCtrl+Shift+Space | Cmd+AorCmd+Shift+Space |
| Extend selection by one cellGrows the selection one adjacent cell at a time in the arrow direction. | Shift+Arrow keys | Shift+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+J | Cmd+J |
Sheets and panels 7
| Action | Windows | Mac |
|---|---|---|
| Insert new sheet | Shift+F11 | Shift+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+Down | Option+DownorOption+Right |
| Go to previous sheetFor MacBook keyboards the Mac list gives the Left arrow version. | Alt+Up | Option+UporOption+Left |
| Display list of sheetsArrow through the list and press Enter to switch to that sheet. | Alt+Shift+K | Option+Shift+K |
| Open sheet menuHolds the actions for the active sheet, such as duplicate, rename, copy and delete. | Alt+Shift+S | Option+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
| Action | Windows | Mac |
|---|---|---|
| BoldFormats the whole cell, or only the part of its text selected while editing the cell. | Ctrl+B | Cmd+BorCmd+2orCtrl+2 |
| Italic | Ctrl+I | Cmd+IorCmd+3orCtrl+3 |
| Underline | Ctrl+U | Cmd+UorCmd+4orCtrl+4 |
| Strikethrough | Alt+Shift+5 | Cmd+Shift+XorCmd+5orCtrl+5 |
| Center align | Ctrl+Shift+E | Cmd+Shift+E |
| Left align | Ctrl+Shift+L | Cmd+Shift+L |
| Right align | Ctrl+Shift+R | Cmd+Shift+R |
| Apply top border | Alt+Shift+1 | Option+Shift+1 |
| Apply right border | Alt+Shift+2 | Option+Shift+2 |
| Apply bottom border | Alt+Shift+3 | Option+Shift+3 |
| Apply left border | Alt+Shift+4 | Option+Shift+4 |
| Remove borders | Alt+Shift+6 | Option+Shift+6 |
| Apply outer border | Alt+Shift+7orCtrl+Shift+7 | Option+Shift+7orCmd+Shift+7orCtrl+Shift+7 |
| Clear formatting | Ctrl+\ | 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.
| Action | Windows | Mac |
|---|---|---|
| Format as decimal | Ctrl+Shift+1 | Ctrl+Shift+1 |
| Format as time | Ctrl+Shift+2 | Ctrl+Shift+2 |
| Format as date | Ctrl+Shift+3 | Ctrl+Shift+3 |
| Format as currency | Ctrl+Shift+4 | Ctrl+Shift+4 |
| Format as percentage | Ctrl+Shift+5 | Ctrl+Shift+5 |
| Format as exponentGoogle's screen reader guide calls this one Scientific formatting. | Ctrl+Shift+6 | Ctrl+Shift+6 |
| Insert date | Ctrl+; | Cmd+; |
| Insert time | Ctrl+Shift+; | Cmd+Shift+; |
| Insert date and time | Ctrl+Alt+Shift+; | Cmd+Option+Shift+; |
Rows and columns 16
| Action | Windows | Mac |
|---|---|---|
| Insert rows aboveThe first key needs whole rows selected; the letter sequence walks the Insert menu. | Ctrl+Alt+=orAlt+IthenRthenRorAlt+Shift+IthenRthenR | Cmd+Option+=orCtrl+Option+IthenRthenR |
| Insert rows belowA menu sequence only: Alt + I in Chrome, Alt + Shift + I in other browsers. | Alt+IthenRthenBorAlt+Shift+IthenRthenB | Ctrl+Option+IthenRthenB |
| Insert columns leftThe first key needs whole columns selected; the letter sequence walks the Insert menu. | Ctrl+Alt+=orAlt+IthenCthenCorAlt+Shift+IthenCthenC | Cmd+Option+=orCtrl+Option+IthenCthenC |
| Insert columns rightNo chord is listed for this direction, only the Insert-menu letter sequence. | Alt+IthenCthenOorAlt+Shift+IthenCthenO | Ctrl+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+EthenDthenD | Cmd+Option+-orCtrl+Option+EthenDthenD |
| Delete columnsThe first key needs whole columns selected; the letter sequence walks the Edit menu. | Ctrl+Alt+-orAlt+EthenDthenEorAlt+Shift+EthenDthenE | Cmd+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 row | Ctrl+Alt+9 | Cmd+Option+9 |
| Unhide row | Ctrl+Shift+9 | Cmd+Shift+9 |
| Hide column | Ctrl+Alt+0 | Cmd+Option+0 |
| Unhide column | Ctrl+Shift+0 | Cmd+Shift+0 |
| Group rows or columnsGroups the focused row or column with the one before it; select several cells to group more. | Alt+Shift+Right | Option+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+Left | Option+Shift+Left |
| Expand groupFocus has to be on the collapsed row or column. | Alt+Shift+Down | Option+Shift+Down |
| Collapse groupFocus has to be on the expanded row or column. | Alt+Shift+Up | Option+Shift+Up |
Formulas 9
| Action | Windows | Mac |
|---|---|---|
| Show all formulasGoogle prints the key as the tilde; the Mac list keeps Ctrl here. | Ctrl+~ | Ctrl+~ |
| Insert array formula | Ctrl+Shift+Enter | Cmd+Shift+Return |
| Collapse expanded array formula | Ctrl+E | Cmd+E |
| Switch absolute and relative referencesWorks during formula entry; outside it F4 is one of the Redo keys. | F4 | Fn+F4 |
| Toggle formula range selectionOnly during formula entry; the Mac list keeps Ctrl + E for this. | F2orCtrl+E | F2orCtrl+E |
| Show or hide formula helpResponds only while a formula is being entered. | Shift+F1 | Shift+Fn+F1 |
| Full or compact formula helpSwitches the help box between its long and short form during formula entry. | F1 | Fn+F1 |
| Toggle formula result previews | F9 | Fn+F9 |
| Resize formula barOne key moves the edge of the bar up, the other moves it down. | Ctrl+UporCtrl+Down | Ctrl+Option+UporCtrl+Option+Down |
Notes and comments 11
| Action | Windows | Mac |
|---|---|---|
| Insert or edit noteType in the box that opens and press Esc; emptying the text deletes the note. | Shift+F2 | Shift+F2 |
| Insert or edit comment | Ctrl+Alt+M | Cmd+Option+M |
| Open comment discussion thread | Ctrl+Alt+Shift+A | Cmd+Option+Shift+A |
| Enter current commentTwo-step key: hold the modifiers, press E, then C. | Ctrl+Alt+EthenCtrl+Alt+C | Ctrl+Cmd+EthenCtrl+Cmd+C |
| Go to next commentTwo-step key: hold the modifiers, press N, then C. | Ctrl+Alt+NthenCtrl+Alt+C | Ctrl+Cmd+NthenCtrl+Cmd+C |
| Go to previous commentTwo-step key: hold the modifiers, press P, then C. | Ctrl+Alt+PthenCtrl+Alt+C | Ctrl+Cmd+PthenCtrl+Cmd+C |
| Reply to selected commentSingle letter, active while a comment is selected. | R | R |
| Next comment from a selected oneSingle letter, active while a comment is selected. | J | J |
| Previous comment from a selected one | K | K |
| Resolve selected comment | E | E |
| Exit selected comment | U | U |
Screen reader support 4
| Action | Windows | Mac |
|---|---|---|
| Enable screen reader supportHas to be on before the Accessibility menu appears in the menu bar. | Ctrl+Alt+Z | Cmd+Option+Z |
| Enable braille support | Ctrl+Alt+H | Cmd+Option+H |
| Read columnSpeaks the column from its first row down to the current row. | Ctrl+Alt+Shift+C | Cmd+Option+Shift+C |
| Read rowSpeaks the row from its first column across to the current column. | Ctrl+Alt+Shift+R | Cmd+Option+Shift+R |
Mac only 4
| Action | Windows | Mac |
|---|---|---|
| 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 |
No row on this page matches that filter.
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
- Google Docs Editors Help — Keyboard shortcuts for Google Sheets (Computer: PC shortcuts and Mac shortcuts)
- Google Docs Editors Help — Use Smart Fill in Sheets to automate data entry The Smart Fill shortcut for Windows and Mac, which the shortcut article does not list.
- Google Docs Editors Help — Use Google Sheets with a screen reader
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.