by Allen Wyatt
(last updated January 30, 2014)
Sheets allows you to easily associate a name with a range of cells and then use that name in formulas. This is a powerful feature, as it can make your formulas much easier to use. For instance, consider the following formula:
=A7 * B14
What does it do? From the information provided, you can't really tell much more than it multiplies the values stored in two cells. However, consider this formula:
= Subtotal * TaxRate
This formula also multiplies two values, but you can tell exactly what the formula is doing and what the result will be. The difference between the two versions of the formula is that the first one uses cell references while the second uses named references—names that refer to cells.
To create a named range, follow these steps:
Figure 1. Adding a named range.
That's it; now you can use the name in your subsequent formulas to make them easier to understand.
When you get a lot of data in a spreadsheet, it can be hard to zero in on the data you really need to work with. That's ...Discover More
If you want to turn a range of cells by 90 degrees within a spreadsheet, you need to understand how Sheets can handle the ...Discover More
When you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you ...Discover More