11 great tips and tricks on Excel and Google Sheet

 1. Move back and forth between sheets

On Excel and Google Sheet, you can have multiple sheets open to work at once. To conveniently switch between sheets, do the following:

- Switch to the next sheet, you press Ctrl + PgDn.

Switch to the previous sheet, press Ctrl + PgUp.

2. Move quickly to the beginning and end of the row

To move from the beginning to the end of the row, as well as vice versa, if you drag it will be very time consuming, you can do as follows:

- Quickly move to the end of the row: Ctrl + down arrow.

- Move quickly to the first row: Ctrl + arrow up.

Note: Keyboard shortcuts only help you move to the last or leading row between cells with no blank cells.

3. Localize the selection for the table

Similar to moving from the top to the bottom of a row, if you want to select multiple rows, you have to drag the mouse for a long time. So you can use keyboard shortcuts instead.

- Select from beginning to end of the row: Ctrl + Shift + down arrow.

- Select from bottom to top: Ctrl + Shift + arrow up.

Note: Keyboard shortcuts only help you to select to the last or leading row between cells with no blank cells.

4. Double click to copy the formula

To quickly copy a formula to multiple cells, do the following:

Drag the mouse in the lower right corner until it shows the + sign and double-click to copy the formula to the end of the row.

5. Shortcut keys for quick formatting of data types

You can also format data types quickly through the following shortcuts:

- Format a decimal number with 2 numbers after the comma: Ctrl + Shift + 1 (!).

Currency format: Ctrl + Shift + 4 ($).

- Format percentage: Ctrl + Shift + 5 (%).

6. Combine 2 cells with the character "&"

One more tip that you cannot ignore is to simply concatenate the content of 2 cells through the character '&'. You do the following:

In the cell where the content needs to be concatenated, type: = cell 1 & cell 2. For example: = B2 & C2.

Note: There are no spaces between characters.

7. Quick summing using the ALT key

If you want to sum between cells quickly, do the following:

Drag and drop cells to be calculated and add an empty cell> Press Alt + "=".

Note: Applies to sum by column only.

8. Quickly fill in the current time in 1 box

When you need to fill current time in a cell, you do it quickly through the following steps:

Select the cell to fill> Press Ctrl + Shift + ";".

The box will automatically populate the current time on your computer  or  laptop clock   .

9. How to quickly hide 1 row and 1 column

When you want to hide a row or column, do the following:

- Hide rows: Select the row to be hidden> Press Ctrl + 9.

- Hide columns: Select the column to hide> Press Ctrl + 0.

10. View all cells in formulas

When you want to check the formula in a certain cell, you can do the following steps:

Select the cell to check the formula> Press Ctrl + "~".

You can view all existing formulas in your spreadsheet.

11. Turn cells into absolute value with button F4

The last trick you can apply is to turn the cell into its absolute value with the F4 button. To do this, do the following:

Select the cell you need to convert to absolute value> Press F4 key.

Above are articles about 11 great tips and tricks on Excel and Google Sheet you should know. Thank you for watching and please look forward to the next article!

Isabella Humphrey

Update 22 March 2021