Google Sheets is an effective tool with a wide range of options for organizing and analyzing data. However, using spreadsheets and doing repetitive tasks can be hectic and time-consuming. Shortcuts for Google Sheets can help in this situation.
We will look at 22 important Google Sheets shortcuts in this article that will completely change the way you operate with spreadsheets.
What are the Basic Shortcuts of the Google Sheets?
There are many shortcuts that are used to perform different tasks in Google Sheets among which the basic shortcuts are discussed below.
Shortcut 1: Copying and Pasting Data
The shortcut keys for copying as well as pasting the data in both Windows and Mac are the same. For copying, we can use the CTRL+C and to paste the copied data, use the shortcut key of CTRL+V:
We can also use the CTRL+X to cut the data in the Google Sheets.
Shortcut 2: Undo and Redo Actions
The next important shortcuts to be known are the CTRL+Z to undo the last action and CTRL+Y to redo the last action. Both shortcuts can be used in operating systems: Windows and Mac.
Shortcut 3: Select the Cells
Select the first cell, then press the “SHIFT” key to select the remaining cells. To pick the other cells of the sheet, keep holding down the SHIFT key while using the left, right, up, and down arrow keys.
Shortcut 4: Select a Column or a Row
To select the entire row or a column, use the below-mentioned shortcuts:
| Description | Shortcut (Windows) | Shortcut (Mac) |
|---|---|---|
| Select Entire Row | Shift + Spacebar | Shift + Spacebar |
| Select Entire Column | Control + Spacebar | Control + Spacebar |
Shortcut 5: Insert and Delete Cells, Rows, Columns
To insert and delete the cells, rows, as well as columns, see the shortcuts in the below-mentioned table:
| Description | Shortcut |
|---|---|
| Insert Cell | Select the cell, then press the right button of the mouse and choose “Insert Cells” |
| Delete Cell | After selecting the cell, select “Delete Cells” by using the right mouse button. |
| Insert Row | Press the right mouse button after choosing the row number and then select “Insert 1 row above” or “Insert 1 row below” to insert a row. |
| Delete Row | Select the row number and then press the right key of the mouse. Choose the “Delete row” from the drop-down menu. |
| Insert Column | Press the right mouse button after choosing the column number and then select “Insert 1 column to right” or “Insert 1 column to left” to insert a row. |
| Delete Column | Select the column number and then press the right key of the mouse. Choose the “Delete column” from the drop-down menu. |
What are the Navigation Shortcuts of the Google Sheets?
Navigation shortcuts are used to access the specific cell in the Google Sheets. The basic shortcut keys of the Google Sheets are:
Shortcut 1: Moving Between Sheets
To move between different spreadsheets in Google Sheets, follow the below-mentioned table:
| Description | Shortcut (Windows) | Shortcut (Mac) |
|---|---|---|
| Next Sheet | Ctrl+Page Down | Command+Page Down |
| Previous Sheet | Ctrl+Page Up | Command+Page Up |
| Specific Sheet | Ctrl+Shift+Page Down /Ctrl+Shift+Page Up | Command+Option+Right Arrow / Command+Option+Left Arrow |
Shortcut 2: Navigating to the Beginning or End of a Sheet
To move the cursor either to the beginning or the end of the sheet, use the shortcuts:
| Description | Shortcut (Windows) | Shortcut (Mac) |
|---|---|---|
| Beginning of a Sheet | Ctrl+Home | Command+Home |
| End of a Sheet | Ctrl+End | Command+End |
Shortcut 3: Jumping to Specific Cells or Ranges
The shortcut keys for jumping to the specific cells or ranges in Google Sheets, below-mentioned shortcuts are helpful:
| Description | Shortcut (Windows) | Shortcut (Mac) |
|---|---|---|
| Go to a specific cell | Ctrl+G | Command+G |
| Head to the beginning of a column | Ctrl+Down Arrow | Command+Down Arrow |
| Go to the beginning of a row | Ctrl+Right Arrow | Command+Right Arrow |
| Select an entire column | Select the Column number and then Ctrl+Space | Select the Column number and then Command+Space |
| Select an entire row | Select the row number and then press SHIFT+SPACE | |
Shortcut 4: Find the Specific Word
Either find the specific phrase or replace the specified phrase with the new phrase. To do so, use the below-mentioned shortcuts on Windows and Mac:
| Description | Shortcut (Windows) | Shortcut (Mac) |
|---|---|---|
| Find | CTRL+F | Command+F |
| Find and Replace | CTRL+H | Command+Shift+H |
What are the Formatting Shortcuts in Google Sheets?
Different shortcuts are used to set the format of the data so it may look good. Basic shortcuts for formatting the data in Google Sheets are explained.
Shortcut 1: Applying Cell Formatting
The shortcuts which are used in formatting the data of cells are:
| Description | Shortcut (Windows) | Shortcut (Mac) |
|---|---|---|
| Bold | CTRL+B | Command+B |
| Italic | CTRL+I | Command+I |
| UnderLine | CTRL+U | Command+U |
| Strike Through | Alt + Shift + 5 | Option + Shift + 5 |
Shortcut 2: Adjusting Column Widths and Row Heights
To adjust the column’s width and height of the rows, the below-mentioned shortcuts should be used:
| Description | Shortcut | |
|---|---|---|
| Auto-fit column width | Double Click on the Right boundary of the column | |
| Adjust column width manually | Drag the hover present between the column either to the left or the right | |
| Auto-fit row height | Double-click on the button edge of the row | |
| Adjust row height manually | Drag the hover present between the rows either to the up or the down | |
Shortcut 3: Applying Text and Number Formatting
To change the formatting of the data in the cells of the Google Sheets, use the shortcuts:
| Description | Shortcut (Windows) | Shortcut (Mac) | |
|---|---|---|---|
| Increase font size | Ctrl+Shift+> | Command+Shift+> | |
| Decrease font size | Ctrl+Shift+< | Command+Shift+< | |
| Format as currency | Ctrl+Shift+4 | Command+Shift+4 | |
| Format as Percentage | Ctrl+Shift+5 | Command+Shift+5 | |
| Format as date | Ctrl+Shift+2 | Command+Shift+2 | |
| Remove formatting | Ctrl+\ | Command+\ | |
What are the Formula and Calculation Shortcuts in Google Sheets?
The formula and calculator shortcuts in Google Sheets which should be known to the users are explained below.
Shortcut 1: Inserting Formulas
To insert the formulas in the Google Sheets, use the steps mentioned below:
- Insert the equal “=” sign in the formula bar
- Select the range of the cell or cells on which the formula is supposed to apply
- Press the ENTER key
Shortcut 2: Auto-filling formulas
The formula entered in the cell can be applied either to the cells below or to the cells right in Google Sheets. Select the cell with the formula applied, a small box can be seen in the right corner of the cell, hold it, and drag it either to the right or down depending on your requirement.
Shortcut 3: Calculating Sums, Min, Max, Count, Count Numbers, and Averages
To calculate the sums, maximum, minimum, count, count numbers, and averages of the data in the cell. Select the cells and in the right bottom interface of the Google Sheets, you will see all these calculations:
What are the Collaboration Shortcuts in Google Sheets?
The collaboration shortcuts are used in Google Sheets to help the users in enhancing the teamwork and coordination with the other users.
Shortcut 1: Adding Comments
The shortcuts to add the comments in the Google Sheets are mentioned-below:
| Description | Shortcut (Windows) | Shortcut (Mac) | |
|---|---|---|---|
| Addition of the comment | Ctrl+Alt+M | Command+Option+M | |
| Edit a comment | Ctrl+Alt+E | Command+Option+E | |
| Delete a comment | Ctrl+Alt+Backspace | Command+Option+Backspace | |
What is the Shortcut to Add a New Sheet in Google Sheets?
If you are supposed to add a new sheet in the Google Sheets to complete your task, then you can use the shortcut key “Shift+F11” on Windows.
What is the Shortcut to Add a Today’s Date and Current Time?
We can add the present date and current time in Google Sheet by simply using the below-mentioned shortcut keys:
| Description | Shortcut (Windows) | Shortcut (Mac) | |
|---|---|---|---|
| To Add the Today’s Date | Ctrl+; | Command+; | |
| To Add the Current Time | Ctrl+Shift+; | Command+Shift+; | |
What are the Shortcuts to Copy, Paste, and Clear Formatting in Google Sheets?
We can also copy, paste, and clear the formatting in Google Sheets by using the below-mentioned shortcuts:
| Description | Shortcut (Windows) | Shortcut (Mac) | |
|---|---|---|---|
| Copy Formatting | Ctrl+Alt+C | Command+Option+C | |
| Paste Formatting | Ctrl+Alt+V | Command+Option+V | |
| Clear Formatting | Ctrl+\ | Command+\ | |
What are the Alignment Shortcuts in the Google Sheets?
To align the data to right, left, or in the middle, use the below-mentioned shortcuts:
| Description | Shortcut (Windows) | Shortcut (Mac) | |
|---|---|---|---|
| Alignment in Centre | Ctrl + Shift + E | Command + Shift + E | |
| Alignment to Left | Ctrl + Shift + L | Command + Shift + L | |
| Alignment to Right | Ctrl + Shift + R | Command + Shift + R | |
How to Link the URL in the Google Sheets?
To link the URL with any specific cell or data, select the cell to which the link is required and use the shortcuts:
| Description | Shortcut (Windows) | Shortcut (Mac) | |
|---|---|---|---|
| Link | Ctrl + K | Command + K | |
To open the hyperlink in the Google Sheets, use the shortcuts:
| Description | Shortcut (Windows) | Shortcut (Mac) | |
|---|---|---|---|
| Open the HyperLink | ALT+ENTER | Option+Enter | |
How to Display All the Sheets in Google Sheets?
To display all the sheets in Google Sheets, we can use the shortcut key shown below:
| Description | Shortcut (Windows) | Shortcut (Mac) | |
|---|---|---|---|
| To Display All the Sheets | Alt + Shift + K | Opion+Shift+K | |
Conclusion
There are many shortcuts in Google Sheets which make the work efficient but most important 22 shortcuts which should be known are discussed in this post. These 22 shortcuts can be used in different basic applications in Google Sheets, and make it easy for the user to work with the Google Sheets.
