2K
Last updated on 11th October, 2022
To make the most of Google Sheets on Windows, you should use all of the keyboard shortcuts. Due to that, we’ve compiled them all into one comprehensive list just like we’ve done for Microsoft Excel Shortcuts. These shortcuts can help you with quick navigation, formatting, editing, and so much more.
Note: a plus “+” in the following shortcuts indicates that the required keys be pressed at the same time
Common Actions
No. | Keyboard Shortcut | Description |
---|---|---|
1 | Ctrl + Space | To Select column |
2 | Ctrl + F | Find |
3 | Shift + Space | To Select row |
4 | Ctrl + A | To Select all |
5 | Ctrl + Shift + V | To Paste values only |
6 | Ctrl + Z | To Undo last action |
7 | Shift + F11 | To Insert a new sheet |
8 | Ctrl + Y | Redo |
9 | Ctrl + V | Paste |
10 | Ctrl + H | To Find and replace |
11 | Ctrl + O | To Open a spreadsheet |
12 | Ctrl + X | To Cut selected cells |
13 | Ctrl + P | To Print current spreadsheet |
14 | Ctrl + C | To Copy selected cells |
15 | Ctrl + Shift + F | To Hide/show menu bar |
To Navigate Spreadsheet
16 | Home | To Move to beginning of row |
17 | Ctrl + Home | To Move to beginning of cell |
18 | End | To Move to end of row |
19 | Ctrl + End | To Move to end of sheet |
20 | Ctrl + Alt + Shift + H | To Open revision history |
21 | Alt + Shift + K | To Display list of sheets |
22 | Ctrl + Shift + Page Down | To Move to next sheet |
23 | Ctrl + Backspace | To Scroll to active cell |
24 | Alt + Shift + K | To Display list of sheets |
25 | Ctrl + Shift + Page Up | To Move to previous sheet |
To Open a Menu
26 | Alt + F (Chrome); Alt + Shift + F | To Open Format menu |
27 | Alt + I (Chrome); Alt + Shift + I | To Open Insert menu |
28 | Alt + E (Chrome); Alt + Shift + E | To Open Edit menu |
29 | Alt + F (Chrome); Alt + Shift + F | To Open File menu |
30 | Alt + V (Chrome); Alt + Shift + V | To Open View menu |
31 | Alt + D (Chrome) | To Open Data menu |
32 | Alt + T | To Open Tools menu |
33 | Alt + N | To Open Add-ons menu |
34 | Alt + H (Chrome) | To Open Help menu |
35 | Ctrl + Shift + \ | To Open Context menu |
36 | Ctrl + B | To Bold selected cells |
To Format Cells
37 | Ctrl + Shift + E | Center align |
38 | Ctrl + Shift + L | Left align |
39 | Ctrl + Shift + R | Right align |
40 | Ctrl + B | To Bolden selected cells |
41 | Ctrl + I | To Italicize selected cells |
42 | Ctrl + U | To Underline selected cells |
43 | Alt + Shift + 5 | To Strikethrough selected cells |
44 | Ctrl + K | To Insert link |
45 | Ctrl + Shift + ; | Insert current time |
46 | Ctrl + ; | Insert current date |
47 | Ctrl + Alt + Shift + ; | Insert current date and time |
48 | Ctrl + Shift + 1 | Format as decimal |
49 | Ctrl + Shift + 2 | Format as time |
50 | Ctrl + Shift + 3 | Format as date |
51 | Ctrl + Shift + 4 | Format as currency |
52 | Ctrl + Shift + 5 | Format as percentage |
53 | Ctrl + Shift + 6 | Format as exponent |
54 | Ctrl + \ | Clear formatting |
To Add or change Rows and Columns
55 | Ctrl + Alt + – | To Delete row/column |
56 | Ctrl + Alt + Shift + = | To Insert new row/column |
57 | Ctrl + Shift + 9 | To Unhide row |
58 | Ctrl + Alt + 9 | To Hide row |
59 | Ctrl + Alt + 0 | To Hide column |
60 | Ctrl + Shift + 0 | To Unhide column |
61 | Alt + Shift + Right arrow | To Group rows or columns |
62 | Alt + Shift + Left arrow | To Ungroup rows or columns |
63 | Alt + Shift + Down arrow | To Expand grouped rows or columns |
64 | Alt + Shift + Up arrow | To Collapse grouped rows or columns |
To Edit Notes and Comments
65 | Shift + F2 | Insert/edit note |
66 | Ctrl + Alt + M | Insert/edit comment |
67 | Ctrl + Alt + Shift + A | To Open comment discussion thread |
We sincerely hope that these tips are useful to you. You should be able to memorize these shortcut keys if you use Google Sheets on a regular basis. Please let us know in the comments if we missed anything or if you have any suggestions.