Useful Google Spreadsheet Shortcuts Keys

 Now a days because of the heavy workload we don’t have an option other than fastening up our work, here keyboard shortcut keys play an important role in our working life.

It’s being very essential to use those to Simplify our work and fasten it up. As most of us generally use google spreadsheet for our office work regularly.

Here let’s check out some shortcut keys or commands.

Useful Google Spreadsheet Shortcuts Keys

Common Actions Shortcut Keys
Select column Ctrl + Space
Select row Shift + Space
Select all Ctrl + A, Ctrl + Shift + Space
Undo Ctrl + Z
Redo Ctrl + Y, Ctrl + Shift + Z
Find Ctrl + F
Find and replace Ctrl + H
Fill range Ctrl + Enter
Fill down Ctrl + D
Fill right Ctrl + R
Save (Every change is saved automatically in Drive) Ctrl + S (Not Required)
Open Ctrl + O
Print Ctrl + P
Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Paste values only Ctrl + Shift + V
Show common keyboard shortcuts Ctrl + /
Insert new sheet Shift + F11
Compact controls Ctrl + Shift + F
Input tools on/off
(available in spreadsheets in non-Latin languages)
Ctrl + Shift + K
Select input tools Ctrl + Alt + Shift + K

–>

Cell Formatting Shortcut Keys
Bold Ctrl + B
Underline Ctrl + U
Italic Ctrl + I
Strikethrough Alt + Shift + 5
Center align Ctrl + Shift + E
Left align Ctrl + Shift + L
Right align Ctrl + Shift + R
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
Insert link Ctrl + K
Insert time Ctrl + Shift + ;
Insert date Ctrl + ;
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 +

–>

Spreadsheet Navigation Shortcut Keys
Move to beginning of row Home
Move to beginning of sheet Ctrl + Home
Move to end of row End
Move to end of sheet Ctrl + End
Scroll to active cell Ctrl + Backspace
Move to next sheet Ctrl + Shift + Page Down
Move to previous sheet Ctrl + Shift + Page Up
Display list of sheets Alt + Shift + K
Open hyperlink Alt + Enter
Open Explore Alt + Shift + X
Move focus out of spreadsheet Ctrl + Alt + Shift + M
Move to quicksum(when a range of cells is selected) Alt + Shift + Q
Move focus to popup (for links, bookmarks, and images) holding Ctrl + Alt, press E then P
Open drop-down menu on filtered cell Ctrl + Alt + R
Open revision history Ctrl + Alt + Shift + G
Open chat inside the spreadsheet Shift + Esc
Close drawing editor Shift + Esc

–>

Notes and Comments Shortcut Keys
Insert/edit note Shift + F2
Insert/edit comment Ctrl + Alt + M
Open comment discussion thread Ctrl + Alt + Shift + A
Enter current comment holding Ctrl + Alt, press E then C
Move to next comment holding Ctrl + Alt, press N then C
Move to previous comment holding Ctrl + Alt, press P then C

–>

Menus Shortcut Keys
File menu Google Chrome: Alt + F,
Rest of the browsers: Alt + Shift + F
Edit menu Google Chrome: Alt + E,
Rest of the browsers: Alt + Shift + E
View menu Google Chrome: Alt + V,
Rest of the browsers: Alt + Shift + V
Insert menu Google Chrome: Alt + I,
Rest of the browsers: Alt + Shift + I
Format menu Google Chrome: Alt + O,
Rest of the browsers: Alt + Shift + O
Data menu Google Chrome: Alt + D,
Rest of the browsers: Alt + Shift + D
Tools menu Google Chrome: Alt + T,
Rest of the browsers: Alt + Shift + T
Form menu (present when the spreadsheet is connected to a form) Google Chrome: Alt + M,
Rest of the browsers: Alt + Shift + M
Add-ons menu (present in the new Google Sheets) Google Chrome: Alt + N,
Rest of the browsers: Alt + Shift + N
Help menu Google Chrome: Alt + H,
Rest of the browsers: Alt + Shift + H
Accessibility menu (present when screen reader support is enabled) in Google Chrome: Alt + A,
Rest of the browsers: Alt + Shift + A
Sheet menu (copy, delete, and other sheet actions) Alt + Shift + S
Context menu Ctrl + Shift +

–>

Insert or Delete Rows or Columns Shortcut Keys
Insert row above Google Chrome: Alt + I, then R,
Rest of the browsers: Alt + Shift + I, then R
Insert row below Google Chrome: Alt + I, then W,
Rest of the browsers: Alt + Shift + I, then W
Insert column to the left Google Chrome: Alt + I, then C,
Rest of the browsers: Alt + Shift + I, then C
Insert column to the right Google Chrome: Alt + I, then G,
Rest of the browsers: Alt + Shift + I, then G
Delete row Google Chrome: Alt + E, then D,
Rest of the browsers: Alt + Shift + E, then D
Delete column Google Chrome: Alt + E, then E,
Rest of the browsers: Alt + Shift + E, then E

–>

Formulas Shortcut Keys
Show all formulas Ctrl + ~
Insert array formula Ctrl + Shift + Enter
Collapse an expanded array formula Ctrl + E
Show/hide formula help
(when entering a formula)
Shift + F1
Full/compact formula help
(when entering a formula)
F1
Absolute/relative references
(when entering a formula)
F4
Toggle formula result previews
(when entering a formula)
F9
Resize formula bar
(move up or down)
Ctrl + Up / Ctrl + Down

–>

Screen Reader Support Shortcut Keys
Enable screen reader support Ctrl + Alt + Z
Read column Ctrl + Alt + Shift + C
Read row Ctrl + Alt + Shift + R
2
>
Questioncage

Subscribe To QuestionCage

Glad to see your Visit at QuestionCage!

One more step to connect ahead "Subscribe to Us" and get the updates to your inbox directly.

You have Successfully Subscribed to QuestionCage!