Amazing Google Sheets Keyboard Shortcuts For Windows Users | Cheatsheet ⭐

Tutorials & Methods
, ,
1

Working with Google Sheets can be a complex task, especially when you’re dealing with extensive data. But what if you could simplify this process and enhance your efficiency? These shortcuts are not just about speeding up your work; they’re about transforming the way you interact with Google Sheets.

From basic navigation to advanced functions, these shortcuts are designed to make your spreadsheet experience smoother and more productive. Here’s a full list of Google Sheets keyboard shortcuts for Windows users.

Common Actions
Action Shortcut
Select column Ctrl + Space
Select row Shift + Space
Select all Ctrl + A, Ctrl + Shift + Space
Undo Ctrl + Z
Redo Ctrl + Y, Ctrl + Shift + Z, F4
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
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 Ctrl + Shift + K
Select input tools Ctrl + Alt + Shift + K
Tool finder (formerly Search the menus) Alt + /
Rename sheet Alt + 1
Format Cells
Action Shortcut
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
Ctrl + Shift + 7
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 + |
Navigate the Spreadsheet
Action Shortcut
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 Alt + Down Arrow
Move to previous sheet Alt + Up Arrow
Display list of sheets Alt + Shift + K
Open hyperlink Alt + Enter
Open Explore Ctrl + Alt + Shift + I
Go to side panel Ctrl + Alt + .
Ctrl + Alt + ,
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, images) hold Ctrl + Alt, press E then P
Open drop-down menu on filtered cell Ctrl + Alt + R
Open revision history Ctrl + Alt + Shift + H
Close drawing editor Shift + Esc
Edit Notes and Comments
Action Shortcut
Insert/edit note Shift + F2
Insert/edit comment Ctrl + Alt + M
Open comment discussion thread Ctrl + Alt + Shift + A
Enter current comment hold Ctrl + Alt, press E then C
Move to next comment hold Ctrl + Alt, press N then C
Move to previous comment hold Ctrl + Alt, press P then C
Use Keyboard Shortcuts on Selected Comments
Action Shortcut
Reply to current comment R
Move to next comment J
Move to previous comment K
Resolve current comment E
Exit current comment U
Open a Menu
Menu Google Chrome Shortcut Other Browsers Shortcut
File menu Alt + F Alt + Shift + F
Edit menu Alt + E Alt + Shift + E
View menu Alt + V Alt + Shift + V
Insert menu Alt + I Alt + Shift + I
Format menu Alt + O Alt + Shift + O
Data menu Alt + D Alt + Shift + D
Tools menu Alt + T Alt + Shift + T
Open insert menu Ctrl + Alt + Shift + = Ctrl + Alt + = (with cells selected)
Open delete menu Ctrl + Alt + – (with cells selected)
Form menu (connected to a form) Alt + M Alt + Shift + M
Add-ons menu Alt + N Alt + Shift + N
Help menu Alt + H Alt + Shift + H
Accessibility menu (screen reader support) Alt + A Alt + Shift + A
Sheet menu (copy, delete, other sheet actions) Alt + Shift + S
Context menu Ctrl + Shift + |Shift + F10
Add or Change Rows and Columns
Action Shortcut (General) Shortcut (Google Chrome) Shortcut (Other Browsers)
Insert rows above Ctrl + Alt + Shift + = Alt + I, then R Alt + Shift + I, then R
Ctrl + Alt + = (with rows selected)
Insert rows below Alt + I, then W Alt + Shift + I, then w
Insert columns to the left Ctrl + Alt + Shift + = Alt + I, then C Alt + Shift + I, then C
Ctrl + Alt + = (with columns selected)
Insert columns to the right Alt + I, then O Alt + Shift + I, then O
Delete rows Ctrl + Alt + – (with rows selected) Alt + E, then D Alt + Shift + E, then D
Delete columns Ctrl + Alt + – (with columns selected) Alt + E, then E Alt + Shift + E, then E
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
Ungroup rows or columns Alt + Shift + Left Arrow
Expand grouped rows or columns Alt + Shift + Down Arrow
Collapse grouped rows or columns Alt + Shift + Up Arrow
Use Formulas
Action Shortcut
Show all formulas Ctrl + ~
Insert array formula Ctrl + Shift + Enter
Collapse an expanded array formula Ctrl + E
Show/hide formula help (when entering formula) Shift + F1
Full/compact formula help (when entering formula) F1
Absolute/relative references (when entering formula) F4
Toggle formula result previews (when entering formula) F9
Resize formula bar (move up or down) Ctrl + Up / Ctrl + Down
Toggle formula range selection (when entering formula) F2 / Ctrl + E
Help for Screen Readers
Action Shortcut
Turn on screen reader support Ctrl + Alt + Z
Enable braille support Ctrl + Alt + H
Read column Ctrl + Alt + Shift + C
Read row Ctrl + Alt + Shift + R

Source: onlinetips&tricks

Happy learning!

10 Likes