Freeze top 2 rows when sorting and exclude row 2 from the sort

[hockingrs]

Hi,

Office 10, Excel version 14

I'm using Data/Filters, with headings in rows 1 and 2. When I sort, row 2 naturally sorts as well, as only row 1 has been recognised as a heading by filtering.

I can easily freeze the top row from scrolling, but I'd also like to freeze the 2nd row, and exclude it from sorting as well.

Thanks!

Roger

 

[silentwolf]

Hi,
why don`t you just enter the Column heading with "Alt + Return" then it looks like two heading column but it is just one.

HTH

 

[hockingrs]

Thanks for the reply Silentwolf.

Row 1 contains merged cells, one for each day of the week. So "Friday" is a merge of 12 cells.
Row 2 contain single cells, and under "Friday" is 12 cells with the numbers 1 to 12, indicating 12 hours under the day.

So I don't think Alt+Returns helps me here...

 

[silentwolf]

Hi,
Yes you are right that will not help..
I did not know that you merged cells and that a week has 12 cells well I need to pass on that one..
Hope someone can help you with this issue..