Hello. We work with a typical excel spreadsheet. Rows 1,2,3 have all of our "header" information, and the rest of the rows are data.
The problem is, we sort the data on a daily basis, and when we do this, our "header" rows (rows 1,2,3) are always moved to the bottom of the spreadsheet. Even if I freeze rows 1,2,3, the rows are STILL put at the bottom of the spreadsheet when I do the sort.
I know that one way to avoid this is to simply highlight only the data that I want sorted and then do the sort... But I want to avoid this if at all possible.
Is there any command on excel that will automatically exclude the header rows from being sorted?
Thanks!
Bookmarks