When working large amounts of data, it’s easier to identify groups of cells that contain related data. In the following example, cells C5 through C8 contains price information related to list of items.
Rather than specifying the cells individually every time we use it we can define range also called as named ranged and perform operations on the cell.
In the Previous Example we can name the range of Price Item that is from C5 to C8 as PriceList.
And whenever we want to use the contents of that range in a calculation, we can simply use the name of the range instead of specifying each cell individually.
To Create a Name Range Follow the Steps:
1. Click on Insert –> Name-> Define
2. Define a name and select the “Refer to” option and select the cells which will be part of the name range. We have chose “Refers To” as C5 to C8 and Name as “Price List”.
3. Press OK
Now we can use the Range Name in any of our calculation.
In example below we are summing up the price using the range name.
The above example will give us the sum of the prices.
Related posts:
