Google Sheets Keyboard Shortcuts
Kieran Dixon
Updated: June 21, 2021
Updated: June 21, 2021 Below is a complete list of all documented Google Sheets keyboard shortcuts (also known as hotkeys) for Windows and Mac.
Using shortcuts helps to reduce your reliance on the mouse and increase your efficiency.
Have fun!
Compatible shortcuts must be enabled before you can use them:
Open the Keyboard shortcuts menu by going to ➜ or use the keyboard shortcut (how meta) Ctrl+/ (for Windows) or ⌘+/ (for Mac).
Then toggle 'Enable compatible spreadsheet shortcuts':
When a shortcut uses the plus sign (+) the keys must be pressed at the same time:
⌘+Shift+Y means press all three simultaneously.
When a shortcut uses a comma (,) the keys must be pressed consecutively:
Alt+H,C,C means hold Alt (the whole time) and press H, C, C one after the other.
| A | B | C | D | |
| 1 | Description | Windows | Mac | Category |
| 2 | Absolute/relative references (when entering a formula) | F4 | F4 | Editing |
| 3 | Accept smart fill suggestion | Ctrl+Shift+Y | ⌘+Shift+Y | Editing |
| 4 | Copy | Ctrl+C or Ctrl+InsertAlt+H,C,C or Alt+E,C | ⌘C | Editing |
| 5 | Cut | Ctrl+X or Shift+DeleteAlt+H,X or Alt+E,T | ⌘X | Editing |
| 6 | Define word | Ctrl+Shift+Y | ⌘+Shift+Y | Editing |
| 7 | Delete rows/columns or open delete menu | Ctrl+Alt+-Ctrl+- or Alt+H,D,D | ⌘+Option+-⌘+- | Editing |
| 8 | Edit description | Ctrl+Shift+E | ⌘+Shift+E | Editing |
| 9 | Fill down | Ctrl+DAlt+H,F,I,D or Alt+E,I,D | ⌘D | Editing |
| 10 | Fill range | Ctrl+Enter | ⌘+Enter | Editing |
| 11 | Fill right | Ctrl+RAlt+H,F,I,R or Alt+E,I,R | ⌘R | Editing |
| 12 | Group | Alt+Shift+→Alt+A,G or Alt+D,G,G | Option+Shift+→ | Editing |
| 13 | Input tools on/off | Ctrl+Shift+K | ⌘+Shift+K | Editing |
| 14 | Insert array formula | Ctrl+Shift+Enter | ⌘+Shift+Enter | Editing |
| 15 | Insert current date | Ctrl+; | ⌘+; | Editing |
| 16 | Insert current date and time | Ctrl+Alt+Shift+; | ⌘+Option+Shift+; | Editing |
| 17 | Insert current time | Ctrl+Shift+; | ⌘+Shift+; | Editing |
| 18 | Insert link | Ctrl+KAlt+N,I or Alt+I,I or Alt+I,K | ⌘K | Editing |
| 19 | Insert new sheet | Shift+F11Alt+Shift+F1 or Alt+H,I,S or Alt+I,W or Alt+I,S | Shift+F11Option+Shift+F1 | Editing |
| 20 | Insert rows/columns or open insert menu | Ctrl+Alt+Shift+= or Ctrl+Alt+=Ctrl+Shift+= or Ctrl+= or Alt+H,I,I or Alt+I,E | ⌘+Option+Shift+= or ⌘+Option+=⌘+Shift+= or ⌘+= | Editing |
| 21 | Insert/edit note | Shift+F2 | Shift+F2 | Editing |
| 22 | Open link | Alt+Enter | Option+Enter | Editing |
| 23 | Paste | Ctrl+V or Shift+InsertAlt+H,V,P or Alt+E,P | ⌘V | Editing |
| 24 | Paste format only | Ctrl+Alt+VAlt+H,V,R | ⌘+Option+V | Editing |
| 25 | Paste values only | Ctrl+Shift+VAlt+H,V,V | ⌘+Shift+V | Editing |
| 26 | Paste without formatting | Ctrl+Shift+V | ⌘+Shift+V | Editing |
| 27 | Redo | Ctrl+Y or Ctrl+Shift+Z or F4Alt+3 or Alt+E,R | ⌘Y or ⌘+Shift+Z or F4 | Editing |
| 28 | Reject smart fill suggestion | Ctrl+Shift+Alt+D | ⌘+Shift+Option+D | Editing |
| 29 | Select input tools | Ctrl+Alt+Shift+K | ⌘+Option+Shift+K | Editing |
| 30 | Undo | Ctrl+ZAlt+2 or Alt+E,U | ⌘Z | Editing |
| 31 | Ungroup | Alt+Shift+←Alt+A,U or Alt+D,G,U or Alt+D,U | Option+Shift+← | Editing |
| 32 | Paste formula only | Alt+H,V,F | None | Editing |
| 33 | Paste all except borders | Alt+H,V,B or Alt+E,S,B | None | Editing |
| 34 | Paste column widths only | Alt+H,V,W | None | Editing |
| 35 | Paste transposed | Alt+H,V,T or Alt+E,S,E | None | Editing |
| 36 | Text rotation: tilt up | Alt+H,F,Q,O or Alt+O,R,P | None | Editing |
| 37 | Text rotation: tilt down | Alt+H,F,Q,L or Alt+O,R,W | None | Editing |
| 38 | Text rotation: stack vertically | Alt+H,F,Q,V or Alt+O,R,V | None | Editing |
| 39 | Text rotation: rotate up | Alt+H,F,Q,U | None | Editing |
| 40 | Text rotation: rotate down | Alt+H,F,Q,D or Alt+O,R,D | None | Editing |
| 41 | Insert row above | Alt+H,I,R or Alt+I,R | None | Editing |
| 42 | Insert column left | Alt+H,I,C or Alt+I,C | None | Editing |
| 43 | Delete row 17 | Alt+H,D,R or Alt+E,D | None | Editing |
| 44 | Delete column a | Alt+H,D,C | None | Editing |
| 45 | Delete | Alt+H,D,S or Alt+E,L | None | Editing |
| 46 | Delete values | Alt+H,E,C or Alt+E,A,C or Alt+E,V | None | Editing |
| 47 | Clear notes | Alt+H,E,M or Alt+E,A,M | None | Editing |
| 48 | Insert row below | Alt+I,B | None | Editing |
| 49 | Insert cells and shift down | Alt+I,D | None | Editing |
| 50 | Insert column right | Alt+I,O | None | Editing |
| 51 | Insert checkbox | Alt+I,X | None | Editing |
| 52 | Accessibility menu | Alt+Shift+A | Ctrl+Option+A | Menus |
| 53 | Add-ons menu | Alt+Shift+N | Ctrl+Option+N | Menus |
| 54 | Context menu | Ctrl+Shift+\ or Shift+F10 or Ctrl+Shift+X | ⌘+Shift+\ or Shift+F10 | Menus |
| 55 | Data menu | Alt+Shift+D | Ctrl+Option+D | Menus |
| 56 | Display sheet menu | Alt+Shift+S | Option+Shift+S | Menus |
| 57 | Edit menu | Alt+Shift+E | Ctrl+Option+E | Menus |
| 58 | File menu | Alt+Shift+F | Ctrl+Option+F | Menus |
| 59 | Form menu | Alt+Shift+M | Ctrl+Option+M | Menus |
| 60 | Format menu | Alt+Shift+OCtrl+1 | Ctrl+Option+OCtrl+1 | Menus |
| 61 | Help menu | Alt+Shift+H | Ctrl+Option+H | Menus |
| 62 | Insert menu | Alt+Shift+I | Ctrl+Option+I | Menus |
| 63 | Quick access | Alt+. | Option+. | Menus |
| 64 | Search the menus | Alt+/ or Alt+Z | Option+/ or Ctrl+Option+Z | Menus |
| 65 | Show sheet list | Shift+Alt+K | Shift+Option+K | Menus |
| 66 | Tools menu | Alt+Shift+T | Ctrl+Option+T | Menus |
| 67 | View menu | Alt+Shift+V | Ctrl+Option+V | Menus |
| 68 | Align center | Ctrl+Shift+EAlt+H,A,C or Alt+O,A,C | ⌘+Shift+E | Formatting |
| 69 | Align left | Ctrl+Shift+LAlt+H,A,L or Alt+O,A,L | ⌘+Shift+L | Formatting |
| 70 | Align right | Ctrl+Shift+RAlt+H,A,R or Alt+O,A,R | ⌘+Shift+R | Formatting |
| 71 | Apply bottom border | Alt+Shift+3Alt+H,B,O | Option+Shift+3 | Formatting |
| 72 | Apply left border | Alt+Shift+4Alt+H,B,L | Option+Shift+4 | Formatting |
| 73 | Apply outer border | Alt+Shift+7 or Ctrl+Shift+7Alt+H,B,S | Option+Shift+7 or ⌘+Shift+7 | Formatting |
| 74 | Apply right border | Alt+Shift+2Alt+H,B,R | Option+Shift+2 | Formatting |
| 75 | Apply top border | Alt+Shift+1Alt+H,B,P | Option+Shift+1 | Formatting |
| 76 | Bold | Ctrl+BCtrl+2 or Alt+H,1 or Alt+O,B | ⌘B⌘2 | Formatting |
| 77 | Clear formatting | Ctrl+\Alt+H,E,F or Alt+E,A,F | ⌘\ | Formatting |
| 78 | Italic | Ctrl+ICtrl+3 or Alt+H,2 or Alt+O,I | ⌘I⌘3 | Formatting |
| 79 | Number format: currency | Ctrl+Shift+4Alt+O,N,C | Ctrl+Shift+4 | Formatting |
| 80 | Number format: date | Ctrl+Shift+3Alt+O,N,D | Ctrl+Shift+3 | Formatting |
| 81 | Number format: number | Ctrl+Shift+1Alt+H,K or Alt+O,N,N | Ctrl+Shift+1 | Formatting |
| 82 | Number format: percent | Ctrl+Shift+5Alt+H,P or Alt+O,N,P | Ctrl+Shift+5 | Formatting |
| 83 | Number format: scientific | Ctrl+Shift+6Alt+O,N,S | Ctrl+Shift+6 | Formatting |
| 84 | Number format: time | Ctrl+Shift+2Alt+O,N,T | Ctrl+Shift+2 | Formatting |
| 85 | Remove borders | Alt+Shift+6Ctrl+Shift+- or Alt+H,B,N | Option+Shift+6⌘+Shift+- | Formatting |
| 86 | Strikethrough | Alt+Shift+5Ctrl+5 or Alt+O,K | ⌘+Shift+X⌘5 | Formatting |
| 87 | Underline | Ctrl+UCtrl+4 or Alt+H,3,U or Alt+O,U | ⌘U⌘4 | Formatting |
| 88 | Number format: automatic | Ctrl+Shift+` or Alt+O,N,M | ⌘+Shift+` | Formatting |
| 89 | Text align: top | Alt+H,A,T or Alt+O,A,T | None | Formatting |
| 90 | Text align: middle | Alt+H,A,M or Alt+O,A,M | None | Formatting |
| 91 | Text align: bottom | Alt+H,A,B or Alt+O,A,B | None | Formatting |
| 92 | Number format: accounting | Alt+H,A,N or Alt+O,N,A | None | Formatting |
| 93 | Apply all borders | Alt+H,B,A | None | Formatting |
| 94 | Wrap text | Alt+H,W or Alt+O,W,W | None | Formatting |
| 95 | Merge cells horizontally | Alt+H,M,A or Alt+O,M,H | None | Formatting |
| 96 | Merge all cells | Alt+H,M,M or Alt+O,M,A | None | Formatting |
| 97 | Unmerge cells | Alt+H,M,U or Alt+O,M,U | None | Formatting |
| 98 | Increase decimal places | Alt+H,0 | None | Formatting |
| 99 | Decrease decimal places | Alt+H,9 | None | Formatting |
| 100 | Conditional formatting | Alt+H,L or Alt+O,D or Alt+O,F | None | Formatting |
| 101 | Resize row | Alt+H,O,A or Alt+O,R,A | None | Formatting |
| 102 | Resize column | Alt+H,O,I or Alt+O,C,A | None | Formatting |
| 103 | Number format: plain text | Alt+O,N,X | None | Formatting |
| 104 | Number format: financial | Alt+O,N,F | None | Formatting |
| 105 | Number format: currency (rounded) | Alt+O,N,R | None | Formatting |
| 106 | Number format: date time | Alt+O,N,I | None | Formatting |
| 107 | Number format: duration | Alt+O,N,U | None | Formatting |
| 108 | Open data cleanup suggestions | Ctrl+Alt+X | ⌘+Option+X | Data |
| 109 | Insert chart | Alt+F1 or Alt+N,K or Alt+I,H | Option+F1 | Data |
| 110 | Protect sheet | Alt+H,O,P or Alt+R,P or Alt+T,P or Alt+T,T | None | Data |
| 111 | Sort range by column a, a → z | Alt+H,S,S or Alt+D,R | None | Data |
| 112 | Sort range by column a, z → a | Alt+H,S,O or Alt+D,T | None | Data |
| 113 | Sort range | Alt+H,S,U or Alt+D,S | None | Data |
| 114 | Create a filter | Alt+H,S,F or Alt+D,F | None | Data |
| 115 | Insert function: average | Alt+H,U,A or Alt+M,U,A or Alt+I,U,A | None | Data |
| 116 | Insert function: count | Alt+H,U,C or Alt+M,U,C or Alt+I,U,C | None | Data |
| 117 | Insert function: max | Alt+H,U,M or Alt+M,U,M or Alt+I,U,M | None | Data |
| 118 | Insert function: min | Alt+H,U,I or Alt+M,U,I or Alt+I,U,I | None | Data |
| 119 | Insert function: sum | Alt+H,U,S or Alt+M,U,S or Alt+I,U,S | None | Data |
| 120 | Pivot table | Alt+N,V or Alt+D,P | None | Data |
| 121 | Define named range | Alt+M,N or Alt+I,N or Alt+D,N | None | Data |
| 122 | Cleanup suggestions | Alt+A,Y or Alt+D,Y | None | Data |
| 123 | Split text to columns | Alt+A,E or Alt+D,E | None | Data |
| 124 | Remove duplicate rows | Alt+A,M or Alt+D,M | None | Data |
| 125 | Data validation | Alt+A,V or Alt+D,L or Alt+D,V | None | Data |
| 126 | Freeze 1 row | Alt+W,F,R or Alt+V,R,O | None | Data |
| 127 | Freeze 1 column | Alt+W,F,C or Alt+V,R,L | None | Data |
| 128 | Freeze 2 rows | Alt+V,R,W | None | Data |
| 129 | Freeze no rows | Alt+V,R,R | None | Data |
| 130 | Freeze up to current row (17) | Alt+V,R,U | None | Data |
| 131 | Freeze 2 columns | Alt+V,R,M | None | Data |
| 132 | Freeze no columns | Alt+V,R,C | None | Data |
| 133 | Freeze up to current column (a) | Alt+V,R,P | None | Data |
| 134 | Trim whitespace | Alt+D,I | None | Data |
| 135 | Insert comment | Ctrl+Alt+MAlt+R,C or Alt+I,M | ⌘+Option+M | Review |
| 136 | Open comment history | Ctrl+Alt+Shift+AAlt+A,C,O or Alt+R,A or Alt+V,C | ⌘+Option+Shift+A | Review |
| 137 | Spell check | F7 or Alt+R,S or Alt+T,S,S | F7 | Review |
| 138 | Select all | Ctrl+A or Ctrl+Shift+SpaceCtrl+Shift+8 | ⌘A or ⌘+Shift+Space⌘+Shift+8 | Selection |
| 139 | Select column | Ctrl+Space | Ctrl+Space | Selection |
| 140 | Select row | Shift+Space | Shift+Space | Selection |
| 141 | Speak anchor | Ctrl+Alt+A Ctrl+Alt+AAlt+A,C,A | Ctrl+⌘A Ctrl+⌘A | Screen reader support |
| 142 | Speak column | Ctrl+Alt+Shift+CAlt+A,S,L | Ctrl+Option+Shift+C | Screen reader support |
| 143 | Speak comment | Ctrl+Alt+A Ctrl+Alt+CAlt+A,C,C | Ctrl+⌘A Ctrl+⌘C | Screen reader support |
| 144 | Speak row | Ctrl+Alt+Shift+RAlt+A,S,R | Ctrl+Option+Shift+R | Screen reader support |
| 145 | Summarize chart content | Ctrl+Alt+Shift+V | Ctrl+Option+Shift+V | Screen reader support |
| 146 | Toggle screen reader support | Ctrl+Alt+Z | ⌘+Option+Z | Screen reader support |
| 147 | Speak formatting | Alt+A,S,F | None | Screen reader support |
| 148 | Open | Ctrl+OAlt+F,O | ⌘O | File commands |
| 149 | Ctrl+PCtrl+F2 or Alt+F,P | ⌘P⌘+F2 | File commands | |
| 150 | New spreadsheet | Alt+F,N or Alt+W,N | None | File commands |
| 151 | Share | Alt+F,H or Alt+T,B | None | File commands |
| 152 | Spreadsheet settings | Alt+F,T or Alt+F,G | None | File commands |
| 153 | Collapse group | Alt+Shift+↑Alt+A,H or Alt+D,G,H | Option+Shift+↑ | View |
| 154 | Compact controls | Ctrl+Shift+F | Ctrl+Shift+F | View |
| 155 | Expand group | Alt+Shift+↓Alt+A,J or Alt+D,G,S | Option+Shift+↓ | View |
| 156 | Hide columns | Ctrl+Alt+0Ctrl+0 or Alt+H,O,U,C or Alt+O,C,H | ⌘+Option+0⌘0 | View |
| 157 | Hide rows | Ctrl+Alt+9Ctrl+9 or Alt+H,O,U,R or Alt+O,R,H | ⌘+Option+9⌘9 | View |
| 158 | Show all formulas | Ctrl+`Alt+M,H or Alt+V,A | Ctrl+` | View |
| 159 | Unhide columns | Ctrl+Shift+0Alt+H,O,U,L or Alt+O,C,U | ⌘+Shift+0 | View |
| 160 | Unhide rows | Ctrl+Shift+9Alt+H,O,U,O or Alt+O,R,U | ⌘+Shift+9 | View |
| 161 | Full screen | Ctrl+F1 or Alt+V,U | ⌘+F1 | View |
| 162 | Show formula bar | Ctrl+Shift+U or Alt+W,V,F or Alt+V,F | ⌘+Shift+U | View |
| 163 | Hide sheet | Alt+H,O,U,S or Alt+O,H | None | View |
| 164 | Show gridlines | Alt+W,V,G or Alt+V,G | None | View |
| 165 | Enter current comment | Ctrl+Alt+E Ctrl+Alt+CAlt+A,C,E | Ctrl+⌘E Ctrl+⌘C | Navigation |
| 166 | Explore | Ctrl+Alt+Shift+I | ⌘+Option+Shift+I | Navigation |
| 167 | Find | Ctrl+F | ⌘F | Navigation |
| 168 | Find and replace | Ctrl+HAlt+H,F,D,R or Alt+E,E or Alt+E,F | ⌘+Shift+H | Navigation |
| 169 | Focus database pill | Ctrl+Shift+' | ⌘+Shift+' | Navigation |
| 170 | Focus named ranges box | Ctrl+J | ⌘J | Navigation |
| 171 | Focus pill | Ctrl+Shift+' | ⌘+Shift+' | Navigation |
| 172 | Focus pop up | Ctrl+Alt+E Ctrl+Alt+P | Ctrl+⌘E Ctrl+⌘P | Navigation |
| 173 | Focus quicksum | Alt+Shift+Q | Option+Shift+Q | Navigation |
| 174 | Focus smart fill widget | Ctrl+Shift+Alt+' | ⌘+Shift+Option+' | Navigation |
| 175 | Move focus out of editing area | Ctrl+Alt+Shift+M | ⌘+Option+Shift+M | Navigation |
| 176 | Move to beginning of sheet | Ctrl+Home | ⌘+Home | Navigation |
| 177 | Move to end of row | End | End | Navigation |
| 178 | Move to end of sheet | Ctrl+End | ⌘+End | Navigation |
| 179 | Move to next comment | Ctrl+Alt+N Ctrl+Alt+CAlt+A,C,N | Ctrl+⌘N Ctrl+⌘C | Navigation |
| 180 | Move to next edit | Ctrl+Alt+K or Ctrl+Alt+N Ctrl+Alt+R | Ctrl+Option+K or Ctrl+⌘N Ctrl+⌘R | Navigation |
| 181 | Move to next sheet | Ctrl+Shift+Pg-Down or Alt+↓ | ⌘+Shift+Pg-Down or Option+↓ | Navigation |
| 182 | Move to previous comment | Ctrl+Alt+P Ctrl+Alt+CAlt+A,C,P | Ctrl+⌘P Ctrl+⌘C | Navigation |
| 183 | Move to previous edit | Ctrl+Alt+J or Ctrl+Alt+P Ctrl+Alt+R | Ctrl+Option+J or Ctrl+⌘P Ctrl+⌘R | Navigation |
| 184 | Move to previous sheet | Ctrl+Shift+Pg-Up or Alt+↑ | ⌘+Shift+Pg-Up or Option+↑ | Navigation |
| 185 | Move to start of row | Home | Home | Navigation |
| 186 | Open explore | Alt+Shift+X | Option+Shift+X | Navigation |
| 187 | Open filter dropdown menu | Ctrl+Alt+R | Ctrl+⌘R | Navigation |
| 188 | Scroll to active cell | Ctrl+Backspace | ⌘+Backspace | Navigation |
| 189 | See keyboard shortcuts | Ctrl+/ | ⌘/ | Navigation |
| 190 | See version history | Ctrl+Alt+Shift+H | ⌘+Option+Shift+H | Navigation |
| 191 | Select next sheet | Ctrl+Alt+] | ⌘+Option+] | Navigation |
| 192 | Select previous sheet | Ctrl+Alt+[ | ⌘+Option+[ | Navigation |
| 193 | Show live edits | Ctrl+Alt+Shift+R | ⌘+Option+Shift+R | Navigation |
| 194 | Show person or group info | Alt+→ | Option+→ | Navigation |
| 195 | Go to range | F5 or Alt+E,G | F5 | Navigation |
| 196 | Help center | Shift+F1F1 | Shift+F1F1 | Help |
FREE RESOURCE
Google Sheets Cheat Sheet
12 exclusive tips to make user-friendly sheets from today:
You'll get updates from me with an easy-to-find "unsubscribe" link.
Kieran Dixon started using spreadsheets in 2010. He leveled-up his skills working for banks and running his own business. Now he makes Google Sheets and Apps Script more approachable for anyone looking to streamline their business and life.