Google Sheets keyboard shortcuts for PC and Mac

Common actions

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

Action	Shortcuts
Select the current column	Windows / macOS / Linux`Ctrl` + `Space`
Select the current row	Windows / macOS / Linux`Shift` + `Space`
Select allCtrl+Shift+Space on PC and Cmd+Shift+Space on Mac are also documented.	Windows / Linux`Ctrl` + `A` macOS`Cmd` + `A`
Undo	Windows / Linux`Ctrl` + `Z` macOS`Cmd` + `Z`
RedoCtrl+Shift+Z, Cmd+Shift+Z, and F4 on PC or Fn+F4 on Mac are also documented.	Windows / Linux`Ctrl` + `Y` macOS`Cmd` + `Y`
Find	Windows / Linux`Ctrl` + `F` macOS`Cmd` + `F`
Find and replace	Windows / Linux`Ctrl` + `H` macOS`Cmd` + `Shift` + `H`
Fill the selected range	Windows / Linux`Ctrl` + `Enter` macOS`Cmd` + `Enter`
Fill down	Windows / Linux`Ctrl` + `D` macOS`Cmd` + `D`
Fill right	Windows / Linux`Ctrl` + `R` macOS`Cmd` + `R`
Save changesSheets saves changes automatically in Drive.	Windows / Linux`Ctrl` + `S` macOS`Cmd` + `S`
Open	Windows / Linux`Ctrl` + `O` macOS`Cmd` + `O`
Print	Windows / Linux`Ctrl` + `P` macOS`Cmd` + `P`
Copy	Windows / Linux`Ctrl` + `C` macOS`Cmd` + `C`
Cut	Windows / Linux`Ctrl` + `X` macOS`Cmd` + `X`
Paste	Windows / Linux`Ctrl` + `V` macOS`Cmd` + `V`
Paste values only	Windows / Linux`Ctrl` + `Shift` + `V` macOS`Cmd` + `Shift` + `V`
Show keyboard shortcuts	Windows / Linux`Ctrl` + `/` macOS`Cmd` + `/`
Insert a new sheet	Windows / Linux`Shift` + `F11` macOS`Shift` + `Fn` + `F11`
Show or hide compact controls	Windows / macOS / Linux`Ctrl` + `Shift` + `F`
Open Tool finder	Windows / Linux`Alt` + `/` macOS`Option` + `/`
Rename the current sheet	Windows / Linux`Alt` + `1` macOSNot documented
Convert a range to a table	Windows / Linux`Ctrl` + `Alt` + `T` macOS`Cmd` + `Option` + `T`

Format cells

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

Action	Shortcuts
Bold	Windows / Linux`Ctrl` + `B` macOS`Cmd` + `B`
Underline	Windows / Linux`Ctrl` + `U` macOS`Cmd` + `U`
Italic	Windows / Linux`Ctrl` + `I` macOS`Cmd` + `I`
Strikethrough	Windows / Linux`Alt` + `Shift` + `5` macOS`Cmd` + `Shift` + `X`
Center align	Windows / Linux`Ctrl` + `Shift` + `E` macOS`Cmd` + `Shift` + `E`
Left align	Windows / Linux`Ctrl` + `Shift` + `L` macOS`Cmd` + `Shift` + `L`
Right align	Windows / Linux`Ctrl` + `Shift` + `R` macOS`Cmd` + `Shift` + `R`
Apply a top border	Windows / Linux`Alt` + `Shift` + `1` macOS`Option` + `Shift` + `1`
Apply a right border	Windows / Linux`Alt` + `Shift` + `2` macOS`Option` + `Shift` + `2`
Apply a bottom border	Windows / Linux`Alt` + `Shift` + `3` macOS`Option` + `Shift` + `3`
Apply a left border	Windows / Linux`Alt` + `Shift` + `4` macOS`Option` + `Shift` + `4`
Remove borders	Windows / Linux`Alt` + `Shift` + `6` macOS`Option` + `Shift` + `6`
Apply an outer borderCtrl+Shift+7 and Cmd+Shift+7 are also documented.	Windows / Linux`Alt` + `Shift` + `7` macOS`Option` + `Shift` + `7`
Insert a link	Windows / Linux`Ctrl` + `K` macOS`Cmd` + `K`
Insert the current time	Windows / Linux`Ctrl` + `Shift` + `;` macOS`Cmd` + `Shift` + `;`
Insert the current date	Windows / Linux`Ctrl` + `;` macOS`Cmd` + `;`
Insert the current date and time	Windows / Linux`Ctrl` + `Alt` + `Shift` + `;` macOS`Cmd` + `Option` + `Shift` + `;`
Format as decimal	Windows / macOS / Linux`Ctrl` + `Shift` + `1`
Format as time	Windows / macOS / Linux`Ctrl` + `Shift` + `2`
Format as date	Windows / macOS / Linux`Ctrl` + `Shift` + `3`
Format as currency	Windows / macOS / Linux`Ctrl` + `Shift` + `4`
Format as percentage	Windows / macOS / Linux`Ctrl` + `Shift` + `5`
Format as exponent	Windows / macOS / Linux`Ctrl` + `Shift` + `6`
Clear formatting	Windows / Linux`Ctrl` + `\` macOS`Cmd` + `\`

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

Action	Shortcuts
Move to the beginning of the row	Windows / Linux`Home` macOS`Fn` + `Left`
Move to the beginning of the sheet	Windows / Linux`Ctrl` + `Home` macOS`Cmd` + `Fn` + `Left`
Move to the end of the row	Windows / Linux`End` macOS`Fn` + `Right`
Move to the end of the sheet	Windows / Linux`Ctrl` + `End` macOS`Cmd` + `Fn` + `Right`
Scroll to the active cell	Windows / Linux`Ctrl` + `Backspace` macOS`Cmd` + `Backspace`
Move to the next sheetOption+Right is also documented for MacBook keyboards.	Windows / Linux`Alt` + `Down` macOS`Option` + `Down`
Move to the previous sheetOption+Left is also documented for MacBook keyboards.	Windows / Linux`Alt` + `Up` macOS`Option` + `Up`
Display the list of sheets	Windows / Linux`Alt` + `Shift` + `K` macOS`Option` + `Shift` + `K`
Open the hyperlink in the selected cell	Windows / Linux`Alt` + `Enter` macOS`Option` + `Enter`
Open Explore	Windows / Linux`Ctrl` + `Alt` + `Shift` + `I` macOS`Cmd` + `Option` + `Shift` + `I`
Move to the side panelThe comma variant is also documented.	Windows / Linux`Ctrl` + `Alt` + `.` macOS`Cmd` + `Option` + `.`
Move focus out of the spreadsheet	Windows / Linux`Ctrl` + `Alt` + `Shift` + `M` macOS`Ctrl` + `Cmd` + `Shift` + `M`
Move to Quick Sum	Windows / Linux`Alt` + `Shift` + `Q` macOS`Option` + `Shift` + `Q`
Open the drop-down menu on a filtered cell	Windows / Linux`Ctrl` + `Alt` + `R` macOS`Ctrl` + `Cmd` + `R`
Open revision history	Windows / Linux`Ctrl` + `Alt` + `Shift` + `H` macOS`Cmd` + `Option` + `Shift` + `H`
Close the drawing editor	Windows / Linux`Shift` + `Esc` macOS`Cmd` + `Esc`

Notes and comments

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

Action	Shortcuts
Insert or edit a note	Windows / macOS / Linux`Shift` + `F2`
Insert or edit a comment	Windows / Linux`Ctrl` + `Alt` + `M` macOS`Cmd` + `Option` + `M`
Open a comment discussion thread	Windows / Linux`Ctrl` + `Alt` + `Shift` + `A` macOS`Cmd` + `Option` + `Shift` + `A`
Enter the current comment	Windows / Linux`Ctrl` + `Alt` + `E` then `C` macOS`Ctrl` + `Cmd` + `E` then `C`
Move to the next comment	Windows / Linux`Ctrl` + `Alt` + `N` then `C` macOS`Ctrl` + `Cmd` + `N` then `C`
Move to the previous comment	Windows / Linux`Ctrl` + `Alt` + `P` then `C` macOS`Ctrl` + `Cmd` + `P` then `C`
Reply to a selected comment	Windows / macOS / Linux`R`
Resolve a selected comment	Windows / macOS / Linux`E`
Exit the selected comment	Windows / macOS / Linux`U`

Menus, rows, and columns

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

Action	Shortcuts
Open the File menu	Windows`Alt` + `F` macOS`Ctrl` + `Option` + `F` Linux`Alt` + `Shift` + `F`
Open the Edit menu	Windows`Alt` + `E` macOS`Ctrl` + `Option` + `E` Linux`Alt` + `Shift` + `E`
Open the View menu	Windows`Alt` + `V` macOS`Ctrl` + `Option` + `V` Linux`Alt` + `Shift` + `V`
Open the Insert menu	Windows`Alt` + `I` macOS`Ctrl` + `Option` + `I` Linux`Alt` + `Shift` + `I`
Open the Format menu	Windows`Alt` + `O` macOS`Ctrl` + `Option` + `O` Linux`Alt` + `Shift` + `O`
Open the Data menu	Windows`Alt` + `D` macOS`Ctrl` + `Option` + `D` Linux`Alt` + `Shift` + `D`
Open the Tools menu	Windows`Alt` + `T` macOS`Ctrl` + `Option` + `T` Linux`Alt` + `Shift` + `T`
Open the Sheet menu	Windows / Linux`Alt` + `Shift` + `S` macOS`Option` + `Shift` + `S`
Open the context menuShift+F10 is also documented.	Windows / Linux`Ctrl` + `Shift` + `\` macOS`Cmd` + `Shift` + `\`
Open the insert menu for selected cells	Windows / Linux`Ctrl` + `Alt` + `=` macOS`Cmd` + `Option` + `=`
Open the delete menu for selected cells	Windows / Linux`Ctrl` + `Alt` + `-` macOS`Cmd` + `Option` + `-`
Insert rows aboveWith rows selected, Chrome also supports Alt+I, R, R; other browsers use Alt+Shift+I, R, R.	Windows / Linux`Ctrl` + `Alt` + `=` macOS`Cmd` + `Option` + `=`
Insert rows below	Windows`Alt` + `I` then `R` then `B` macOS`Ctrl` + `Option` + `I` then `R` then `B` Linux`Alt` + `Shift` + `I` then `R` then `B`
Insert columns to the left	Windows / Linux`Ctrl` + `Alt` + `=` macOS`Cmd` + `Option` + `=`
Insert columns to the right	Windows`Alt` + `I` then `C` then `O` macOS`Ctrl` + `Option` + `I` then `C` then `O` Linux`Alt` + `Shift` + `I` then `C` then `O`
Delete selected rows	Windows / Linux`Ctrl` + `Alt` + `-` macOS`Cmd` + `Option` + `-`
Delete selected columns	Windows / Linux`Ctrl` + `Alt` + `-` macOS`Cmd` + `Option` + `-`
Hide the selected row	Windows / Linux`Ctrl` + `Alt` + `9` macOS`Cmd` + `Option` + `9`
Unhide the selected row	Windows / Linux`Ctrl` + `Shift` + `9` macOS`Cmd` + `Shift` + `9`
Hide the selected column	Windows / Linux`Ctrl` + `Alt` + `0` macOS`Cmd` + `Option` + `0`
Unhide the selected column	Windows / Linux`Ctrl` + `Shift` + `0` macOS`Cmd` + `Shift` + `0`
Group rows or columns	Windows / Linux`Alt` + `Shift` + `Right` macOS`Option` + `Shift` + `Right`
Ungroup rows or columns	Windows / Linux`Alt` + `Shift` + `Left` macOS`Option` + `Shift` + `Left`
Expand grouped rows or columns	Windows / Linux`Alt` + `Shift` + `Down` macOS`Option` + `Shift` + `Down`
Collapse grouped rows or columns	Windows / Linux`Alt` + `Shift` + `Up` macOS`Option` + `Shift` + `Up`

Formulas and accessibility

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

Action	Shortcuts
Show all formulas	Windows / macOS / Linux`Ctrl` + `~`
Insert an array formula	Windows / Linux`Ctrl` + `Shift` + `Enter` macOS`Cmd` + `Shift` + `Enter`
Collapse an expanded array formula	Windows / Linux`Ctrl` + `E` macOS`Cmd` + `E`
Show or hide formula help	Windows / Linux`Shift` + `F1` macOS`Shift` + `Fn` + `F1`
Toggle full or compact formula help	Windows / Linux`F1` macOS`Fn` + `F1`
Cycle absolute and relative references	Windows / Linux`F4` macOS`Fn` + `F4`
Toggle formula result previews	Windows / Linux`F9` macOS`Fn` + `F9`
Move up or down in the formula barUse the corresponding down key to move down.	Windows / Linux`Ctrl` + `Up` macOS`Ctrl` + `Option` + `Up`
Toggle formula range selection	Windows / macOS / Linux`F2`
Turn on screen-reader support	Windows / Linux`Ctrl` + `Alt` + `Z` macOS`Cmd` + `Option` + `Z`
Enable braille support	Windows / Linux`Ctrl` + `Alt` + `H` macOS`Cmd` + `Option` + `H`
Read the current column	Windows / Linux`Ctrl` + `Alt` + `Shift` + `C` macOS`Cmd` + `Option` + `Shift` + `C`
Read the current row	Windows / Linux`Ctrl` + `Alt` + `Shift` + `R` macOS`Cmd` + `Option` + `Shift` + `R`

Source

official Google Sheets keyboard shortcuts · Checked Aug 26, 2026

Google's official Google Sheets Help page checked in August 2026. Google labels Windows and ChromeOS as PC; Linux browsers generally use the same PC Ctrl and Alt bindings, while browser language, keyboard layout, and compatible spreadsheet shortcuts can change behavior.

Print the shortcuts you use

Make a printable Google Sheets sheet