Top Google Sheet Keyboard Shortcuts – Make Your Work Productive

Nobody likes to do work the hard way, which is the reason why we have keyboard shortcuts! We are going to consider the shortcuts you can use in Google Sheets to spare some time. By no means is it a comprehensive list of all keyboard shortcuts accessible Google Sheets. We have limited our list for those who are more generally helpful. You will find a lot more you can research if you can’t find what you’re searching for in this manual.

To start a list of keyboard shortcuts from Google Sheets, press Ctrl + / (Windows and Chrome OS), Cmd + / (macOS) If you want to see the whole listing, check out the Google Sheets support page.

Google Sheet 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+ShiftPage+Down
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 – Selection

Select columnCtrl + Space
Select rowShift + Space
Select allCtrl + A

Google Sheet shortcuts – Data Entry

Complete Data Entry and Move to the Cell BelowEnter
Completes Data Entry and Move to the Cell AboveShift + Enter
Insert a New Line in the Same CellAlt + Enter
Completes Data Entry & Move to the Cell on the RightTab
Completes Data Entry & Move to the Cell on the LeftShift + Tab
Get into Edit ModeF2
Fill all the Selected CellsCtrl + 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 cursorShift + Up Arrow
Select all content to the Right of the cursorShift + 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 SheetShift + F11
Insert HyperlinkCtrl + K
Insert Current TimeCtrl + Shift;
Insert Current DateCtrl + ;
Insert Row Above (in Google Chrome)AltI + R
Insert Row Above (in Other Browsers)Alt + ShiftI + R
Insert Row Below (in Google Chrome)AltI + W
Insert Row Below (in Other Browsers)Alt+I, then W
Insert Column to the Left (in Google Chrome)Alt+I, then C
Insert Column to the Left (in Other Browsers)Alt + Shift + I, then C
Insert Column to the Right (in Google Chrome)Alt + I, then G
Insert Column to the Right (in Other Browsers)Alt + Shift + I, then G

Google Sheet shortcuts – Delete

Clear Cell ContentsDelete
Delete Current Row (in Google Chrome)Alt + E, then D
Delete Current Row (in Other Browsers)ALT + Shift + E, then D
Delete Current Column (in Google Chrome)Alt + EE
Delete Current Column (in Other Browsers)ALT + Shift + EE

Google Sheet shortcuts – General

UndoCtrl + Z
RedoCtrl + Y
Repeat the Last ActionF4
Insert/Edit Note (comment)Shift + F2
Find within the SheetCtrl + F
Opens Find and replace Dialogue BoxCtrl + H
Save (Every change is saved automatically in Drive)Ctrl + S
Open a FileCtrl + O
PrintCtrl + P
Show common keyboard shortcutsCtrl + /
Compact ControlsCtrl + Shift + F
Open Hyperlink (when the cell with a link is selected)Alt + Enter
Enable screen reader supportCtrl + Alt + Z

Keyboard Shortcuts for Google Sheets – Formatting

Bold the contents of the selected cellCtr + l + B
Underline the contents of the selected cellCtr + l + U
Italicize the contents of the selected cellCtrl + I
Apply the Strikethrough FormatAlt + 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 cellsAlt + 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 formatCtrl + 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 Sheet 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 + \

3 thoughts on “Top Google Sheet Keyboard Shortcuts – Make Your Work Productive

Leave a Reply

Your email address will not be published. Required fields are marked *