Many things in Google Sheets are just a few clicks away, but Google Sheet Shortcuts will let you 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 limited compared to Excel.
List of Google Sheets Shortcuts
Table of Contents
- 1 List of Google Sheets Shortcuts
- 2 FAQs
- 3 How do I create a new spreadsheet in Google Sheets using shortcuts?
- 4 How do I select cells or ranges in Google Sheets using shortcuts?
- 5 How do I navigate through sheets or tabs in Google Sheets using shortcuts?
- 6 How do I insert or delete rows or columns in Google Sheets using shortcuts?
Nowadays, no one likes to do things in a complex or complicated way. And one of the easiest ways is to learn the keyboard shortcuts. You will be amazed how much faster you can work in Google Sheets by knowing Google Sheets shortcuts from the below list. Download Google Sheet Shortcuts in PDF form.
Download Google Sheets Shortcuts PDF
Most Used Google Sheets Shortcuts
Action | Google Spreadsheet 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 + / |
Read More: 70+ Firefox Shortcuts for Windows & Mac
Action | Google Spreadsheet Shortcuts |
---|---|
Move to 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 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 |
Read More: 120+ Intellij Shortcuts for Windows & Mac
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 Spreadsheet Shortcuts |
---|---|
Insert/edit note | Shift + F2 |
Insert/edit comment | Ctrl + Alt + M |
Open comment discussion thread | Ctrl + Alt + Shift + A |
Read More: 60+ Internet Explorer Shortcuts You Should Know
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 Sheets Shortcuts |
---|---|
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 formula help | F1 |
Absolute or relative references | F4 |
Toggle formula result previews | F9 |
Resize formula bar | Ctrl + Up Arrow key |
Read More: 30+ Notepad 2 Shortcuts You Should Know
Spreadsheet Menu Shortcuts
Action | Google Sheets Shortcuts |
---|---|
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 Sheet Shortcuts will help you to create spreadsheets of all types, including contact lists, budgets, financial statements, and much more. Well, another web-based tool that is used as often as Google sheet is Google Docs. Have a look at a detailed list of Google Docs Shortcuts.
FAQs
How do I create a new spreadsheet in Google Sheets using shortcuts?
To create a new spreadsheet in Google Sheets, you can use the following shortcut: Ctrl + N
How do I select cells or ranges in Google Sheets using shortcuts?
To select cells or ranges in Google Sheets, you can use the following shortcuts: Select all: Ctrl + A, Select column: Ctrl + Spacebar, Select row: Shift + Spacebar
To navigate through sheets or tabs in Google Sheets, you can use the following shortcuts: Next sheet: Ctrl + Page Down, Previous sheet: Ctrl + Page Up
How do I insert or delete rows or columns in Google Sheets using shortcuts?
To insert rows or columns in Google Sheets, you can use the following shortcuts: Insert row: Ctrl + Shift + Plus (+), Insert column: Ctrl + Shift + Plus (+) To delete rows or columns, use: Delete row: Ctrl + -, Delete column: Ctrl + -
READ NEXT: