Forum Discussion
Sorting an Excel table when it contains Named Cells
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
