Jun 30 2020 03:34 AM
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.
Jun 30 2020 04:28 AM
Jul 01 2020 12:25 PM
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
Jul 01 2020 12:39 PM
Hi @Abiola1,
Just to clarify, it seems to name each row instead of each cell, which is not what I want.
Best wishes.
Richard