Sorting an Excel table when it contains Named Cells

Occasional Contributor


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


4 Replies

Hi @Beepee2021 ,


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







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.







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.