From the course: Help Yourself: Tech Tips Weekly

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Naming cells

Naming cells

From the course: Help Yourself: Tech Tips Weekly

Start my 1-month free trial Buy for my team

Naming cells

“

- [Instructor] All cells in a worksheet are given names based on their column and row numbers. This is cell B3 and it's used as a key value elsewhere in the sheet. So rather than reference it as cell B3, I'm going to give it a name. You click in the name box, and you type the name for the cell. Rate in this case. So to make a calculation over here in cell H6, I'm going to type a formula equals left times and the rate, and you see that the rate also appears here in the shortcut menu, which is awesome. Press Enter and there's the formula. And if you edit the cell, you still see the name cell highlighted just as before to let you know where it is. I'm going to fill the entire column with values. Now, this range can also be given a name just as a single cell, so I can call it amount. Now, this range is known as amount and I can use it in a formula right here where I calculate the sum of amount and there's the name on the…

Contents