Naming cells in Excel

Copper Contributor

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 Box

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

Hi @Abiola1,

 

Just to clarify, it seems to name each row instead of each cell, which is not what I want.

 

Best wishes.

 

Richard