Google Sheets Cheat Sheet

Google Sheets Keyboard Shortcuts

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 HelpKeyboard shortcuts or use the keyboard shortcut (how meta) Ctrl+/ (for Windows) or ⌘+/ (for Mac).

Then toggle 'Enable compatible spreadsheet shortcuts':

shows how to enable compatibles shortcuts from the keyboard shortcuts menu in google sheets

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.

ABCD
1DescriptionWindowsMacCategory
2Absolute/relative references (when entering a formula)F4F4Editing
3Accept smart fill suggestionCtrl+Shift+Y⌘+Shift+YEditing
4CopyCtrl+C or Ctrl+InsertAlt+H,C,C or Alt+E,C⌘CEditing
5CutCtrl+X or Shift+DeleteAlt+H,X or Alt+E,T⌘XEditing
6Define wordCtrl+Shift+Y⌘+Shift+YEditing
7Delete rows/columns or open delete menuCtrl+Alt+-Ctrl+- or Alt+H,D,D⌘+Option+-⌘+-Editing
8Edit descriptionCtrl+Shift+E⌘+Shift+EEditing
9Fill downCtrl+DAlt+H,F,I,D or Alt+E,I,D⌘DEditing
10Fill rangeCtrl+Enter⌘+EnterEditing
11Fill rightCtrl+RAlt+H,F,I,R or Alt+E,I,R⌘REditing
12GroupAlt+Shift+→Alt+A,G or Alt+D,G,GOption+Shift+→Editing
13Input tools on/offCtrl+Shift+K⌘+Shift+KEditing
14Insert array formulaCtrl+Shift+Enter⌘+Shift+EnterEditing
15Insert current dateCtrl+;⌘+;Editing
16Insert current date and timeCtrl+Alt+Shift+;⌘+Option+Shift+;Editing
17Insert current timeCtrl+Shift+;⌘+Shift+;Editing
18Insert linkCtrl+KAlt+N,I or Alt+I,I or Alt+I,K⌘KEditing
19Insert new sheetShift+F11Alt+Shift+F1 or Alt+H,I,S or Alt+I,W or Alt+I,SShift+F11Option+Shift+F1Editing
20Insert rows/columns or open insert menuCtrl+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
21Insert/edit noteShift+F2Shift+F2Editing
22Open linkAlt+EnterOption+EnterEditing
23PasteCtrl+V or Shift+InsertAlt+H,V,P or Alt+E,P⌘VEditing
24Paste format onlyCtrl+Alt+VAlt+H,V,R⌘+Option+VEditing
25Paste values onlyCtrl+Shift+VAlt+H,V,V⌘+Shift+VEditing
26Paste without formattingCtrl+Shift+V⌘+Shift+VEditing
27RedoCtrl+Y or Ctrl+Shift+Z or F4Alt+3 or Alt+E,R⌘Y or ⌘+Shift+Z or F4Editing
28Reject smart fill suggestionCtrl+Shift+Alt+D⌘+Shift+Option+DEditing
29Select input toolsCtrl+Alt+Shift+K⌘+Option+Shift+KEditing
30UndoCtrl+ZAlt+2 or Alt+E,U⌘ZEditing
31UngroupAlt+Shift+←Alt+A,U or Alt+D,G,U or Alt+D,UOption+Shift+←Editing
32Paste formula onlyAlt+H,V,FNoneEditing
33Paste all except bordersAlt+H,V,B or Alt+E,S,BNoneEditing
34Paste column widths onlyAlt+H,V,WNoneEditing
35Paste transposedAlt+H,V,T or Alt+E,S,ENoneEditing
36Text rotation: tilt upAlt+H,F,Q,O or Alt+O,R,PNoneEditing
37Text rotation: tilt downAlt+H,F,Q,L or Alt+O,R,WNoneEditing
38Text rotation: stack verticallyAlt+H,F,Q,V or Alt+O,R,VNoneEditing
39Text rotation: rotate upAlt+H,F,Q,UNoneEditing
40Text rotation: rotate downAlt+H,F,Q,D or Alt+O,R,DNoneEditing
41Insert row aboveAlt+H,I,R or Alt+I,RNoneEditing
42Insert column leftAlt+H,I,C or Alt+I,CNoneEditing
43Delete row 17Alt+H,D,R or Alt+E,DNoneEditing
44Delete column aAlt+H,D,CNoneEditing
45DeleteAlt+H,D,S or Alt+E,LNoneEditing
46Delete valuesAlt+H,E,C or Alt+E,A,C or Alt+E,VNoneEditing
47Clear notesAlt+H,E,M or Alt+E,A,MNoneEditing
48Insert row belowAlt+I,BNoneEditing
49Insert cells and shift downAlt+I,DNoneEditing
50Insert column rightAlt+I,ONoneEditing
51Insert checkboxAlt+I,XNoneEditing
52Accessibility menuAlt+Shift+ACtrl+Option+AMenus
53Add-ons menuAlt+Shift+NCtrl+Option+NMenus
54Context menuCtrl+Shift+\ or Shift+F10 or Ctrl+Shift+X⌘+Shift+\ or Shift+F10Menus
55Data menuAlt+Shift+DCtrl+Option+DMenus
56Display sheet menuAlt+Shift+SOption+Shift+SMenus
57Edit menuAlt+Shift+ECtrl+Option+EMenus
58File menuAlt+Shift+FCtrl+Option+FMenus
59Form menuAlt+Shift+MCtrl+Option+MMenus
60Format menuAlt+Shift+OCtrl+1Ctrl+Option+OCtrl+1Menus
61Help menuAlt+Shift+HCtrl+Option+HMenus
62Insert menuAlt+Shift+ICtrl+Option+IMenus
63Quick accessAlt+.Option+.Menus
64Search the menusAlt+/ or Alt+ZOption+/ or Ctrl+Option+ZMenus
65Show sheet listShift+Alt+KShift+Option+KMenus
66Tools menuAlt+Shift+TCtrl+Option+TMenus
67View menuAlt+Shift+VCtrl+Option+VMenus
68Align centerCtrl+Shift+EAlt+H,A,C or Alt+O,A,C⌘+Shift+EFormatting
69Align leftCtrl+Shift+LAlt+H,A,L or Alt+O,A,L⌘+Shift+LFormatting
70Align rightCtrl+Shift+RAlt+H,A,R or Alt+O,A,R⌘+Shift+RFormatting
71Apply bottom borderAlt+Shift+3Alt+H,B,OOption+Shift+3Formatting
72Apply left borderAlt+Shift+4Alt+H,B,LOption+Shift+4Formatting
73Apply outer borderAlt+Shift+7 or Ctrl+Shift+7Alt+H,B,SOption+Shift+7 or ⌘+Shift+7Formatting
74Apply right borderAlt+Shift+2Alt+H,B,ROption+Shift+2Formatting
75Apply top borderAlt+Shift+1Alt+H,B,POption+Shift+1Formatting
76BoldCtrl+BCtrl+2 or Alt+H,1 or Alt+O,B⌘B⌘2Formatting
77Clear formattingCtrl+\Alt+H,E,F or Alt+E,A,F⌘\Formatting
78ItalicCtrl+ICtrl+3 or Alt+H,2 or Alt+O,I⌘I⌘3Formatting
79Number format: currencyCtrl+Shift+4Alt+O,N,CCtrl+Shift+4Formatting
80Number format: dateCtrl+Shift+3Alt+O,N,DCtrl+Shift+3Formatting
81Number format: numberCtrl+Shift+1Alt+H,K or Alt+O,N,NCtrl+Shift+1Formatting
82Number format: percentCtrl+Shift+5Alt+H,P or Alt+O,N,PCtrl+Shift+5Formatting
83Number format: scientificCtrl+Shift+6Alt+O,N,SCtrl+Shift+6Formatting
84Number format: timeCtrl+Shift+2Alt+O,N,TCtrl+Shift+2Formatting
85Remove bordersAlt+Shift+6Ctrl+Shift+- or Alt+H,B,NOption+Shift+6⌘+Shift+-Formatting
86StrikethroughAlt+Shift+5Ctrl+5 or Alt+O,K⌘+Shift+X⌘5Formatting
87UnderlineCtrl+UCtrl+4 or Alt+H,3,U or Alt+O,U⌘U⌘4Formatting
88Number format: automaticCtrl+Shift+` or Alt+O,N,M⌘+Shift+`Formatting
89Text align: topAlt+H,A,T or Alt+O,A,TNoneFormatting
90Text align: middleAlt+H,A,M or Alt+O,A,MNoneFormatting
91Text align: bottomAlt+H,A,B or Alt+O,A,BNoneFormatting
92Number format: accountingAlt+H,A,N or Alt+O,N,ANoneFormatting
93Apply all bordersAlt+H,B,ANoneFormatting
94Wrap textAlt+H,W or Alt+O,W,WNoneFormatting
95Merge cells horizontallyAlt+H,M,A or Alt+O,M,HNoneFormatting
96Merge all cellsAlt+H,M,M or Alt+O,M,ANoneFormatting
97Unmerge cellsAlt+H,M,U or Alt+O,M,UNoneFormatting
98Increase decimal placesAlt+H,0NoneFormatting
99Decrease decimal placesAlt+H,9NoneFormatting
100Conditional formattingAlt+H,L or Alt+O,D or Alt+O,FNoneFormatting
101Resize rowAlt+H,O,A or Alt+O,R,ANoneFormatting
102Resize columnAlt+H,O,I or Alt+O,C,ANoneFormatting
103Number format: plain textAlt+O,N,XNoneFormatting
104Number format: financialAlt+O,N,FNoneFormatting
105Number format: currency (rounded)Alt+O,N,RNoneFormatting
106Number format: date timeAlt+O,N,INoneFormatting
107Number format: durationAlt+O,N,UNoneFormatting
108Open data cleanup suggestionsCtrl+Alt+X⌘+Option+XData
109Insert chartAlt+F1 or Alt+N,K or Alt+I,HOption+F1Data
110Protect sheetAlt+H,O,P or Alt+R,P or Alt+T,P or Alt+T,TNoneData
111Sort range by column a, a → zAlt+H,S,S or Alt+D,RNoneData
112Sort range by column a, z → aAlt+H,S,O or Alt+D,TNoneData
113Sort rangeAlt+H,S,U or Alt+D,SNoneData
114Create a filterAlt+H,S,F or Alt+D,FNoneData
115Insert function: averageAlt+H,U,A or Alt+M,U,A or Alt+I,U,ANoneData
116Insert function: countAlt+H,U,C or Alt+M,U,C or Alt+I,U,CNoneData
117Insert function: maxAlt+H,U,M or Alt+M,U,M or Alt+I,U,MNoneData
118Insert function: minAlt+H,U,I or Alt+M,U,I or Alt+I,U,INoneData
119Insert function: sumAlt+H,U,S or Alt+M,U,S or Alt+I,U,SNoneData
120Pivot tableAlt+N,V or Alt+D,PNoneData
121Define named rangeAlt+M,N or Alt+I,N or Alt+D,NNoneData
122Cleanup suggestionsAlt+A,Y or Alt+D,YNoneData
123Split text to columnsAlt+A,E or Alt+D,ENoneData
124Remove duplicate rowsAlt+A,M or Alt+D,MNoneData
125Data validationAlt+A,V or Alt+D,L or Alt+D,VNoneData
126Freeze 1 rowAlt+W,F,R or Alt+V,R,ONoneData
127Freeze 1 columnAlt+W,F,C or Alt+V,R,LNoneData
128Freeze 2 rowsAlt+V,R,WNoneData
129Freeze no rowsAlt+V,R,RNoneData
130Freeze up to current row (17)Alt+V,R,UNoneData
131Freeze 2 columnsAlt+V,R,MNoneData
132Freeze no columnsAlt+V,R,CNoneData
133Freeze up to current column (a)Alt+V,R,PNoneData
134Trim whitespaceAlt+D,INoneData
135Insert commentCtrl+Alt+MAlt+R,C or Alt+I,M⌘+Option+MReview
136Open comment historyCtrl+Alt+Shift+AAlt+A,C,O or Alt+R,A or Alt+V,C⌘+Option+Shift+AReview
137Spell checkF7 or Alt+R,S or Alt+T,S,SF7Review
138Select allCtrl+A or Ctrl+Shift+SpaceCtrl+Shift+8⌘A or ⌘+Shift+Space⌘+Shift+8Selection
139Select columnCtrl+SpaceCtrl+SpaceSelection
140Select rowShift+SpaceShift+SpaceSelection
141Speak anchorCtrl+Alt+A Ctrl+Alt+AAlt+A,C,ACtrl+⌘A Ctrl+⌘AScreen reader support
142Speak columnCtrl+Alt+Shift+CAlt+A,S,LCtrl+Option+Shift+CScreen reader support
143Speak commentCtrl+Alt+A Ctrl+Alt+CAlt+A,C,CCtrl+⌘A Ctrl+⌘CScreen reader support
144Speak rowCtrl+Alt+Shift+RAlt+A,S,RCtrl+Option+Shift+RScreen reader support
145Summarize chart contentCtrl+Alt+Shift+VCtrl+Option+Shift+VScreen reader support
146Toggle screen reader supportCtrl+Alt+Z⌘+Option+ZScreen reader support
147Speak formattingAlt+A,S,FNoneScreen reader support
148OpenCtrl+OAlt+F,O⌘OFile commands
149PrintCtrl+PCtrl+F2 or Alt+F,P⌘P⌘+F2File commands
150New spreadsheetAlt+F,N or Alt+W,NNoneFile commands
151ShareAlt+F,H or Alt+T,BNoneFile commands
152Spreadsheet settingsAlt+F,T or Alt+F,GNoneFile commands
153Collapse groupAlt+Shift+↑Alt+A,H or Alt+D,G,HOption+Shift+↑View
154Compact controlsCtrl+Shift+FCtrl+Shift+FView
155Expand groupAlt+Shift+↓Alt+A,J or Alt+D,G,SOption+Shift+↓View
156Hide columnsCtrl+Alt+0Ctrl+0 or Alt+H,O,U,C or Alt+O,C,H⌘+Option+0⌘0View
157Hide rowsCtrl+Alt+9Ctrl+9 or Alt+H,O,U,R or Alt+O,R,H⌘+Option+9⌘9View
158Show all formulasCtrl+`Alt+M,H or Alt+V,ACtrl+`View
159Unhide columnsCtrl+Shift+0Alt+H,O,U,L or Alt+O,C,U⌘+Shift+0View
160Unhide rowsCtrl+Shift+9Alt+H,O,U,O or Alt+O,R,U⌘+Shift+9View
161Full screenCtrl+F1 or Alt+V,U⌘+F1View
162Show formula barCtrl+Shift+U or Alt+W,V,F or Alt+V,F⌘+Shift+UView
163Hide sheetAlt+H,O,U,S or Alt+O,HNoneView
164Show gridlinesAlt+W,V,G or Alt+V,GNoneView
165Enter current commentCtrl+Alt+E Ctrl+Alt+CAlt+A,C,ECtrl+⌘E Ctrl+⌘CNavigation
166ExploreCtrl+Alt+Shift+I⌘+Option+Shift+INavigation
167FindCtrl+F⌘FNavigation
168Find and replaceCtrl+HAlt+H,F,D,R or Alt+E,E or Alt+E,F⌘+Shift+HNavigation
169Focus database pillCtrl+Shift+'⌘+Shift+'Navigation
170Focus named ranges boxCtrl+J⌘JNavigation
171Focus pillCtrl+Shift+'⌘+Shift+'Navigation
172Focus pop upCtrl+Alt+E Ctrl+Alt+PCtrl+⌘E Ctrl+⌘PNavigation
173Focus quicksumAlt+Shift+QOption+Shift+QNavigation
174Focus smart fill widgetCtrl+Shift+Alt+'⌘+Shift+Option+'Navigation
175Move focus out of editing areaCtrl+Alt+Shift+M⌘+Option+Shift+MNavigation
176Move to beginning of sheetCtrl+Home⌘+HomeNavigation
177Move to end of rowEndEndNavigation
178Move to end of sheetCtrl+End⌘+EndNavigation
179Move to next commentCtrl+Alt+N Ctrl+Alt+CAlt+A,C,NCtrl+⌘N Ctrl+⌘CNavigation
180Move to next editCtrl+Alt+K or Ctrl+Alt+N Ctrl+Alt+RCtrl+Option+K or Ctrl+⌘N Ctrl+⌘RNavigation
181Move to next sheetCtrl+Shift+Pg-Down or Alt+↓⌘+Shift+Pg-Down or Option+↓Navigation
182Move to previous commentCtrl+Alt+P Ctrl+Alt+CAlt+A,C,PCtrl+⌘P Ctrl+⌘CNavigation
183Move to previous editCtrl+Alt+J or Ctrl+Alt+P Ctrl+Alt+RCtrl+Option+J or Ctrl+⌘P Ctrl+⌘RNavigation
184Move to previous sheetCtrl+Shift+Pg-Up or Alt+↑⌘+Shift+Pg-Up or Option+↑Navigation
185Move to start of rowHomeHomeNavigation
186Open exploreAlt+Shift+XOption+Shift+XNavigation
187Open filter dropdown menuCtrl+Alt+RCtrl+⌘RNavigation
188Scroll to active cellCtrl+Backspace⌘+BackspaceNavigation
189See keyboard shortcutsCtrl+/⌘/Navigation
190See version historyCtrl+Alt+Shift+H⌘+Option+Shift+HNavigation
191Select next sheetCtrl+Alt+]⌘+Option+]Navigation
192Select previous sheetCtrl+Alt+[⌘+Option+[Navigation
193Show live editsCtrl+Alt+Shift+R⌘+Option+Shift+RNavigation
194Show person or group infoAlt+→Option+→Navigation
195Go to rangeF5 or Alt+E,GF5Navigation
196Help centerShift+F1F1Shift+F1F1Help

FREE RESOURCE

Google Sheets Cheat Sheet

Learn 12 tips and tactics that will make your sheets more beautiful and user-friendly from today.

Google Sheets Cheat Sheet

By entering your email address you agree to get email updates from me. I'll respect your privacy and you can unsubscribe at any time.

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.