Every single person on this planet is on the lookout for shortcuts and easy ways to navigate through their work. The same applies to the Google Sheets as well. You have a row of data and suddenly you need to check the sum or average of the data for better reporting. How do you do it without formulas?
Sounds next to impossible, doesn’t it? Well, this is where you are wrong. In Google Sheets, you can select the cells with the data that you want to see the basic calculations for and then go ahead and get them sorted. But, how?
That is what we have discussed and explored in detail in this guide. We have addressed how to see basic calculations without formulas in Google Sheets, the methods and the shortcuts that will help you in the long run.
Steps to See Basic Calculations Without Formulas In Google Sheets:
- Open Google Sheets with pre-filled values or enter the values :
- Now, select the cells you want to see common calculations:
- On the selected columns, you will notice on the right bottom hand side the calculations of the cells:
- Now, if you click the option you will see different calculations: