GOOGLE SHEET SHORTCUT KEYS

Description	Shortcut on Windows
Move to the edge of data regions	Ctrl + Arrow Key
Move to the beginning of the sheet	Ctrl + Home
Move to the last cell with the data	Ctrl + End
Scroll down one screen	Page Down
Scroll up one screen	Page Up
Expand or collapse grouped rows/columns	Alt + Shift + Arrow Keys
Move to the next sheet	Ctrl + Page Down
Move to the previous sheet	Ctrl + Page Up
Move one cell at a time	Arrow Keys
Open the “Go to Range” dialog	Ctrl + G
Copy the selected cells	Ctrl + C
Cut the selected cells	Ctrl + X
Paste the copied or cut cells	Ctrl + V
Undo the last action	Ctrl + Z
Redo the last undone action	Ctrl + Y
Paste values only	Ctrl + Shift + V
Bold the selected text	Ctrl + B
Italicize the selected text	Ctrl + I
Underline the selected text	Ctrl + U
Open the Format menu	Alt + E
Select the entire sheet	Ctrl + A
Select the entire row	Shift + Space
Select the entire column	Ctrl + Space
Insert a new row	Ctrl + Shift + =
Insert a new column	Ctrl + Shift + +
Delete the selected row	Ctrl + –
Delete the selected column	Ctrl + Shift + –
Move to the next cell	Tab
Edit the active cell	Enter
Fill the selected cells with the previous entry	Ctrl + D
Open the sort range dialog	Alt + D + S
Apply or remove a filter	Ctrl + Shift + L
Insert a new sheet	Shift + F11
Open the version history	Ctrl + Alt + Shift + H
Calculate the sum of selected cells	Ctrl + Shift + T
Calculate the average of selected cells	Ctrl + Shift + A
Find and replace data	Ctrl + H
Format as currency	Ctrl + Shift + 4
Format as percentage	Ctrl + Shift + 5
Format as date	Ctrl + Shift + #