I have a sheet and need to be able to sort the sheet except for the top few rows as they are linked to reports / sights. How can I do this?
I should clarify that I would like to do it by clicking the header and sorting, not selecting all the rows I want sorted and sorting.
A workaround could be to have a checkbox column called something like "Top Rows" and sort on that first (decending), then sort with your other rules. Of course, you only get 3 levels of sorting, so this burns one of those.
