Forum Discussion
Ignore multiple rows in a column sort?
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.
4 Replies
You'd have to hide the rows that you don't want to be sorted.
HansVogelaar Thanks Hans. I do not want to hide them. I want them to remain visible and in place after the sort.
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:
- Hides the rows you don't want to sort.
- Sorts the range on the column(s) you want.
- Unhides all rows.
