Naming cells in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1498165%22%20slang%3D%22en-US%22%3ENaming%20cells%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498165%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20individually%20name%20cells%20in%20a%20large%20spreadsheet%20using%20a%20combination%20of%20the%20row%20and%20column%20headers%20for%20each%20cell.%20I%20don't%20want%20to%20name%20each%20cell%20individually%2C%20as%20it%20will%20take%20days.%20When%20I%20use%20Formulas%26gt%3BCreate%20from%20selection%2C%20it%20names%20the%20whole%20range%20with%20the%20row%20and%20column%20headers%2C%20but%20not%20each%20cell%20individually%20with%20a%20combination%20of%20the%20two%20(I%20want%20each%20cell%20to%20have%20a%20unique%20name).%20Is%20there%20any%20way%20I%20can%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1498165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498232%22%20slang%3D%22en-US%22%3ERe%3A%20Naming%20cells%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498232%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20you%20know%2C%20you%20can%20name%20ranges%20using%20the%20Create%20from%20Selection%20in%20the%20Formulas%20tab..%20Or%20you%20name%20from%20the%20Name%20Box%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
Hello,

As you know, you can name ranges using the Create from Selection in the Formulas tab.. Or you name from the Name Box
Highlighted

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

Highlighted

Hi @Abiola1,

 

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

 

Best wishes.

 

Richard