Make the Formulas Simple by Applying Names to Range of Cells [Google Doc Spreadsheet]
Hope you are a regular reader of our Google Doc Spreadsheet tutorials. We already have some rich content there to help you improve your online Spreadsheet needs. Here in this quick Google Doc Spreadsheet tutorial, we are covering the fruitfulness of using “Naming Ranges”.
Ever wonder seeing an unfamiliar formula in Spreadsheets? It may be formulas containing named ranges. You can name a group of cells with the name you want in a Spreadsheet. Check the below table where you can see that cells D4:D9 contains sales value. So if you want to total it, you can use the formula;
But for making your formula more readable and simple, you can first name ranges D4:D9 and use it in your formula. To name a range of cells in Google Doc Spreadsheet, first select the cells and go to Data menu, Named Ranges.
Type an appropriate name to the range, here “Salesvalue” and click “Done”. So that you can use formula like this;
Points to be noted:
When you insert a row between the named ranges, it automatically added to the range. The name of the range will be “Salesvalue” but the range will be D4:D10 instead of D4:D9.
If you insert a row before the first row or after the last row in the range, it will not be included automatically. You need to edit the named ranges to include additional rows.
Apply naming ranges and make your spreadsheet experience more entertaining.
About Article Author
It is not necessary to depend PowerPoint to make ‘powerful’ presentations. You can use Google Drive Presentation easily to make
In this tutorial I will explain you how to use Data Validation on Google Doc Spreadsheet. It is important to
We can create unit calculators using Google Doc spreadsheet for our day to day spreadsheet purpose. It can ease our
This is an ultimate tutorial for creating an advanced online form. Before coming to the tutorial few aspects about online
When you have a long range of data arranged in row wise and want to change it into column wise,
You can save your time in entering data in spreadsheets by intelligently using certain commands. There are lots. In this