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!