101 Google Sheets Shortcuts for Your Keyboard

By

Google Sheets Keyboard Shortcuts - Spreadsheets

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following, and I see many people migrating from other spreadsheet 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 Shortcuts that will save you a lot of time.

Scroll down to see all the Google Sheets Shortcuts.

Google Sheets Shortcuts for Navigation

Action Windows Mac
Move one cell up/down/left/right
Go to the leftmost cell in the current row
Ctrl
Go to the rightmost cell in the current row
Ctrl

 

Go to the bottommost cell in the current column
Ctrl
Go to the topmost cell in the current column
Ctrl
Move to the beginning of the row
Home
Fn 
Move to the beginning of the sheet
Ctrl
Home
Fn 
Move to the end of the row
End
Fn 
Move to the cell on the right
Tab
Tab
Move to the cell on the left
Shift
Tab
Shift
Tab
Move to the end of the sheet
Ctrl
End
Fn 
Move to the next sheet
Ctrl
Shift
Page down
Option
Move to the previous sheet
Ctrl
Shift
Page up
Display the list of sheets
Alt
Shift
K
Option
Shift
K

Google Sheets Keyboard Shortcuts – Cut/Copy/Paste

Action Windows Mac
Copy the selected cells
Ctrl
C
C
Cut the selected cells
Ctrl
X
X
Paste the content of the selected cells
Ctrl
V
V
Paste the values only
Ctrl
Shift
V
Shift
V

Google Sheets Keyboard Shortcuts – General

Action Windows Mac
Undo
Ctrl
Z
Z
Redo
Ctrl
Y
Y
Repeat the last action
F4
F4
Insert/edit notes (comments)
Shift
F2
Shift
F2
Find within the sheet
Ctrl
F
F
Opens the find and replace dialogue box
Ctrl
H
H
Save (every change is automatically saved in the drive)
Ctrl
S
S
Open a file
Ctrl
O
O
Print
Ctrl
P
P
Show the common keyboard shortcuts
Ctrl
/
/
Compact controls
Ctrl
Shift
F
Shift
F
Open a hyperlink (when the cell with a link is selected)
Alt
Enter
Option
Enter
Enable the screen reader support
Ctrl
Alt
Z
Option
Z

Google Sheets Shortcut Keys – Selection

Action Windows Mac
Select column
Ctrl
Space
Space
Select row
Shift
Space
Space
Select all
Ctrl
A
A

Google Sheets Keyboard Shortcuts – Data Entry

Action Windows Mac
Complete the data entry and move to the cell below
Enter
Enter
Completes the data entry and moves to the cell above
Shift
Enter
Shift
Enter
Insert a new line in the same cell
Alt
Enter
Option
Enter
Complete the data entry and move to the cell on the right
Tab
Tab
Completes the data entry and moves to the cell on the left
Shift
Tab
Shift
Tab
Open the edit mode
F2
F2
Fill all the selected cells
Ctrl
Enter
Enter
Copy the content of the selected cell in the cell below (all cells should be selected)
Ctrl
D
D
Copy the content of the selected cell in the cell to the right (all cells should be selected)
Ctrl
R
R
Move one character to the left (when in cell edit mode)
Left arrow
Left arrow
Move one character to the right (when in cell edit mode)
Right arrow
Right arrow
Select all the content to the left of the cursor
Shift
Up arrow
Shift
Up arrow
Select all content to the right of the cursor
Shift
Down arrow
Shift
Down arrow
Move to the end of the cell content (when in cell edit mode)
Ctrl
End
End
Move to the beginning of the cell content (when in cell edit mode)
Ctrl
Home
Home

Google Sheets Keyboard Shortcuts – Insert

Action Windows Mac
Insert a new sheet
Shift
F11
Shift
Fn
F11
Insert a hyperlink
Ctrl
K
K
Insert the current time
Ctrl
Shift
;
Shift
;
Insert the current date
Ctrl
;
;
Insert the row above (in Google Chrome)
Alt
I
R
Option
I
R
Insert the row above (in other browsers)
Alt
Shift
I
R
Option
Shift
I
R
Insert the row below (in Google Chrome)
Alt
I
W
Option
I
W
Insert the row below (in other browsers)
Alt
Shift
I
W
Option
Shift
I
W
Insert a column to the left (in Google Chrome)
Alt
I
C
Option
I
C
Insert a column to the left (in other browsers)
Alt
Shift
I
C
Option
Shift
I
C
Insert a column to the right (in Google Chrome)
Alt
I
G
Option
I
G
Insert a column to the right (in other browsers)
Alt
Shift
I
G
Option
Shift
I
G

Google Sheets Keyboard Shortcuts – Delete Row Shortcut in Google Sheets

Action Windows Mac
Clear the cell contents Google Sheets shortcut
Delete
Delete
Delete the current row (in Google Chrome)
Alt
E
D
Option
E
D
Delete the current row (in other browsers)
Alt
Shift
E
D
Alt
Shift
E
D
Delete the current column (in Google Chrome)
Alt
E
E
Option
Shift
E
D
Delete the current column (in other browsers)
Alt
Shift
E
E
Option
Shift
E
E

Keyboard Shortcuts for Google Sheets – Formatting

Action Windows Mac
Bold the contents of the selected cell
Ctrl
B
B
Underline the contents of the selected cell
Ctrl
U
U
Italicize the contents of the selected cell
Ctrl
I
I
Apply the strikethrough format
Alt
Shift
5
Option
Shift
5
Align the cell contents to the center
Ctrl
Shift
E
Shift 
E
Align the cell contents to the left
Ctrl
Shift
L
Shift
L
Align the cell contents to the right
Ctrl
Shift
R
Shift
R
Apply a top border to the selected cells
Alt
Shift
1
Option
Shift
1
Apply the right border to the selected cells
Alt
Shift
2
Option
Shift
2
Apply the bottom border to the selected cells
Alt
Shift
3
Option
Shift
3
Apply a left border to the selected cells
Alt
Shift
4
Option
Shift
4
Remove the borders from the selected cells
Alt
Shift
6
Option
Shift
6
Apply the outer border to the selected cells
Alt
Shift
7
Option
Shift
7
Apply the decimal format
Ctrl
Shift
1
Shift
1
Apply the time format
Ctrl
Shift
2
Shift
2
Apply the date format
Ctrl
Shift
3
Shift
3
Apply the currency format
Ctrl
Shift
4
Shift
4
Apply the percentage format
Ctrl
Shift
5
Shift
5
Apply the exponential format
Ctrl
Shift
6
Shift
6
Clear all formatting
Ctrl
\
\

Google Sheets Hotkeys – Formula Related

Action Windows Mac
Show all formulas
Ctrl
~
~
Wrap the current formula in an array formula
Ctrl
Shift
Enter
Shift 
Enter
Collapse an expanded array formula
Ctrl
E
E
Show/hide the formula help (when entering a formula)
Shift
F1
Shift
Fn
F1

Google Sheets Keyboard Shortcuts – Menu

Action Windows Mac
Open the file menu (in Google Chrome)
Alt
F
Option
F
Open the edit menu (in Google Chrome)
Alt
E
Option
E
Open the view menu (in Google Chrome)
Alt
V
Option
V
Open the insert menu (in Google Chrome)
Alt
I
Option
I
Open the format menu (in Google Chrome)
Alt
O
Option
O
Open the data menu (in Google Chrome)
Alt
D
Option
D
Open the tools menu (in Google Chrome)
Alt
T
Option
T
Open the add-ons menu
Alt
N
Option
N
Help menu (in Google Chrome)
Alt
H
Option
H
Sheet menu (copy, delete, and other sheet actions)
Alt
Shift
S
Option
Shift
S
Context menu
Ctrl
Shift
\
Shift
\

Download the Google Sheets Shortcuts PDF

We hope you have found these Google Sheets shortcuts helpful.
 
We have also put them all into a downloaded PDF sheet for you. Just click the link to download it for future reference. 
 

 

Google Sheets Keyboard Shortcuts - Spreadsheets

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following, and I see many people migrating from other spreadsheet 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 Shortcuts that will save you a lot of time.

Scroll down to see all the Google Sheets Shortcuts.

Google Sheets Shortcuts for Navigation

Action Windows Mac
Move one cell up/down/left/right
Go to the leftmost cell in the current row
Ctrl
Go to the rightmost cell in the current row
Ctrl

 

Go to the bottommost cell in the current column
Ctrl
Go to the topmost cell in the current column
Ctrl
Move to the beginning of the row
Home
Fn 
Move to the beginning of the sheet
Ctrl
Home
Fn 
Move to the end of the row
End
Fn 
Move to the cell on the right
Tab
Tab
Move to the cell on the left
Shift
Tab
Shift
Tab
Move to the end of the sheet
Ctrl
End
Fn 
Move to the next sheet
Ctrl
Shift
Page down
Option
Move to the previous sheet
Ctrl
Shift
Page up
Display the list of sheets
Alt
Shift
K
Option
Shift
K

Google Sheets Keyboard Shortcuts – Cut/Copy/Paste

Action Windows Mac
Copy the selected cells
Ctrl
C
C
Cut the selected cells
Ctrl
X
X
Paste the content of the selected cells
Ctrl
V
V
Paste the values only
Ctrl
Shift
V
Shift
V

Google Sheets Keyboard Shortcuts – General

Action Windows Mac
Undo
Ctrl
Z
Z
Redo
Ctrl
Y
Y
Repeat the last action
F4
F4
Insert/edit notes (comments)
Shift
F2
Shift
F2
Find within the sheet
Ctrl
F
F
Opens the find and replace dialogue box
Ctrl
H
H
Save (every change is automatically saved in the drive)
Ctrl
S
S
Open a file
Ctrl
O
O
Print
Ctrl
P
P
Show the common keyboard shortcuts
Ctrl
/
/
Compact controls
Ctrl
Shift
F
Shift
F
Open a hyperlink (when the cell with a link is selected)
Alt
Enter
Option
Enter
Enable the screen reader support
Ctrl
Alt
Z
Option
Z

Google Sheets Shortcut Keys – Selection

Action Windows Mac
Select column
Ctrl
Space
Space
Select row
Shift
Space
Space
Select all
Ctrl
A
A

Google Sheets Keyboard Shortcuts – Data Entry

Action Windows Mac
Complete the data entry and move to the cell below
Enter
Enter
Completes the data entry and moves to the cell above
Shift
Enter
Shift
Enter
Insert a new line in the same cell
Alt
Enter
Option
Enter
Complete the data entry and move to the cell on the right
Tab
Tab
Completes the data entry and moves to the cell on the left
Shift
Tab
Shift
Tab
Open the edit mode
F2
F2
Fill all the selected cells
Ctrl
Enter
Enter
Copy the content of the selected cell in the cell below (all cells should be selected)
Ctrl
D
D
Copy the content of the selected cell in the cell to the right (all cells should be selected)
Ctrl
R
R
Move one character to the left (when in cell edit mode)
Left arrow
Left arrow
Move one character to the right (when in cell edit mode)
Right arrow
Right arrow
Select all the content to the left of the cursor
Shift
Up arrow
Shift
Up arrow
Select all content to the right of the cursor
Shift
Down arrow
Shift
Down arrow
Move to the end of the cell content (when in cell edit mode)
Ctrl
End
End
Move to the beginning of the cell content (when in cell edit mode)
Ctrl
Home
Home

Google Sheets Keyboard Shortcuts – Insert

Action Windows Mac
Insert a new sheet
Shift
F11
Shift
Fn
F11
Insert a hyperlink
Ctrl
K
K
Insert the current time
Ctrl
Shift
;
Shift
;
Insert the current date
Ctrl
;
;
Insert the row above (in Google Chrome)
Alt
I
R
Option
I
R
Insert the row above (in other browsers)
Alt
Shift
I
R
Option
Shift
I
R
Insert the row below (in Google Chrome)
Alt
I
W
Option
I
W
Insert the row below (in other browsers)
Alt
Shift
I
W
Option
Shift
I
W
Insert a column to the left (in Google Chrome)
Alt
I
C
Option
I
C
Insert a column to the left (in other browsers)
Alt
Shift
I
C
Option
Shift
I
C
Insert a column to the right (in Google Chrome)
Alt
I
G
Option
I
G
Insert a column to the right (in other browsers)
Alt
Shift
I
G
Option
Shift
I
G

Google Sheets Keyboard Shortcuts – Delete Row Shortcut in Google Sheets

Action Windows Mac
Clear the cell contents Google Sheets shortcut
Delete
Delete
Delete the current row (in Google Chrome)
Alt
E
D
Option
E
D
Delete the current row (in other browsers)
Alt
Shift
E
D
Alt
Shift
E
D
Delete the current column (in Google Chrome)
Alt
E
E
Option
Shift
E
D
Delete the current column (in other browsers)
Alt
Shift
E
E
Option
Shift
E
E

Keyboard Shortcuts for Google Sheets – Formatting

Action Windows Mac
Bold the contents of the selected cell
Ctrl
B
B
Underline the contents of the selected cell
Ctrl
U
U
Italicize the contents of the selected cell
Ctrl
I
I
Apply the strikethrough format
Alt
Shift
5
Option
Shift
5
Align the cell contents to the center
Ctrl
Shift
E
Shift 
E
Align the cell contents to the left
Ctrl
Shift
L
Shift
L
Align the cell contents to the right
Ctrl
Shift
R
Shift
R
Apply a top border to the selected cells
Alt
Shift
1
Option
Shift
1
Apply the right border to the selected cells
Alt
Shift
2
Option
Shift
2
Apply the bottom border to the selected cells
Alt
Shift
3
Option
Shift
3
Apply a left border to the selected cells
Alt
Shift
4
Option
Shift
4
Remove the borders from the selected cells
Alt
Shift
6
Option
Shift
6
Apply the outer border to the selected cells
Alt
Shift
7
Option
Shift
7
Apply the decimal format
Ctrl
Shift
1
Shift
1
Apply the time format
Ctrl
Shift
2
Shift
2
Apply the date format
Ctrl
Shift
3
Shift
3
Apply the currency format
Ctrl
Shift
4
Shift
4
Apply the percentage format
Ctrl
Shift
5
Shift
5
Apply the exponential format
Ctrl
Shift
6
Shift
6
Clear all formatting
Ctrl
\
\

Google Sheets Hotkeys – Formula Related

Action Windows Mac
Show all formulas
Ctrl
~
~
Wrap the current formula in an array formula
Ctrl
Shift
Enter
Shift 
Enter
Collapse an expanded array formula
Ctrl
E
E
Show/hide the formula help (when entering a formula)
Shift
F1
Shift
Fn
F1

Google Sheets Keyboard Shortcuts – Menu

Action Windows Mac
Open the file menu (in Google Chrome)
Alt
F
Option
F
Open the edit menu (in Google Chrome)
Alt
E
Option
E
Open the view menu (in Google Chrome)
Alt
V
Option
V
Open the insert menu (in Google Chrome)
Alt
I
Option
I
Open the format menu (in Google Chrome)
Alt
O
Option
O
Open the data menu (in Google Chrome)
Alt
D
Option
D
Open the tools menu (in Google Chrome)
Alt
T
Option
T
Open the add-ons menu
Alt
N
Option
N
Help menu (in Google Chrome)
Alt
H
Option
H
Sheet menu (copy, delete, and other sheet actions)
Alt
Shift
S
Option
Shift
S
Context menu
Ctrl
Shift
\
Shift
\

Download the Google Sheets Shortcuts PDF

We hope you have found these  Google Sheets shortcuts helpful. We have also put them into a downloadable PDF sheet for you. Just click the link to download it to have them onhand for future reference. 
 

Related:

Popular Posts