Putting Row 1 in the header

**winston2** · 01-10-2011, 05:35 PM

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!

**JBeaucaire** · 01-10-2011, 06:03 PM

Put a blank row in row 3 and squeeze it down really thin height-wise if you wish, so the data table really only has a one row header, which is standard.

Now you can sort your table and use the [x] Has Headers option in the sort window.

**outofthehat** · 01-10-2011, 06:06 PM

The problem here is that there are more than one header rows. If you only had one, life would be much simpler. So one option is to put a blank row in before the last header row, then hide that blank row.

You can then select any cell in the block of data and Data > Filter > Autofilter. You'll get drop-down arrows at the top of each column that you can use to sort as well as filter.