Google Sheets Keyboard Shortcuts
Common actions
| control + space | Select column |
| shift + space | Select row |
| command + shift + space | Select all |
| command + z | Undo |
| command + shift + z or command + y | Redo |
| command + f | Find |
| command + shift + h | Find and replace |
| command + enter | Fill range |
| command + d | Fill down |
| command + r | Fill right |
| command + s | Save |
| command + o | Open |
| command + p | |
| command + c | Copy |
| command + x | Cut |
| command + v | Paste |
| command + shift + v | Paste values only |
| command + / | Show common keyboard shortcuts |
| control + shift + f | Compact controls |
| command + shift + k | Input tools on/off (available in spreadsheets in non-Latin languages) |
| command + option + shift + k | Select input tools |
| option + / | Search the menus |
Format cells
| command + b | Bold |
| command + u | Underline |
| command + i | Italic |
| option + shift + 5 | Strikethrough |
| command + shift + e | Center align |
| command + shift + l | Left align |
| command + shift + r | Right align |
| option + shift + 1 | Apply top border |
| option + shift + 2 | Apply right border |
| option + shift + 3 | Apply bottom border |
| option + shift + 4 | Apply left border |
| option + shift + 6 | Remove borders |
| option + shift + 7 or command + shift + 7 | Apply outer border |
| command + k | Insert link |
| command + shift + ; | Insert time |
| command + ; | Insert date |
| command + option + shift + ; | Insert date and time |
| control + shift + 1 | Format as decimal |
| control + shift + 2 | Format as time |
| control + shift + 3 | Format as date |
| control + shift + 4 | Format as currency |
| control + shift + 5 | Format as percentage |
| control + shift + 6 | Format as exponent |
| command + \ | Clear formatting |
Navigate spreadsheet
| fn + left | Move to beginning of row |
| command + fn + left | Move to beginning of sheet |
| fn + right | Move to end of row |
| command + fn + right | Move to end of sheet |
| command + backspace | Scroll to active cell |
| option + down | Move to next sheet |
| option + up | Move to previous sheet |
| option + shift + k | Display list of sheets |
| option + enter | Open hyperlink |
| option + shift + x | Open Explore |
| command + option + , | Go to side panel |
| control + command + shift + m | Move focus out of spreadsheet |
| option + shift + q | Move to quicksum (when a range of cells is selected) |
| holding control + command , press e then p | Move focus to popup (for links, bookmarks, and images) |
| control + command + r | Open drop-down menu on filtered cell |
| command + option + shift + h | Open revision history |
| shift + escape | Open chat inside the spreadsheet |
| command + escape or shift + escape | Close drawing editor |
Edit notes and comments
| shift + f2 | Insert/edit note |
| command + option + m | Insert/edit comment |
| command + option + shift + a | Open comment discussion thread |
| holding control + command , press e then c | Enter current comment |
| holding control + command , press n then c | Move to next comment |
| holding control + command , press p then c | Move to previous comment |
Open a menu
| control + option + f | File menu |
| control + option + e | Edit menu |
| control + option + v | View menu |
| control + option + i | Insert menu |
| control + option + o | Format menu |
| control + option + d | Data menu |
| control + option + t | Tools menu |
| command + option + = with cells selected | Open insert menu |
| command + option + - with cells selected | Open delete menu |
| control + option + m | Form menu (present when the spreadsheet is connected to a form) |
| control + option + n | Add-ons menu |
| control + option + h | Help menu |
| control + option + a | Accessibility menu (present when screen reader support is enabled) |
| option + shift + s | Sheet menu (copy, delete, and other sheet actions) |
| command + shift + \ | Context menu |
Add or change rows and columns
| command + option + = with rows selected/ctrl+opt+i r | Insert rows above |
| control + option + i then b | Insert rows below |
| command + option + = with columns selected/ctrl+opt+i c | Insert columns to the left |
| control + option + i then o | Insert columns to the right |
| command + option + - | Delete rows |
| command + option + - | Delete columns |
| command + option + 9 | Hide row |
| command + option + 0 | Hide column |
| option + shift + right | Group rows or columns |
| option + shift + left | Ungroup rows or columns |
| option + shift + down | Expand grouped rows or columns |
| option + shift + up | Collapse grouped rows or columns |
Use formulas
| control + ~ | Show all formulas |
| command + shift + enter | Insert array formula |
| command + e | Collapse an expanded array formula |
| shift + fn + f1 | Show/hide formula help (when entering a formula) |
| fn + f1 | Full/compact formula help (when entering a formula) |
| fn + f4 | Absolute/relative references (when entering a formula) |
| fn + f9 | Toggle formula result previews (when entering a formula) |
| control + option + up or control + option + down | Resize formula bar (move up or down) |
Help for screen readers
| command + option + z | Turn on screen reader support |
| command + option + shift + c | Read column |
| command + option + shift + r | Read row |