Naming cells and ranges


show more Naming cells and ranges provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training show less
please wait ...

Naming cells and ranges

Before we can really talk about naming cells and ranges, we have to first have something to make that make sense. For example, every cell in your spreadsheet has a name already. The cell that's currently active is named A6, and this cell is named C4, and the cell is named D10. I know that because it has the D heading on my column and the 10 heading on my row. That's the active cell. It's just a cross-reference, very, very simple. But when I go to create formulas, formulas use these names, the default names, to refer to your mathematical statement. The mathematical statement is something that makes a lot less sense to a human being and a lot more sense to the computer, even though the computer is translating everything too. Let me show you what I mean. I'm jumping ahead a little bit here, but it really is necessary for us to pull up some formulas before we can talk about naming cells and ranges. Before I do formula let me just select B9, and in the name box, I'm goi...

Naming cells and ranges
Video duration: 5m 47s 4h 8m Beginner

Viewers:

Naming cells and ranges provides you with in-depth training on Business. Taught by Mark Swift as part of the Excel 2003 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...