101 Google Sheets Keyboard Shortcuts

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 101 Google Sheets Keyboard Shortcuts that will save you a lot of time.

Scroll down to see all the Google Sheets Keyboard Shortcuts.

This Article Covers:

Google Sheets Keyboard Shortcuts – Navigation

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 the beginning of the row.	Home
Move to the beginning of the sheet.	Ctrl Home
Move to the end of the row.	End
Move to the cell on the right.	Tab
Move to the cell on the left.	Shift Tab
Move to the 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 the 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
Print	Ctrl P
Show common keyboard shortcuts	Ctrl /
Compact Controls	Ctrl Shift F
Open Hyperlink (when the cell with a 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

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 Time	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 aligns the contents of the selected cell.	Ctrl Shift L
Right-align the contents of the selected cell.	Ctrl Shift R
Apply a top border to the selected cells.	Alt Shift 1
Apply the right border to the selected cells.	Alt Shift 2
Apply the bottom border to the selected cells.	Alt Shift 3
Apply a left border to the selected cells	Alt Shift 4
Remove borders from the selected cells.	Alt Shift 6
Apply the 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 the 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 the Tools menu (in Google Chrome).	Alt T
Open the 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:

Other Useful Resources:

Sumit

Spreadsheet Expert at Productivity Spot | Website | + posts

Google Sheets and Microsoft Excel Expert.