Forum Discussion
Naming cells in Excel
I am trying to individually name cells in a large spreadsheet using a combination of the row and column headers for each cell. I don't want to name each cell individually, as it will take days. When I use Formulas>Create from selection, it names the whole range with the row and column headers, but not each cell individually with a combination of the two (I want each cell to have a unique name). Is there any way I can do this?
Thanks.
3 Replies
- Hello,
As you know, you can name ranges using the Create from Selection in the Formulas tab.. Or you name from the Name BoxHi Abiola1,
Just to clarify, it seems to name each row instead of each cell, which is not what I want.
Best wishes.
Richard
Hi Abiola1 ,
Yes, but as I understand it (and as it happens when I actually do it) choosing a range of cells names only the range of cells itself, not each cell within the range individually.
I want to quickly name a large number of cells individually by reference to their row and column labels. How do I do that?
Many thanks,
Richard
