Many things in Google Sheets are just a few clicks away, but Google Sheets shortcuts will allow you to be more productive. Google Sheets is a web-based tool, and hence you must have an internet connection to work with it. An experienced Excel user will find it less challenging to learn Google Sheets shortcuts, as they are fewer compared to Excel.
Download Google Sheets Shortcuts PDF
Table of Contents
Nowadays, no one likes to do things in a complex or complicated way. One of the easiest ways is to learn keyboard shortcuts. You will be amazed at how much faster you can work in Google Sheets by knowing the Google Sheets shortcuts from the list below. Download the Google Sheets shortcuts in PDF format.
Most Used Google Sheets Shortcuts
| Action | Google Sheets Shortcuts |
|---|---|
| Open | Ctrl + O |
| Save | Ctrl + S |
| Ctrl + P | |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Paste Values only | Ctrl + Shift + V |
| Select Column | Ctrl + Spacebar |
| Select Row | Shift + Spacebar |
| Select All | Ctrl + A |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Find | Ctrl + F |
| Find & Replace | Ctrl + H |
| Fill Range | Ctrl + Enter |
| Fill Down | Ctrl + D |
| Fill Right | Ctrl + R |
| Insert new sheet | Shift + F11 |
| Compact controls | Ctrl + Shift + F |
| Select input tools | Ctrl + Alt + Shift + K |
| Search the menus | Alt + / |
| Common Keyboard Shortcuts | Ctrl + / |
Similar Programs: Apple Numbers Shortcuts
| Action | Google Sheets Shortcuts |
|---|---|
| Move to the beginning of the row | Home key |
| Move to the beginning of the sheet | Ctrl + Home key |
| Move to the end of the row | End key |
| Move to the end of the sheet | Ctrl + End key |
| Scroll to an active cell | Ctrl + Backspace |
| Move to the next sheet | Alt + Down Arrow key |
| Move to the previous sheet | Alt + Up Arrow key |
| Display a list of sheets | Alt + Shift + K |
| Open hyperlink | Alt + Enter |
| Open Explore | Alt + Shift + X |
| Go to the side panel | Ctrl + Alt + . |
| Move to focus out of a spreadsheet | Ctrl + Alt + Shift + M |
| The open drop-down menu on filtered cell | Ctrl + Alt + R |
| Open revision history | Ctrl + Alt + Shift + H |
| Close drawing editor | Shift + Esc |
Similar Programs: Gnumeric Keyboard Shortcuts
Format Cells Shortcuts
| Action | Google Sheets Shortcuts |
|---|---|
| Apply top border | Alt + Shift + 1 |
| Apply right border | Alt + Shift + 2 |
| Apply bottom border | Alt + Shift + 3 |
| Apply left border | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 |
| Apply outer border | Alt + Shift + 7 |
| Bold | Ctrl + B |
| Underline | Ctrl + U |
| Italic | Ctrl + I |
| Strikethrough | Alt + Shift + 5 |
| Center align | Ctrl + Shift + E |
| Left align | Ctrl + Shift + I |
| Right align | Ctrl + Shift + R |
| Insert link | Ctrl + K |
| Insert time | Ctrl + Shift + ; |
| Insert date | Ctrl + ; |
| Insert date and time | Ctrl + Alt + Shift + ; |
| Format as decimal | Ctrl + Shift + 1 |
| Format as time | Ctrl + Shift + 2 |
| Format as date | Ctrl + Shift + 3 |
| Format as currency | Ctrl + Shift + 4 |
| Format as Percentage | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 |
| Clear formatting | Ctrl + \ |
Notes & Comments Shortcuts
| Action | Google Sheets Shortcuts |
|---|---|
| Insert/edit note | Shift + F2 |
| Insert/edit comment | Ctrl + Alt + M |
| Open comment discussion thread | Ctrl + Alt + Shift + A |
Similar Programs: Excel for the Web Shortcuts
Add or Change Rows & Columns Shortcuts
| Action | Google Sheets Shortcuts |
|---|---|
| Insert rows above | Ctrl + Alt + + |
| Insert columns to the left | Ctrl + Alt + + |
| Insert columns to the right | Ctrl + Alt + + |
| Delete rows | Ctrl + Alt + – |
| Delete columns | Ctrl + Alt + – |
| Hide row | Ctrl + Alt + 9 |
| Unhide row | Ctrl + Shift + 9 |
| Hide column | Ctrl + Alt + 0 |
| Unhide column | Ctrl + Shift + 0 |
| Group rows or columns | Alt + Shift + Right Arrow key |
| Ungroup rows or columns | Alt + Shift + Left Arrow key |
| Expand grouped rows or columns | Alt + Shift + Down Arrow key |
| Collapse-grouped rows or columns | Alt + Shift + Up Arrow key |
Formulas Shortcuts
| Action | Google Sheet Shortcut keys |
|---|---|
| Show all formulas | Ctrl + ~ |
| Insert array formula | Ctrl + Shift + Enter |
| Collapse an expanded array formula | Ctrl + E |
| Show or hide formula help | Shift + F1 |
| Full or compact formulas help | F1 |
| Absolute or relative references | F4 |
| Toggle formula result previews | F9 |
| Resize formula bar | Ctrl + Up Arrow key |
Similar Programs: Excel Shortcut keys
Spreadsheet Menu Shortcuts
| Action | Google Sheet Shortcut keys |
|---|---|
| File menu | Alt + F |
| Edit menu | Alt + E |
| View menu | Alt + V |
| Insert menu | Alt + I |
| Format menu | Alt + O |
| Data menu | Alt + D |
| Tools menu | Alt + T |
| Open insert menu | Ctrl + Alt + = |
| Open delete menu | Ctrl + Alt + – |
| Form menu | Alt + M |
| Add-ons menu | Alt + N |
| Help menu | Alt + H |
| Sheet menu | Alt + Shift + S |
| Context menu | Ctrl + Shift + \ |
All these Google Sheets shortcuts will help you create spreadsheets of all types, including contact lists, budgets, financial statements, and much more. Another web-based tool that is used as often as Google Sheets is Google Docs. Have a look at the detailed list of Google Docs shortcuts.
READ NEXT:
