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