Many things in Google Sheets are just a few clicks away, but Google Sheets shortcuts will allow you to be more productive. Google Sheets is a web-based tool, and hence you must have an internet connection to work with it. An experienced Excel user will find it less challenging to learn Google Sheets shortcuts, as they are fewer compared to Excel.
Nowadays, no one likes to do things in a complex or complicated way. One of the easiest ways is to learn keyboard shortcuts. You will be amazed at how much faster you can work in Google Sheets by knowing the Google Sheets shortcuts from the list below. Download the Google Sheets shortcuts in PDF format.
Most Used Google Sheets Shortcuts
Action Google Sheets Shortcuts
Open
Ctrl + O
Save
Ctrl + S
Print
Ctrl + P
Copy
Ctrl + C
Cut
Ctrl + X
Paste
Ctrl + V
Paste Values only
Ctrl + Shift + V
Select Column
Ctrl + Spacebar
Select Row
Shift + Spacebar
Select All
Ctrl + A
Undo
Ctrl + Z
Redo
Ctrl + Y
Find
Ctrl + F
Find & Replace
Ctrl + H
Fill Range
Ctrl + Enter
Fill Down
Ctrl + D
Fill Right
Ctrl + R
Insert new sheet
Shift + F11
Compact controls
Ctrl + Shift + F
Select input tools
Ctrl + Alt + Shift + K
Search the menus
Alt + /
Common Keyboard Shortcuts
Ctrl + /
Spreadsheet Navigation Shortcuts
Action Google Sheets Shortcuts
Move to the beginning of the row
Home key
Move to the beginning of the sheet
Ctrl + Home key
Move to the end of the row
End key
Move to the end of the sheet
Ctrl + End key
Scroll to an active cell
Ctrl + Backspace
Move to the next sheet
Alt + Down Arrow key
Move to the previous sheet
Alt + Up Arrow key
Display a list of sheets
Alt + Shift + K
Open hyperlink
Alt + Enter
Open Explore
Alt + Shift + X
Go to the side panel
Ctrl + Alt + .
Move to focus out of a spreadsheet
Ctrl + Alt + Shift + M
The open drop-down menu on filtered cell
Ctrl + Alt + R
Open revision history
Ctrl + Alt + Shift + H
Close drawing editor
Shift + Esc
Format Cells Shortcuts
Action Google Sheets Shortcuts
Apply top border
Alt + Shift + 1
Apply right border
Alt + Shift + 2
Apply bottom border
Alt + Shift + 3
Apply left border
Alt + Shift + 4
Remove borders
Alt + Shift + 6
Apply outer border
Alt + Shift + 7
Bold
Ctrl + B
Underline
Ctrl + U
Italic
Ctrl + I
Strikethrough
Alt + Shift + 5
Center align
Ctrl + Shift + E
Left align
Ctrl + Shift + I
Right align
Ctrl + Shift + R
Insert link
Ctrl + K
Insert time
Ctrl + Shift + ;
Insert date
Ctrl + ;
Insert date and time
Ctrl + Alt + Shift + ;
Format as decimal
Ctrl + Shift + 1
Format as time
Ctrl + Shift + 2
Format as date
Ctrl + Shift + 3
Format as currency
Ctrl + Shift + 4
Format as Percentage
Ctrl + Shift + 5
Format as exponent
Ctrl + Shift + 6
Clear formatting
Ctrl + \
Action Google Sheets Shortcuts
Insert/edit note
Shift + F2
Insert/edit comment
Ctrl + Alt + M
Open comment discussion thread
Ctrl + Alt + Shift + A
Add or Change Rows & Columns Shortcuts
Action Google Sheets Shortcuts
Insert rows above
Ctrl + Alt + +
Insert columns to the left
Ctrl + Alt + +
Insert columns to the right
Ctrl + Alt + +
Delete rows
Ctrl + Alt + –
Delete columns
Ctrl + Alt + –
Hide row
Ctrl + Alt + 9
Unhide row
Ctrl + Shift + 9
Hide column
Ctrl + Alt + 0
Unhide column
Ctrl + Shift + 0
Group rows or columns
Alt + Shift + Right Arrow key
Ungroup rows or columns
Alt + Shift + Left Arrow key
Expand grouped rows or columns
Alt + Shift + Down Arrow key
Collapse-grouped rows or columns
Alt + Shift + Up Arrow key
Formulas Shortcuts
Action Google Sheet Shortcut keys
Show all formulas
Ctrl + ~
Insert array formula
Ctrl + Shift + Enter
Collapse an expanded array formula
Ctrl + E
Show or hide formula help
Shift + F1
Full or compact formulas help
F1
Absolute or relative references
F4
Toggle formula result previews
F9
Resize formula bar
Ctrl + Up Arrow key
Action Google Sheet Shortcut keys
File menu
Alt + F
Edit menu
Alt + E
View menu
Alt + V
Insert menu
Alt + I
Format menu
Alt + O
Data menu
Alt + D
Tools menu
Alt + T
Open insert menu
Ctrl + Alt + =
Open delete menu
Ctrl + Alt + –
Form menu
Alt + M
Add-ons menu
Alt + N
Help menu
Alt + H
Sheet menu
Alt + Shift + S
Context menu
Ctrl + Shift + \
All these Google Sheets shortcuts will help you create spreadsheets of all types, including contact lists, budgets, financial statements, and much more. Another web-based tool that is used as often as Google Sheets is Google Docs. Have a look at the detailed list of Google Docs shortcuts .
READ NEXT:
