Here most used Google Sheets Shortcuts that’s useful when you’re working in a Google Spreadsheet. In a simple term, I can state Google Sheet as an online version of Microsoft Excel. Google Sheets is one of the programs of the G-suite device. Learn Top 10 Google Sheets Formulas for Beginners. Google sheets will allow users to create and edit files online, Download Google Sheets Shortcuts PDF. The changes made in the Google Sheet are saved automatically.
Google Sheets Shortcuts List, Google Sheet Shortcut Keys pdf
Summary
Google Spreadsheet also comprises a lot of functions and formulas just like Microsoft Excel. Hence, working with a mouse with all these functions will be quite a difficult task. And so to the rescue comes the Google Sheets Shortcuts. Below are the various Google Sheets shortcuts which will help you to work with Google sheet effectively. You can even download these Google Sheets shortcuts PDF here, Google Sheet Shortcut Keys PDF.
General Shortcuts
| Action | Shortcut Keys |
|---|---|
| Open options | Ctrl + O |
| Undo last action | Ctrl + Z |
| Redo last action | Ctrl + Y |
| Copy selected cells | Ctrl + C |
| Repeat last action | Ctrl + Shift + Z or F4 |
| Cut selected cells | Ctrl + X |
| Paste content from clipboard | Ctrl + V |
| Display paste special dialog box | Ctrl + Shift + V |
| Display Find option | Ctrl + F |
| Display Find & Replace | Ctrl + H |
| Save[by default save in Drive] | Ctrl + S |
| Ctrl + P | |
| Show common keyboard shortcuts | Ctrl + / |
| Insert new sheet | Shift + F11 |
Read more
Learn Everything about Google Sheets like How to use, Templates etc.
Borders Shortcuts
| Action | Shortcut Keys |
|---|---|
| Apply border outline | Alt + Shift + 7 |
| Add border top | Alt + Shift + 1 |
| Add border right | Alt + Shift + 2 |
| Add border bottom | Alt + Shift + 3 |
| Add border left | Alt + Shift + 4 |
| Remove borders | Alt + Shift + 6 |
Formatting Shortcuts
| Action | Shortcut Keys |
|---|---|
| Apply bold formatting | Ctrl + B |
| Apply italic formatting | Ctrl + I |
| Apply underline formatting | Ctrl + U |
| Apply strikethrough formatting | Alt + Shift + 5 |
| Align center | Ctrl + Shift + E |
| Align left | Ctrl + Shift + I |
| Align right | Ctrl + Shift + R |
| Clear formatting | Ctrl + \ |
Read more
The 15 Most Useful Google Sheets Formulas – VLookup and ImportHTML Formulas etc.
Number Formatting
| Action | Shortcut Keys |
|---|---|
| Apply number format | Ctrl + Shift + 1 |
| Apply time format | Ctrl + Shift + 2 |
| Apply Date format | Ctrl + Shift + 3 |
| Apply currency format | Ctrl + Shift + 4 |
| Apply percentage format | Ctrl + Shift + 5 |
| Apply exponent format | Ctrl + Shift + 6 |
Entering Data
| Action | Shortcut Keys |
|---|---|
| Move right | Tab |
| Move left | Shift + Tab |
| Enter the same data in multiple cells | Ctrl + Enter |
| Fill down from above cell | Ctrl + D |
| Fill right from cell left | Ctrl + R |
| Add hyperlink | Ctrl + K |
| Insert current time | Ctrl + Shift + ; |
| Insert current date | Ctrl + ; |
| Insert current date and time | Ctrl + Alt + Shift + ; |
Selection Shortcuts
| Action | Shortcut Keys |
|---|---|
| Select entire row | Shift + Space |
| Select entire column | Ctrl + Space |
| Select entire google sheet | Ctrl + A |
| Select entire google sheet | Ctrl + Shift + Space |
| Add adjacent cells to selection | Shift + Click |
| Add non-adjacent cells to selection | Ctrl + Click |
| Scroll to the active cell | Ctrl + Backspace |
Extend Selection Shortcuts
| Action | Shortcut Keys |
|---|---|
| Extend selection by one cell right | Shift + → |
| Extend selection by one cell left | Shift + ← |
| Extend selection by one cell up | Shift + ↑ |
| Extend selection by one cell down | Shift + ↓ |
| Extend the selection to the last cell right | Ctrl + Shift + → |
| Extend the selection to the last cell left | Ctrl + Shift + ← |
| Extend the selection to the last cell up | Ctrl + Shift + ↑ |
| Extend the selection to the last cell down | Ctrl + Shift + ↓ |
| Extend selection up one screen | Shift + PageUp |
| Extend selection down one screen | Shift + PageDown |
| Extend selection right one screen | Alt + Shift + PageDown |
| Extend selection left one screen | Alt + Shift + PageUp |
Navigation
| Action | Shortcut Keys |
|---|---|
| Move one cell right | → |
| Move one cell left | ← |
| Move one cell up | ↑ |
| Move one cell down | ↓ |
| Move one screen right | Alt + PageDown |
| Move one screen left | Alt + PageUp |
| Move one screen up | PageUp |
| Move one screen down | PageDown |
| Move to right edge of data region | Ctrl + → |
| Move to left edge of data region | Ctrl + ← |
| Move to top edge of data region | Ctrl + ↑ |
| Move to bottom edge of data region | Ctrl + ↓ |
| Move to beginning of row | Home |
| Move to the beginning of sheet | Ctrl + Home |
| Move to end of row | End |
| Move to end of sheet | Ctrl + End |
You May Also Like
Keyboard Shortcuts for Google Docs
21 Shortcuts for Google Slides (Windows)
Most useful Google Chrome Shortcuts for Win & Mac
List of Important Spreadsheet Formulas
Best 5 Google Docs Template useful in 2020
Keyboard Shortcuts for Kingsoft Spreadsheets
With all the above Google Sheet Shortcuts you can present your data with colourful charts and graphs. There are Google Sheets Shortcuts for Pivot Tables, conditional formatting and many more which will save time and simplify the task. There are a variety of templates available like a budget template, expense template, schedules and many more. If you want us to customize Google template for you. Feel free to mail here.
After having a look at the Google Sheets Shortcuts, let’s take a look at the Kingsoft Spreadsheet shortcuts which are more or less similar. Hope you have liked our blog on Google Sheets Shortcuts. Suggestions are always welcomed for the blog you looking forward to hearing from us. Connect with us and Take your Office Productivity to Next Level.
