From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Enhancing readability with range names

Enhancing readability with range names

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Enhancing readability with range names

- In Excel, you can name a cell or name a range of cells. And then you can use those names in formulas. And sometimes it's really helpful to clarify what a formula is doing. In other words, a cell address, although fine and appropriate, is nearly as clear as a name, provided it's a sensible name. I'm about to write a formula in Cell I2 to calculate a new salary. And everybody on the list here, moving down Column I, is going to get a 2.91% increase, so that's in Cell K1. All these cells will be referring to that, and I'll start off with just a simple formula. We could do this in two or three different ways, certainly. One way to write this formula =G2*K1. We want this to be an absolute address, so I'll press the function key F4 and +G2. We have our answer. We can copy it down the column. However, what if we were to name that cell? Then we could use the name in the formula. It's going to be a little bit clearer, and the cell, by the way, if it's farther away, possibly this cell might be…

Contents