These google spreadsheet keyboards shortcuts will surely help you in completing your spreadsheet tasks more easily. This will save your time.
Keyboard Shortcuts
| Absolute/relative references (when entering a formula) | F4 |
| Accept Smart Fill suggestion | Ctrl+Shift+Y |
| Copy | Ctrl+C or Ctrl+InsertAlt+H,C,C or Alt+E,C |
| Cut | Ctrl+X or Shift+DeleteAlt+H,X or Alt+E,T |
| Define word | Ctrl+Shift+Y |
| Delete rows/columns or Open delete menu | Ctrl+Alt+-Ctrl+- or Alt+H,D,D |
| Edit description | Ctrl+Shift+E |
| Fill down | Ctrl+DAlt+H,F,I,D or Alt+E,I,D |
| Fill range | Ctrl+Enter |
| Fill right | Ctrl+RAlt+H,F,I,R or Alt+E,I,R |
| Group | Alt+Shift+→Alt+A,G or Alt+D,G,G |
| Input tools on/off | Ctrl+Shift+K |
| Insert array formula | Ctrl+Shift+Enter |
| Insert current date | Ctrl+; |
| Insert current date and time | Ctrl+Alt+Shift+; |
| Insert current time | Ctrl+Shift+; |
| Insert link | Ctrl+KAlt+N,I or Alt+I,I or Alt+I,K |
| Insert new sheet | Shift+F11Alt+Shift+F1 or Alt+H,I,S or Alt+I,W or Alt+I,S |
| 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 |
| Insert/edit note | Shift+F2 |
| Open link | Alt+Enter |
| Paste | Ctrl+V or Shift+InsertAlt+H,V,P or Alt+E,P |
| Paste format only | Ctrl+Alt+VAlt+H,V,R |
| Paste values only | Ctrl+Shift+VAlt+H,V,V |
| Paste without formatting | Ctrl+Shift+V |
| Redo | Ctrl+Y or Ctrl+Shift+Z or F4Alt+3 or Alt+E,R |
| Reject Smart Fill suggestion | Ctrl+Shift+Alt+D |
| Select input tools | Ctrl+Alt+Shift+K |
| Undo | Ctrl+ZAlt+2 or Alt+E,U |
| Ungroup | Alt+Shift+←Alt+A,U or Alt+D,G,U or Alt+D,U |
| Paste formula only | Alt+H,V,F |
| Paste all except borders | Alt+H,V,B or Alt+E,S,B |
| Paste column width only | Alt+H,V,W |
| Paste transposed | Alt+H,V,T or Alt+E,S,E |
| Text rotation: tilt up | Alt+H,F,Q,O or Alt+O,R,P |
| Text rotation: tilt down | Alt+H,F,Q,L or Alt+O,R,W |
| Text rotation: stack vertically | Alt+H,F,Q,V or Alt+O,R,V |
| Text rotation: rotate up | Alt+H,F,Q,U |
| Text rotation: rotate down | Alt+H,F,Q,D or Alt+O,R,D |
| Insert 1 row above | Alt+H,I,R or Alt+I,R |
| Insert 1 column left | Alt+H,I,C or Alt+I,C |
| Delete row 3 | Alt+H,D,R or Alt+E,D |
| Delete column I | Alt+H,D,C |
| Delete | Alt+H,D,S or Alt+E,L |
| Delete values | Alt+H,E,C or Alt+E,A,C or Alt+E,V |
| Clear notes | Alt+H,E,M or Alt+E,A,M |
| Insert 1 row below | Alt+I,B |
| Insert cells and shift down | Alt+I,D |
| Insert 1 column right | Alt+I,O |
| Insert checkbox | Alt+I,X |
Menus
| Accessibility menu | Alt+Shift+A or Alt+A |
| Context menu | Ctrl+Shift+\ or Shift+F10 or Ctrl+Shift+X |
| Data menu | Alt+Shift+D or Alt+D |
| Display sheet menu | Alt+Shift+S |
| Edit menu | Alt+Shift+E or Alt+E |
| Extensions menu | Alt+Shift+N or Alt+N |
| File menu | Alt+Shift+F or Alt+F |
| Format menu | Alt+Shift+O or Alt+OCtrl+1 |
| Help menu | Alt+Shift+H or Alt+H |
| Insert menu | Alt+Shift+I or Alt+I |
| Quick Access | Alt+. |
| Search the menus | Alt+/ or Alt+Z |
| Show sheet list | Shift+Alt+K |
| Tools menu | Alt+Shift+T or Alt+T |
| View menu | Alt+Shift+V or Alt+V |
Formatting
| Align center | Ctrl+Shift+EAlt+H,A,C or Alt+O,A,C |
| Align left | Ctrl+Shift+LAlt+H,A,L or Alt+O,A,L |
| Align right | Ctrl+Shift+RAlt+H,A,R or Alt+O,A,R |
| Apply bottom border | Alt+Shift+3Alt+H,B,O |
| Apply left border | Alt+Shift+4Alt+H,B,L |
| Apply outer border | Alt+Shift+7 or Ctrl+Shift+7Alt+H,B,S |
| Apply right border | Alt+Shift+2Alt+H,B,R |
| Apply top border | Alt+Shift+1Alt+H,B,P |
| Bold | Ctrl+BCtrl+2 or Alt+H,1 or Alt+O,B |
| Clear formatting | Ctrl+\Alt+H,E,F or Alt+E,A,F |
| Italic | Ctrl+ICtrl+3 or Alt+H,2 or Alt+O,I |
| Number format: currency | Ctrl+Shift+4Alt+O,N,C |
| Number format: date | Ctrl+Shift+3Alt+O,N,D |
| Number format: number | Ctrl+Shift+1Alt+H,K or Alt+O,N,N |
| Number format: percent | Ctrl+Shift+5Alt+H,P or Alt+O,N,P |
| Number format: scientific | Ctrl+Shift+6Alt+O,N,S |
| Number format: time | Ctrl+Shift+2Alt+O,N,T |
| Remove borders | Alt+Shift+6Ctrl+Shift+- or Alt+H,B,N |
| Strikethrough text | Alt+Shift+5Ctrl+5 or Alt+O,K |
| Underline text | Ctrl+UCtrl+4 or Alt+H,3,U or Alt+O,U |
| Number format: automatic | Ctrl+Shift+` or Alt+O,N,M |
| Text align: top | Alt+H,A,T or Alt+O,A,T |
| Text align: middle | Alt+H,A,M or Alt+O,A,M |
| Text align: bottom | Alt+H,A,B or Alt+O,A,B |
| Number format: accounting | Alt+H,A,N or Alt+O,N,A |
| Apply all borders | Alt+H,B,A |
| Wrap text | Alt+H,W or Alt+O,W,W |
| Merge cells horizontally | Alt+H,M,A or Alt+O,M,H |
| Merge cells | Alt+H,M,M or Alt+O,M,A |
| Unmerge cells | Alt+H,M,U or Alt+O,M,U |
| Increase decimal places | Alt+H,0 |
| Decrease decimal places | Alt+H,9 |
| Conditional formatting | Alt+H,L or Alt+O,D or Alt+O,F |
| Resize row | Alt+H,O,A or Alt+O,R,A |
| Resize column | Alt+H,O,I or Alt+O,C,A |
| Number format: plain text | Alt+O,N,X |
| Number format: financial | Alt+O,N,F |
| Number format: currency rounded | Alt+O,N,R |
| Number format: date time | Alt+O,N,I |
| Number format: duration | Alt+O,N,U |
Data
| Open data cleanup suggestions | Ctrl+Alt+X |
| Insert chart | Alt+F1 or Alt+N,K or Alt+I,H |
| Protect sheet | Alt+H,O,P or Alt+R,P or Alt+T,P or Alt+T,T |
| Sort range by column A (A to Z) | Alt+H,S,S or Alt+D,R |
| Sort range by column A (Z to A) | Alt+H,S,O or Alt+D,T |
| Sort range | Alt+H,S,U or Alt+D,S |
| Create a filter | Alt+H,S,F or Alt+D,F |
| Insert function: AVERAGE | Alt+H,U,A or Alt+M,U,A or Alt+I,U,A |
| Insert function: COUNT | Alt+H,U,C or Alt+M,U,C or Alt+I,U,C |
| Insert function: MAX | Alt+H,U,M or Alt+M,U,M or Alt+I,U,M |
| Insert function: MIN | Alt+H,U,I or Alt+M,U,I or Alt+I,U,I |
| Insert function: SUM | Alt+H,U,S or Alt+M,U,S or Alt+I,U,S |
| Insert pivot table | Alt+N,V or Alt+D,P |
| Define named range | Alt+M,N or Alt+I,N or Alt+D,N |
| Cleanup suggestions | Alt+A,Y or Alt+D,Y |
| Split text to columns | Alt+A,E or Alt+D,E |
| Remove duplicate rows | Alt+A,M or Alt+D,M |
| Data validation | Alt+A,V or Alt+D,L or Alt+D,V |
| Freeze 1 row | Alt+W,F,R or Alt+V,R,O |
| Freeze 1 column | Alt+W,F,C or Alt+V,R,L |
| Freeze 2 rows | Alt+V,R,W |
| Freeze no rows | Alt+V,R,R |
| Freeze up to current row (3) | Alt+V,R,U |
| Freeze 2 columns | Alt+V,R,M |
| Freeze no columns | Alt+V,R,C |
| Freeze up to current column (I) | Alt+V,R,P |
| Trim whitespace | Alt+D,I |
Screen reader support
| Insert comment | Ctrl+Alt+MAlt+R,C or Alt+I,M |
| Open comment history | Ctrl+Alt+Shift+AAlt+A,C,O or Alt+R,A or Alt+V,C |
| Spell check | F7 or Alt+R,S or Alt+T,S,S |
| Select all | Ctrl+A or Ctrl+Shift+SpaceCtrl+Shift+8 |
| Select column | Ctrl+Space |
| Select row | Shift+Space |
| Summarize chart content | Ctrl+Alt+Shift+V |
| Toggle screen reader support | Ctrl+Alt+Z |
| Verbalize column | Ctrl+Alt+Shift+CAlt+A,S,L |
| Verbalize comment | Ctrl+Alt+A Ctrl+Alt+CAlt+A,S,T |
| Verbalize comment anchor | Ctrl+Alt+A Ctrl+Alt+AAlt+A,S,A |
| Verbalize row | Ctrl+Alt+Shift+RAlt+A,S,R |
| Verbalize formatting | Alt+A,S,F |
| Open | Ctrl+OAlt+F,O |
| Ctrl+PCtrl+F2 or Alt+F,P | |
| New spreadsheet | Alt+F,N or Alt+W,N |
| Share | Alt+F,H or Alt+T,B |
| Settings | Alt+F,T or Alt+F,G |
View
| Collapse group | Alt+Shift+↑Alt+A,H or Alt+D,G,H |
| Compact controls | Ctrl+Shift+F |
| Expand group | Alt+Shift+↓Alt+A,J or Alt+D,G,S |
| Hide all controls | Ctrl+Alt+’ |
| Hide columns | Ctrl+Alt+0Ctrl+0 or Alt+H,O,U,C or Alt+O,C,H |
| Hide current control | Ctrl+’ |
| Hide rows | Ctrl+Alt+9Ctrl+9 or Alt+H,O,U,R or Alt+O,R,H |
| Show all controls | Ctrl+Alt+’ |
| Show all formulas | Ctrl+`Alt+M,H or Alt+V,A |
| Show current control | Ctrl+’ |
| Unhide columns | Ctrl+Shift+0Alt+H,O,U,L or Alt+O,C,U |
| Unhide rows | Ctrl+Shift+9Alt+H,O,U,O or Alt+O,R,U |
| Full screen | Ctrl+F1 or Alt+V,U |
| Show formula bar | Ctrl+Shift+U or Alt+W,V,F or Alt+V,F |
| Hide sheet | Alt+H,O,U,S or Alt+O,H |
| Show gridlines | Alt+W,V,G or Alt+V,G |
| Enter current comment | Ctrl+Alt+E Ctrl+Alt+CAlt+A,C,E |
| Explore | Ctrl+Alt+Shift+I |
| Find | Ctrl+F |
| Find and replace | Ctrl+HAlt+H,F,D,R or Alt+E,E or Alt+E,F |
| Focus current control | Ctrl+Shift+’ |
| Focus named ranges box | Ctrl+J |
| Focus pop up | Ctrl+Alt+E Ctrl+Alt+P |
| Focus proactive suggestion chip | Ctrl+Alt+; |
| Focus quicksum | Alt+Shift+Q |
| Focus Smart Fill widget | Ctrl+Shift+Alt+’ |
| Move focus out of editing area | Ctrl+Alt+Shift+M |
| Move to beginning of sheet | Ctrl+Home |
| Move to end of row | End |
| Move to end of sheet | Ctrl+End |
| Move to next comment | Ctrl+Alt+N Ctrl+Alt+CAlt+A,C,N |
| Move to next edit | Ctrl+Alt+K or Ctrl+Alt+N Ctrl+Alt+R |
| Move to next sheet | Ctrl+Shift+Pg-Down or Alt+↓ |
| Move to previous comment | Ctrl+Alt+P Ctrl+Alt+CAlt+A,C,P |
| Move to previous edit | Ctrl+Alt+J or Ctrl+Alt+P Ctrl+Alt+R |
| Move to previous sheet | Ctrl+Shift+Pg-Up or Alt+↑ |
| Move to start of row | Home |
| Open Explore | Alt+Shift+X |
| Open filter dropdown menu | Ctrl+Alt+R |
| Resize sidebar with arrow keys | Alt+W |
| Scroll to active cell | Ctrl+Backspace |
| See keyboard shortcuts | Ctrl+/ |
| See version history | Ctrl+Alt+Shift+H |
| Select next sheet | Ctrl+Alt+] |
| Select previous sheet | Ctrl+Alt+[ |
| Show live edits | Ctrl+Alt+Shift+R |
| Show person or group info | Alt+→ |
| Go to range | F5 or Alt+E,G |
Help
| Help Center | Shift+F1F1 |
