Make Use of Add-ons

Tips and Tricks to Use Google Sheets

...

1. Freeze Rows and Columns

Here are some tricks and tips that you can use on Google Sheets and make your work much easier:...

2. Conditional Formatting

...

3. Use Alternate Colors

...

4. Make Use of Add-ons

Another trick that you can save a lot of time when working on the spreadsheet is using alternate colors. You can add alternate colors to the rows instead of coloring manually, which can be done in two ways....

5. Make use of a Template

Add-ons can be run inside Google Sheets, Docs, and Forms. These are tiny programs that developers use to do more on the spreadsheet. With this, you can easily add sidebars and quickly connect to many Google services....

6. Put Comments and Notes

Templates are an ideal way to save time when working alone or in a group with a G suite. It is not easy for you to recreate a report or newsletter; whenever you start creating a new report, it is not possible. Many time-saving templates offered by Google let you use the documents instead of struggling to put all of them together....

7. Check Version History

...

8. Create Sum Formula

...

9. SUMIF

Using the sum formula, you can easily add the values in the cells. You can select SUM from the drop-down list of Functions, or you can enter the formula by typing =SUM. You can hold the shift key to select the cells and add them together or add values between parentheses and press enter....

10. Average

It is a must have in the Google Sheet formula list. The Sumif formula will let you sum the values in the cells only if certain conditions are met. It is easy to select Sumif from the math men you find in the formula drop-down list. You can also enter = Sumif in the empty cell and set the condition saying that if the value is less than or greater than this value, then add. Once the condition is set and the cells you want to add between parentheses, press enter....

11. Sort

The average formula will let you get the average of the data in the selected cell range. It is easy to find the average of cells in one column or row (or)....

12. TEXT

The sort Google sheet advanced formula will be used to sort the cells with numerical data in ascending and descending order....

Conclusion

You can add this to the Google Sheets formula cheat sheet. The text formula will convert the cells that contain currency, decimals, and dates into the text format. You can use this formula by typing...

FAQs – Google Sheets

You can make the most out of the Google Sheets by following the combo of formulas and formatting options mentioned in this article . These formulas will also help you to reduce the time required for performing all these operations manually. Using these tips, you can customize the sheet briskly. The best thing is that you can create a template of the sheet you have formatted and can use this sheet for regular tasks you carry out on sheets....