sorting data with two rows as column headings that reamian as headers

[Guest]

How do stop excell from automatically selecting the two top rows that contain headdings, when I use the sort comand on the data menu. This was not a problem until I allowed workbook sharing. Now I have to select the data manually to exclude the two header rows otherwise the headings are sorted to other rows which I do not want

thanks

 

[Charlie]

When you access the Sort menu look to see if the "My list
has" and Header Row is selected.

Charlie O'Neill

-----Original Message-----
How do stop excell from automatically selecting the two

top rows that contain headdings, when I use the sort
comand on the data menu. This was not a problem until I
allowed workbook sharing. Now I have to select the data
manually to exclude the two header rows otherwise the
headings are sorted to other rows which I do not want.

 

[Gord Dibben]

simon

Don't know how you did it with two header rows, but in the Data>Sort dialog
there is an option button for "My list has" Header Row, which will freeze the
top row.

Gord Dibben Excel MVP