Forum Discussion
Richard1963
Jun 30, 2020Copper Contributor
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 ...
Abiola1
Jun 30, 2020MVP
Hello,
As you know, you can name ranges using the Create from Selection in the Formulas tab.. Or you name from the Name Box
As you know, you can name ranges using the Create from Selection in the Formulas tab.. Or you name from the Name Box
Richard1963
Jul 01, 2020Copper Contributor
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