Referencing

[JHarriman]

I am a real Excel novice. Is a reference to a row made only by the
number? Is there anyway to reference a row with a name? If I update
my page from outside Excel and let's say "Apple" which used to be in
row 10 is in row 11 after the update. If I had referenced row 10 from
another sheet for Apple data, do I have to change that reference to row
11 after the update?

Thanks for any info.

 

[Guest]

Yes:

You can assign a Name to a cell, a group of cells, a row or a column.

Insert > Name...

 

[dmexcel]

Hi J
I was experimenting and found the following:
I selected row 10 and named it apple
In row 7 I inserted another row and then went to range names and coosed
apple
It took me to row 11 !!!

 

[dmexcel]

Ok I spelled chose wrong!!!!!!