Sorting an Excel table when it contains Named Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2976313%22%20slang%3D%22en-US%22%3ESorting%20an%20Excel%20table%20when%20it%20contains%20Named%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2976313%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%202016.%20I%20have%20a%20three%20column%20table%20with%20Namd%20Cells%20in%20many%20of%20the%20column%20three%20entries.%20If%20I%20use%20any%20sort%20function%20it%20does%20not%20take%20the%20cell%20name%20with%20the%20sorted%20entry.%3C%2FP%3E%3CP%3EIs%20this%20just%20how%20it%20is%20or%20am%20I%20missing%20something%3F%3C%2FP%3E%3CP%3EThanks%20in%20anticipation%3C%2FP%3E%3CP%3EBeepee%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2976313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2981483%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20an%20Excel%20table%20when%20it%20contains%20Named%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981483%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416742%22%20target%3D%22_blank%22%3E%40Beepee2021%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emaybe%20you%20could%20provide%20a%20screenshot%20of%20your%20table%2C%20so%20it's%20easier%20to%20understand%20what%20the%20issue%20is.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi.

I am using Excel 2016. I have a three column table with Namd Cells in many of the column three entries. If I use any sort function it does not take the cell name with the sorted entry.

Is this just how it is or am I missing something?

Thanks in anticipation

Beepee

4 Replies

Hi @Beepee2021 ,

 

maybe you could provide a screenshot of your table, so it's easier to understand what the issue is.

@Beepee2021 

 

Beepee2021_1-1637687043155.png

 

Beepee2021_2-1637688053855.png

 

Cells in column AD are given a cell name as per the bold part of the text.

In the top-most screenshot the 'live' cell AD203 has the correct cell name. After adding a new item (Alyssum Cotton Candy) at the end of the table and naming the cell, I carry out a custom sort (on the first three columns) and the new entry takes its rightful place in the table. However the Named Cell for this entry is still at the foot of the table. The new entry now has the Cell Name for the item it replace in the alpha sequence. All Cell Names below this entry are now misplaced by one row.

 

Hopefully this explains the problem better.

Regards

Beepee

 

 

 

 

Hi @Beepee2021 

 

thanks a lot for the screenshots and explanations, now the issue is completely clear.

But unfortunately, this behaviour seems to be an Excel "feature" (you might call it a bug). So only the contents are sorted, but not the range names.

If this is good or bad, depends on the situation. In your case, this is of course not the desired behaviour, in others it might be.

I'm sorry, but I do not think you can do anything about it...

Hi Mark. Thank you for the very quick response. Yes, I guess there may be times we want the cell names to stay put but on this worksheet it would have been good if they moved. Not a hard problem to overcome; I just have to remember to use INSERT and enter new items in the right place. I just needed to know that it wasn't something about the way i was naming the cells or some such. Thanks again.
Beepee