Google Sheets is the go-to spreadsheet tool for anyone who doesn’t want to use Microsoft Excel. While the menus at the top offer most of the functions at your fingertips, there’s no doubt that keyboard shortcuts will save you time. Whether your device uses Windows, macOS, or ChromeOS, this list of Google Sheets keyboard shortcuts can help boost your productivity so you can become a spreadsheets master.
Download this Cheatsheet
Enter your email below to receive this PDF cheatsheet in your Inbox.
Apart from the below-mentioned keyboard shortcuts, you can also use keyboard shortcuts made by other apps/companies in Google Sheets. To do so, go to Help → Keyboard shortcuts (or use Ctrl +/) shortcut and then turn on Enable compatible spreadsheet shortcuts.
| Windows | macOS | ChromeOS | Function |
|---|---|---|---|
| Menus | |||
| Alt + F or Alt + Shift + F | Ctrl + Option + F | Alt + F | Open the File menu. |
| Alt + E or Alt + Shift + E | Ctrl + Option + E | Alt + E | Open the Edit menu. |
| Alt + V or Alt + Shift + V | Ctrl + Option + V | Alt + V | Open the View menu. |
| Alt + I or Alt + Shift + I | Ctrl + Option + I | Alt + I | Open the Insert menu. |
| Alt + O or Alt + Shift + O | Ctrl + Option + O | Alt + O | Open the Format menu. |
| Alt + D or Alt + Shift + D | Ctrl + Option + D | Alt + D | Open the Data menu. |
| Alt + T or Alt + Shift + T | Ctrl + Option + T | Alt + T | Open the Tools menu. |
| Ctrl + Alt + Equal Sign (=) | Command + Option + Equal Sign (=) | Ctrl + Alt + Equal Sign (=) | Open the Insert menu with cells selected. |
| Ctrl + Alt + Minus Sign (-) | Command + Option + Minus Sign (-) | Ctrl + Alt + Minus Sign (-) | Open the Delete menu with cells selected. |
| Alt + M or Alt + Shift + M | Ctrl + Option + M | Alt + M | Form menu (present when the spreadsheet is connected to a form). |
| Alt + N or Alt + Shift + N | Ctrl + Option + N | Alt + N | Open the Add-ons menu. |
| Alt + H | Ctrl + Option + H | Alt + H | Open the Help menu. |
| Alt + A | Ctrl + Option + A | Alt + A | Open the Accessibility menu (present when screen reader support is enabled). |
| Alt + Shift + S | Option + Shift + S | Ctrl + Shift + S | Open the Sheet menu (copy, delete, and other sheet actions). |
| Ctrl + Shift + \ or Shift + F10 | Command + Shift + \ or Shift + F10 | Ctrl + Shift + \ or Shift + F10 | Open the Context menu. |
| Alt + / | Option + / | Alt + / | Search the menus. |
| Common Actions | |||
| Ctrl + Space | Ctrl + Space | Ctrl + Space | Select column. |
| Shift + Space | Shift + Space | Shift + Space | Select row. |
| Ctrl + A or Ctrl + Shift + Space | Command + A or Command + Shift + Space | Ctrl + A | Select all. |
| Ctrl + Z | Command + Z | Ctrl + Z | Perform undo action. |
| Ctrl + Y or Ctrl + Shift + Z or F4 | Command + Y or Command + Shift + Z or Fn + F4 | Ctrl + Y or Ctrl + Shift + Z | Redo any action. |
| Ctrl + F | Command + F | Ctrl + F | Find in Google Sheets. |
| Ctrl + H | Command + Shift + H | Ctrl + H | Find and replace. |
| Ctrl + Enter | Command + Enter | Ctrl + Enter | Fill range. |
| Ctrl + D | Command + D | Ctrl + D | Fill down. |
| Ctrl + R | Command + R | Ctrl + R | Fill right. |
| Ctrl + S | Command + S | Ctrl + S | Save manually. |
| Ctrl + O | Command + O | Ctrl + O | Open new sheet. |
| Ctrl + P | Command + P | Ctrl + P | Print sheet. |
| Ctrl + C | Command + C | Ctrl + C | Copy selected data. |
| Ctrl + X | Command + X | Ctrl + X | Cut selected data. |
| Ctrl + V | Command + V | Ctrl + V | Paste selected data. |
| Ctrl + Shift + V | Command + Shift + V | Ctrl + Shift + V | Paste values only. |
| Ctrl + Slash ( / ) | Command + Slash ( / ) | Ctrl + Slash ( / ) | Show available keyboard shortcuts. |
| Shift + F11 | Shift + Fn + F11 | Insert new sheet. | |
| Ctrl + Shift + F | Ctrl + Shift + F | Ctrl + Shift + F | Compact controls. |
| Ctrl + Shift + K | Command + Shift + K | Ctrl + Shift + K | Input tools on/off (available in spreadsheets in non-Latin languages). |
| Ctrl + Alt + Shift + K | Command + Option + Shift + K | Ctrl + Alt + Shift + K | Select input tools. |
| Format Cells | |||
| Ctrl + B | Command + B | Ctrl + B | Bold the text. |
| Ctrl + U | Command + U | Ctrl + U | Underline the text. |
| Ctrl + I | Command + I | Ctrl + I | Italicize the text. |
| Alt + Shift + 5 | Option + Shift + 5 | Alt + Shift + 5 | Strikethrough. |
| Ctrl + Shift + E | Command + Shift + E | Ctrl + Shift + E | Center align. |
| Ctrl + Shift + l | Command + Shift + l | Ctrl + Shift + l | Left align. |
| Ctrl + Shift + R | Command + Shift + R | Ctrl + Shift + R | Right align. |
| Alt + Shift + 1 | Option + Shift + 1 | Alt + Shift + 1 | Apply top border. |
| Alt + Shift + 2 | Option + Shift + 2 | Alt + Shift + 2 | Apply right border. |
| Alt + Shift + 3 | Option + Shift + 3 | Alt + Shift + 3 | Apply bottom border. |
| Alt + Shift + 4 | Option + Shift + 4 | Alt + Shift + 4 | Apply left border. |
| Alt + Shift + 6 | Option + Shift + 6 | Alt + Shift + 6 | Remove borders. |
| Alt + Shift + 7 or Ctrl + Shift + 7 | Option + Shift + 7 or Command + Shift + 7 | Alt + Shift + 7 or Ctrl + Shift + 7 | Apply outer border. |
| Insert or Format | |||
| Ctrl + K | Command + K | Ctrl + K | Insert link. |
| Ctrl + Shift + Semicolon ( ; ) | Command + Shift + Semicolon ( ; ) | Ctrl + Shift + Semicolon ( ; ) | Insert time. |
| Ctrl + Semicolon ( ; ) | Command + Semicolon ( ; ) | Ctrl + Semicolon ( ; ) | Insert date. |
| Ctrl + Alt + Shift + Semicolon ( ; ) | Command + Option + Shift + Semicolon ( ; ) | Ctrl + Alt + Shift + Semicolon ( ; ) | Insert date and time. |
| Ctrl + Shift + 1 | Ctrl + Shift + 1 | Ctrl + Shift + 1 | Format as decimal. |
| Ctrl + Shift + 2 | Ctrl + Shift + 2 | Ctrl + Shift + 2 | Format as time. |
| Ctrl + Shift + 3 | Ctrl + Shift + 3 | Ctrl + Shift + 3 | Format as date. |
| Ctrl + Shift + 4 | Ctrl + Shift + 4 | Ctrl + Shift + 4 | Format as currency. |
| Ctrl + Shift + 5 | Ctrl + Shift + 5 | Ctrl + Shift + 5 | Format as percentage. |
| Ctrl + Shift + 6 | Ctrl + Shift + 6 | Ctrl + Shift + 6 | Format as exponent. |
| Ctrl + Slash ( \ ) | Command + Slash ( \ ) | Ctrl + Slash ( \ ) | Clear formatting. |
| Navigate | . | ||
| Home | Fn + Left Arrow | Search + Left Arrow | Move to the beginning of a row. |
| Ctrl + Home | Command + Fn + Left Arrow | Ctrl + Search + Left Arrow | Move to the beginning of a sheet. |
| End | Fn + Right Arrow | Search + Right Arrow | Move to the end of a row. |
| Ctrl + End | Command + Fn + Right Arrow | Ctrl + Search + Right Arrow | Move to the end of a sheet. |
| Ctrl + Backspace | Command + Backspace | Ctrl + Backspace | Scroll to the active cell. |
| Alt + Down Arrow | Option + Down Arrow | Ctrl + Shift + Search + Down Arrow | Move to the next sheet. |
| Alt + Up Arrow | Option + Up Arrow | Ctrl + Shift + Search + Up Arrow | Move to the previous sheet. |
| Alt + Shift + K | Option + Shift + K | Alt + Shift + K | Display the list of sheets. |
| Alt + Enter | Option + Enter | Alt + Enter | Open hyperlink. |
| Alt + Shift + X | Option + Shift + X | Alt + Shift + X | Open Explore. |
| Ctrl + Alt + Period | Command + Option + Period | Alt + Shift + Period | Go to the side panel. |
| Ctrl + Alt + Shift + M | Ctrl + Command + Shift + M | Ctrl + Alt + Shift + M | Move focus out of the spreadsheet. |
| Alt + Shift + Q | Option + Shift + Q | Alt + Shift + Q | Move to quick sum (when a range of cells is selected). |
| Hold Ctrl + Alt, press E, then P | Hold Ctrl + Command, press E, then P | Hold Ctrl + Alt, press E, then P | Move focus to a popup (for links, bookmarks, and images). |
| Ctrl + Alt + R | Ctrl + Command + R | Ctrl + Alt + R | Open the drop-down menu on a filtered cell. |
| Ctrl + Alt + Shift + H | Command + Option + Shift + H | Ctrl + Alt + Shift + H | Open revision history. |
| Shift + Esc | Command + Esc | Ctrl + Esc | Close drawing editor. |
| Edit Notes and Comments | |||
| Shift + F2 | Shift + F2 | Shift + Search + 2 | Insert/edit note. |
| Ctrl + Alt + M | Command + Option + M | Ctrl + Alt + M | Insert/edit comment. |
| Ctrl + Alt + Shift + A | Command + Option + Shift + A | Ctrl + Alt + Shift + A | Open comment discussion thread. |
| Hold Ctrl + Alt, press E, then C | Hold Ctrl + Command, press E, then C | Hold Ctrl + Alt, press E, then C | Enter a comment. |
| Hold Ctrl + Alt, press N, then C | Hold Ctrl + Command, press N, then C | Hold Ctrl + Alt, press N, then C | Move to the next comment. |
| Hold Ctrl + Alt, press C, then C | Hold Ctrl + Command, press P, then C | Hold Ctrl + Alt, press P, then C | Move to the previous comment. |
| R | R | R | Reply to the current comment. |
| J | J | J | Move to the next comment. |
| K | K | K | Move to the previous comment. |
| E | E | E | Resolve the current comment. |
| U | U | U | Exit current comment. |
| Add or Change Rows and Columns | |||
| Alt + I, then R | Ctrl + Option + I, then R | Alt + I, then R | Insert rows above. |
| Ctrl + Alt + Equal (=) | Command + Option + Equal (=) | Ctrl + Alt + Equal (=) | Insert rows above (with rows selected). |
| Alt + I, then w or Alt + Shift + I, then W | Ctrl + Option + I, then B | Alt + I, then W | Insert rows below. |
| Alt + I, then C | Ctrl + Option + I, then C | Alt + I, then C | Insert columns to the left. |
| Ctrl + Alt + = | Command + Option + = | Ctrl + Alt + = | Insert columns to the left (with columns selected). |
| Alt + I, then O | Ctrl + Option + I, then O | Alt + I, then O | Insert columns to the right. |
| Ctrl + Alt + Minus (-) | Command + Option + Minus (-) | Ctrl + Alt + Minus (-) | Delete rows (with rows selected). |
| Alt + E, then D | Ctrl + Option + E, then D | Alt + E, then D | Delete rows. |
| Ctrl + Alt + Minus (-) | Command + Option + Minus (-) | Ctrl + Alt + Minus (-) | Delete columns (with columns selected). |
| Alt + E, then E | Ctrl + Option + E, then E | Alt + E, then E | Delete columns. |
| Ctrl + Alt + 9 | Command + Option + 9 | Ctrl + Alt + 9 | Hide row. |
| Ctrl + Shift + 9 | Command + Shift + 9 | Ctrl + Shift + 9 | Unhide row. |
| Ctrl + Alt + 0 | Command + Option + 0 | Ctrl + Alt + 0 | Hide column. |
| Ctrl + Shift + 0 | Command + Shift + 0 | Ctrl + Shift + 0 | Unhide column. |
| Alt + Shift + Right Arrow | Option + Shift + Right Arrow | Alt + Shift + Right Arrow | Group rows or columns. |
| Alt + Shift + Left Arrow | Option + Shift + Left Arrow | Alt + Shift + Left Arrow | Ungroup rows or columns. |
| Alt + Shift + Down Arrow | Option + Shift + Down Arrow | Alt + Shift + Down Arrow | Expand grouped rows or columns. |
| Alt + Shift + Up Arrow | Option + Shift + Up Arrow | Alt + Shift + Up Arrow | Collapse grouped rows or columns. |
| Use Formulas | |||
| Ctrl + Tilde (~) | Ctrl + Tilde (~) | Ctrl + Tilde (~) | Show all formulas. |
| Ctrl + Shift + Enter | Command + Shift + Enter | Ctrl + Shift + Enter | Insert array formula. |
| Ctrl + E | Command + E | Ctrl + E | Collapse an expanded array formula. |
| Shift + F1 | Shift + Fn + F1 | Shift + Search + 1 | Show/hide formula help (when entering a formula). |
| F1 | Fn + F1 | Search + 1 | Full/compact formula help (when entering a formula). |
| F4 | Fn + F4 | Search + 9 | Absolute/relative references (when entering a formula). |
| F9 | Fn + F9 | Toggle formula result previews (when entering a formula). | |
| Ctrl + Up or Ctrl + Down | Ctrl + Option + Up or Ctrl + Option + Down | Resize the formula bar (move up or down). | |
| Help for Screen Readers | |||
| Ctrl + Alt + Z | Command + Option + Z | Ctrl + Alt + Z | Turn on screen reader support. |
| Ctrl + Alt + H | Command + Option + H | Ctrl + Alt + H | Enable braille support. |
| Ctrl + Alt + Shift + C | Command + Option + Shift + C | Ctrl + Alt + Shift + C | Read column. |
| Ctrl + Alt + Shift + R | Command + Option + Shift + R | Ctrl + Alt + Shift + R | Read row. |
Subscribe to our newsletter!
Our latest tutorials delivered straight to your inbox
