Working with Google Sheets generally is a complicated process, particularly once you’re coping with in depth knowledge. However what for those who might simplify this course of and improve your effectivity? These shortcuts will not be nearly rushing up your work; they’re about reworking the way in which you work together with Google Sheets.
From fundamental navigation to superior features, these shortcuts are designed to make your spreadsheet expertise smoother and extra productive. Right here’s a full checklist of Google Sheets keyboard shortcuts for Home windows customers.
Google Sheets shortcuts for:
Frequent Actions
| Motion | Shortcut |
| Choose column | Ctrl + House |
| Choose row | Shift + House |
| Choose all | Ctrl + a, Ctrl + Shift + House |
| Undo | Ctrl + z |
| Redo | Ctrl + y, Ctrl + Shift + z, F4 |
| Discover | Ctrl + f |
| Discover and exchange | Ctrl + h |
| Fill vary | Ctrl + Enter |
| Fill down | Ctrl + d |
| Fill proper | Ctrl + r |
| Save (each change is saved mechanically in Drive) | Ctrl + s |
| Open | Ctrl + o |
| Ctrl + p | |
| Copy | Ctrl + c |
| Minimize | Ctrl + x |
| Paste | Ctrl + v |
| Paste values solely | Ctrl + Shift + v |
| Present frequent keyboard shortcuts | Ctrl + / |
| Insert new sheet | Shift + f11 |
| Compact controls | Ctrl + Shift + f |
| Enter instruments on/off | Ctrl + Shift + okay |
| Choose enter instruments | Ctrl + alt + Shift + okay |
| Instrument finder (previously Search the menus) | alt + / |
| Rename sheet | alt + 1 |
Format Cells
| Motion | Shortcut |
| Daring | Ctrl + b |
| Underline | Ctrl + u |
| Italic | Ctrl + i |
| Strikethrough | alt + Shift + 5 |
| Heart align | Ctrl + Shift + e |
| Left align | Ctrl + Shift + l |
| Proper align | Ctrl + Shift + r |
| Apply prime border | alt + Shift + 1 |
| Apply proper border | alt + Shift + 2 |
| Apply backside border | alt + Shift + 3 |
| Apply left border | alt + Shift + 4 |
| Take away borders | alt + Shift + 6 |
| Apply outer border | alt + Shift + 7 |
| Ctrl + Shift + 7 | |
| Insert hyperlink | Ctrl + okay |
| 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 foreign money | Ctrl + Shift + 4 |
| Format as proportion | Ctrl + Shift + 5 |
| Format as exponent | Ctrl + Shift + 6 |
| Clear formatting | Ctrl + |
| Motion | Shortcut |
| Transfer to starting of row | Residence |
| Transfer to starting of sheet | Ctrl + house |
| Transfer to finish of row | Finish |
| Transfer to finish of sheet | Ctrl + finish |
| Scroll to lively cell | Ctrl + Backspace |
| Transfer to subsequent sheet | alt + down Arrow |
| Transfer to earlier sheet | alt + up Arrow |
| Show checklist of sheets | alt + Shift + okay |
| Open hyperlink | alt + Enter |
| Open Discover | Ctrl + alt + Shift + i |
| Go to facet panel | Ctrl + alt + . |
| Ctrl + alt + , | |
| Transfer focus out of spreadsheet | Ctrl + alt + Shift + m |
| Transfer to quicksum (when a spread of cells is chosen) | alt + Shift + q |
| Transfer focus to popup (for hyperlinks, bookmarks, photos) | maintain Ctrl + alt, press e then p |
| Open drop-down menu on filtered cell | Ctrl + alt + r |
| Open revision historical past | Ctrl + alt + Shift + h |
| Shut drawing editor | Shift + esc |
Edit Notes and Feedback
Use Keyboard Shortcuts on Chosen Feedback
Open a Menu
Add or Change Rows and Columns
| Motion | Shortcut (Normal) | Shortcut (Google Chrome) | Shortcut (Different Browsers) |
| Insert rows above | Ctrl + alt + Shift + = | alt + i, then r | alt + Shift + i, then r |
| Ctrl + alt + = (with rows chosen) | |||
| Insert rows under | 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 chosen) | |||
| Insert columns to the best | alt + i, then o | alt + Shift + i, then o | |
| Delete rows | Ctrl + alt + – (with rows chosen) | alt + e, then d | alt + Shift + e, then d |
| Delete columns | Ctrl + alt + – (with columns chosen) | alt + e, then e | alt + Shift + e, then e |
| Cover row | Ctrl + alt + 9 | ||
| Unhide row | Ctrl + Shift + 9 | ||
| Cover column | Ctrl + alt + 0 | ||
| Unhide column | Ctrl + Shift + 0 | ||
| Group rows or columns | alt + Shift + proper Arrow | ||
| Ungroup rows or columns | alt + Shift + left Arrow | ||
| Develop grouped rows or columns | alt + Shift + down Arrow | ||
| Collapse grouped rows or columns | alt + Shift + up Arrow |
Use Formulation
| Motion | Shortcut |
| Present all formulation | Ctrl + ~ |
| Insert array system | Ctrl + Shift + Enter |
| Collapse an expanded array system | Ctrl + e |
| Present/disguise system assist (when coming into system) | Shift + f1 |
| Full/compact system assist (when coming into system) | F1 |
| Absolute/relative references (when coming into system) | F4 |
| Toggle system consequence previews (when coming into system) | F9 |
| Resize system bar (transfer up or down) | Ctrl + up / Ctrl + down |
| Toggle system vary choice (when coming into system) | F2 / Ctrl + e |
Assist for Display screen Readers
| Motion | Shortcut |
| Activate display reader help | Ctrl + alt + z |
| Allow braille help | Ctrl + alt + h |
| Learn column | Ctrl + alt + Shift + c |
| Learn row | Ctrl + alt + Shift + r |
#Google #Sheets #Keyboard #Shortcuts #Home windows #Customers
