Prepare Google Sheets The go-to spreadsheet tool for anyone who doesn't want to use Microsoft ExcelWhile the menus at the top provide most of the functionality 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 keyboard shortcuts will help. Google Sheets It can help increase your productivity so you can become a spreadsheet expert.
Aside from the keyboard shortcuts mentioned below, you can also use keyboard shortcuts created by other apps/companies in Google Sheets. To do this, go to Help → Keyboard Shortcuts (or use the Ctrl+/ shortcut) and then turn on Enable compatible spreadsheet shortcuts.
| Windows | MacOS | ChromeOS | Occupation |
|---|---|---|---|
| Lists | |||
| 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 the selected cells. |
| 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. |
| Joint actions | |||
| Ctrl + Space | Ctrl + Space | Ctrl + Space | Select a column. |
| Shift + Space | Shift + Space | Shift + Space | Select a row. |
| Ctrl + A or Ctrl + Shift + Space |
Command + A or Command + Shift + Space | Ctrl + A | Select all. |
| Ctrl + Z | Command + Z | Ctrl + Z | Perform the rollback action. |
| Ctrl + Y or Ctrl + Shift + Z or F4 |
Cmd+Y Or Command + Shift + Z or Fn + F4 |
Ctrl + Y or Ctrl + Shift + Z |
Re-perform any action. |
| Ctrl + F | Command + F | Ctrl + F | Search Google Sheets. |
| Ctrl + H | Command + Shift + H | Ctrl + H | Search and replace. |
| Ctrl + Enter | Command+Enter | Ctrl + Enter | Filling 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 a new sheet. |
| Ctrl + P | Command+P | Ctrl + P | Print the paper. |
| Ctrl + C | Command + C | Ctrl + C | Copy the selected data. |
| Ctrl + X | Command + X | Ctrl + X | Cut the selected data. |
| Ctrl + V | Command + V | Ctrl + V | Paste the 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 a new sheet. | |
| Ctrl + Shift + F | Ctrl + Shift + F | Ctrl + Shift + F | Compact controls. |
| Ctrl + Shift + K | Command + Shift + K | Ctrl + Shift + K | Turn on/off input tools (available in non-Latin spreadsheets). |
| Ctrl + Alt + Shift + K | Command + Option + Shift + K | Ctrl + Alt + Shift + K | Select Input Tools. |
| Cell formatting | |||
| Ctrl + B | Command+B | Ctrl + B | Bold text. |
| Ctrl + U | Command+U | Ctrl + U | Underline the text. |
| Ctrl + I | Cmd + I | Ctrl + I | Make text italic. |
| Alt+Shift+5 | Option+Shift+5 | Alt+Shift+5 | Lined through it. |
| Ctrl+Shift+E | Command + Shift + E | Ctrl+Shift+E | in the middle. |
| Ctrl + Shift + l | Command + Shift + l | Ctrl + Shift + l | Align left. |
| Ctrl+Shift+R | Command+Shift+R | Ctrl+Shift+R | Right align. |
| Alt+Shift+1 | Option+Shift+1 | Alt+Shift+1 | Apply upper limit. |
| Alt+Shift+2 | Option+Shift+2 | Alt+Shift+2 | Apply the right limit. |
| Alt+Shift+3 | Option+Shift+3 | Alt+Shift+3 | Apply the bottom border. |
| Alt+Shift+4 | Option+Shift+4 | Alt+Shift+4 | Apply the 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 the outer limit. |
| Insert or format | |||
| Ctrl + K | Command+K | Ctrl + K | Insert link. |
| Ctrl + Shift + Semicolon ( ; ) | Command + Shift + Semicolon ( ; ) | Ctrl + Shift + Semicolon ( ; ) | Enter the time. |
| Ctrl + semicolon ( ; ) | Command + semicolon ( ; ) | Ctrl + semicolon ( ; ) | Enter the date. |
| Ctrl + Alt + Shift + Semicolon ( ; ) | Command + Option + Shift + Semicolon ( ; ) | Ctrl + Alt + Shift + Semicolon ( ; ) | Enter the date and time. |
| Ctrl + Shift + 1 | Ctrl + Shift + 1 | Ctrl + Shift + 1 | Format as a decimal number. |
| 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 a percentage. |
| Ctrl + Shift + 6 | Ctrl + Shift + 6 | Ctrl + Shift + 6 | Exponential format. |
| Ctrl + Slash ( \ ) | Command + Slash ( \ ) | Ctrl + Slash ( \ ) | Clear format. |
| Mobility | . | ||
| Home | Fn + Left Arrow | Search + Left Arrow | Move to the beginning of the row. |
| Ctrl + Home | Command + Fn + Left Arrow | Ctrl + Search + Left Arrow | Move to the beginning of the page. |
| End | Fn + Right Arrow | Search + Right Arrow | Move to the end of the row. |
| Ctrl + End | Command + Fn + Right Arrow | Ctrl + Search + Right Arrow | Move to the end of the paper. |
| 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 | Go to the previous sheet. |
| Alt + Shift + K | Option + Shift + K | Alt + Shift + K | Show 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 outside the spreadsheet. |
| Alt + Shift + Q | Option + Shift + Q | Alt + Shift + Q | Switch 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 window (for links, bookmarks, images). |
| Ctrl+Alt+R | Ctrl + Command + R | Ctrl+Alt+R | Open the drop-down list in a filtered cell. |
| Ctrl+Alt+Shift+H | Command + Option + Shift + H | Ctrl+Alt+Shift+H | Open review history. |
| Shift+Esc | Command + Esc | Ctrl + Esc | Close the 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 a 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 | Go 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 | Go to previous comment. |
| R | R | R | Reply to the current comment. |
| J | J | J | Go to the next comment. |
| K | K | K | Go to previous comment. |
| E | E | E | Solve the current comment. |
| U | U | U | Exit the current comment. |
| Add or change rows and columns | |||
| Alt + I, then R | Ctrl + Option + I, then R | Alt + I, then R | Enter the rows above. |
| Ctrl + Alt + Equal (=) | Command + Option + Equal (=) | Ctrl + Alt + Equal (=) | Insert rows above (select rows). |
| Alt + I, then W or Alt + Shift + I, then W | Ctrl + Option + I, then B | Alt + I, then W | Enter the 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 | Enter the columns on 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 | Show row. |
| Ctrl+Alt+0 | Command + Option + 0 | Ctrl+Alt+0 | Hide column. |
| Ctrl + Shift + 0 | Command + Shift + 0 | Ctrl + Shift + 0 | Show 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 the 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 formats. |
| Ctrl + Shift + Enter | Command + Shift + Enter | Ctrl + Shift + Enter | Enter an array formula. |
| Ctrl + E | Command + E | Ctrl + E | Collapse an expanded array formula. |
| Shift + F1 | Shift+Fn+F1 | Shift + Search + 1 | Show/hide formula instructions (when entering a formula). |
| F1 | Fn + F1 | Search + 1 | Full/Combined Formula Instructions (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). | |
| Instructions 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 | Activate Braille support. |
| Ctrl + Alt + Shift + C | Command + Option + Shift + C | Ctrl + Alt + Shift + C | Read the column. |
| Ctrl+Alt+Shift+R | Command + Option + Shift + R | Ctrl+Alt+Shift+R | Read the class. |
