Dec 23 2021 06:44 AM
I have an Excel SS with multiple columns of data. I have some rows interspersed with that data that I want to have ignored or not included in a column data sort. I want the row left in place and the rest of the data sorted around or above and below these excluded rows. How can I do this? Thanks.
Dec 23 2021 07:49 AM
You'd have to hide the rows that you don't want to be sorted.
Dec 23 2021 07:51 AM
@Hans Vogelaar Thanks Hans. I do not want to hide them. I want them to remain visible and in place after the sort.
Dec 23 2021 11:26 AM
As far as I know, sorting in Excel doesn't work that way, so what you want is not possible.
You might create a macro that:
Dec 23 2021 09:48 PM