Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.
The fact that you can use it for free (as it comes with every Google account) is a huge reason for this fast adoption.
In this article, I have listed of 101 Google Sheets Keyboard Shortcuts that will save you a lot of time.
Scroll down to see all the Google Sheets Keyboard Shortcuts.
| Move One Cell Up/Down/Left/Right. |
↑ ↓ ← → |
| Go to the Left Most Cell in the Current Row. |
Ctrl ← |
| Go to the Right Most Cell in the Current Row. |
Ctrl → |
| Go to Bottom Most Cell in the Current Column. |
Ctrl ↓ |
| Go to Top Most Cell in the Current Column. |
Ctrl ↑ |
| Move to beginning of the row. |
Home |
| Move to beginning of the sheet. |
Ctrl Home |
| Move to end of the row. |
End |
| Move to the cell on the right. |
Tab |
| Move to the cell on the left. |
Shift Tab |
| Move to end of the sheet. |
Ctrl End |
| Move to the next sheet. |
Ctrl Shift PageDown |
| Move to the previous sheet. |
Ctrl Shift PageUp |
| Display the list of sheets. |
Alt Shift K |
Google Sheets Keyboard Shortcuts – Cut/Copy/Paste
| Copy the Selected Cells. |
Ctrl C |
| Cut the Selected Cells. |
Ctrl X |
| Paste the Content of the Selected Cells. |
Ctrl V |
| Paste Values Only. |
Ctrl Shift V |
Google Sheets Keyboard Shortcuts – General
| Undo |
Ctrl Z |
| Redo |
Ctrl Y |
| Repeat Last Action |
F4 |
| Insert/Edit Note (comment) |
Shift F2 |
| Find within the Sheet |
Ctrl F |
| Opens Find and replace Dialogue Box |
Ctrl H |
| Save (Every change is saved automatically in Drive) |
Ctrl S |
| Open a File |
Ctrl O |
Ctrl P |
|
| Show common keyboard shortcuts |
Ctrl / |
| Compact Controls |
Ctrl Shift F |
| Open Hyperlink (when the cell with link is selected) |
Alt Enter |
| Enable screen reader support |
Ctrl Alt Z |
Google Sheets Keyboard Shortcuts – Selection
| Select column |
Ctrl Space |
| Select row |
Shift Space |
| Select all |
Ctrl A |
Google Sheets Keyboard Shortcuts – Data Entry
| Complete Data Entry and Move to the Cell Below |
Enter |
| Completes Data Entry and Move to the Cell Above |
Shift Enter |
| Insert a New Line in the Same Cell |
Alt Enter |
| Completes Data Entry & Move to the Cell on the Right |
Tab |
| Completes Data Entry & Move to the Cell on the Left |
Shift Tab |
| Get into Edit Mode |
F2 |
| Fill all the Selected Cells |
Ctrl Enter |
| Copy the content of the selected cell in the cell below (all cells should be selected) |
Ctrl D |
| Copy the content of the selected cell in the cell to the right (all cells should be selected) |
Ctrl R |
| Move One Character to the Left (when in cell edit mode) |
Left Arrow |
| Move One Character to the Right (when in cell edit mode) |
Right Arrow |
| Select all content to the left of the cursor |
Shift Up Arrow |
| Select all content to the Right of the cursor |
Shift Down Arrow |
| Move to the end of the cell content (when in cell edit mode) |
Ctrl End |
| Move to the beginning of the cell content (when in cell edit mode) |
Ctrl Home |
Google Sheets Keyboard Shortcuts – Insert
| Insert New Sheet |
Shift F11 |
| Insert Hyperlink |
Ctrl K |
| Insert Current Ttime |
Ctrl Shift ; |
| Insert Current Date |
Ctrl ; |
| Insert Row Above (in Google Chrome) |
Alt I R |
| Insert Row Above (in Other Browsers) |
Alt Shift I R |
| Insert Row Below (in Google Chrome) |
Alt I W |
| Insert Row Below (in Other Browsers) |
Alt Shift I W |
| Insert Column to the Left (in Google Chrome) |
Alt I C |
| Insert Column to the Left (in Other Browsers) |
Alt Shift I C |
| Insert Column to the Right (in Google Chrome) |
Alt I G |
| Insert Column to the Right (in Other Browsers) |
Alt Shift I G |
Google Sheets Keyboard Shortcuts – Delete
| Clear Cell Contents |
Delete |
| Delete Current Row (in Google Chrome) |
Alt E D |
| Delete Current Row (in Other Browsers) |
ALT Shift E D |
| Delete Current Column (in Google Chrome) |
Alt E E |
| Delete Current Column (in Other Browsers) |
ALT Shift E E |
Google Sheets Keyboard Shortcuts – Formatting
| Bold the contents of the selected cell |
Ctrl B |
| Underline the contents of the selected cell |
Ctrl U |
| Italicize the contents of the selected cell |
Ctrl I |
| Apply the Strikethrough Format |
Alt Shift 5 |
| Center align the contents of the selected cell. |
Ctrl Shift E |
| Left align the contents of the selected cell. |
Ctrl Shift L |
| Right align the contents of the selected cell. |
Ctrl Shift R |
| Apply top border to the selected cells. |
Alt Shift 1 |
| Apply right border to the selected cells. |
Alt Shift 2 |
| Apply bottom border to the selected cells. |
Alt Shift 3 |
| Apply left border to the selected cells |
Alt Shift 4 |
| Remove borders from the selected cells. |
Alt Shift 6 |
| Apply outer border to the selected cells. |
Alt Shift 7 |
| Apply the decimal format |
Ctrl Shift 1 |
| Apply the time format. |
Ctrl Shift 2 |
| Apply the date format. |
Ctrl Shift 3 |
| Apply the currency format. |
Ctrl Shift 4 |
| Apply the percentage format. |
Ctrl Shift 5 |
| Apply the exponential format. |
Ctrl Shift 6 |
| Clear All formatting. |
Ctrl \ |
Google Sheets Keyboard Shortcuts – Formula Related
| Show all formulas. |
Ctrl ~ |
| Wrap the current formula in an array formula. |
Ctrl Shift Enter |
| Collapse an expanded array formula. |
Ctrl E |
| Show/hide formula help (when entering a formula). |
Shift F1 |
Google Sheets Keyboard Shortcuts – Menu
| Open File menu (in Google Chrome). |
Alt F |
| Open Edit menu (in Google Chrome). |
Alt E |
| Open View menu (in Google Chrome). |
Alt V |
| Open Insert menu (in Google Chrome). |
Alt I |
| Open Format menu (in Google Chrome). |
Alt O |
| Open Data menu (in Google Chrome). |
Alt D |
| Open Tools menu (in Google Chrome). |
Alt T |
| Open Add-ons menu. |
Alt N |
| Help menu (in Google Chrome). |
Alt H |
| Sheet menu (copy, delete, and other sheet actions). |
Alt Shift S |
| Context menu. |
Ctrl Shift \ |
Useful Google Sheets Tutorials:
- 10 Google Sheets Tips that’ll Help You Get Work Done Faster.
- VLOOKUP Function in Google Sheets.
- Query Function in Google Sheets.
- Creating a Drop Down List in Google Sheets.
Other Useful Resources:
FREE EBOOK - GOOGLE SHEETS TIPS
10 Google Sheets Tips that will save you hours every week
Loading...
