I'd guess that the entire range wasn't selected before clicking on Data|Sort.

I always select my entire range first and never let excel guess--just in case it
guesses wrong and I don't notice it.

You may be able to format the header differently (bolding the font) so that
excel will guess that the range to be sorted has header rows.

If you're using xl2003 (or higher), you can apply data|filter|autofilter.
There's an option under each arrow that allows you to sort the filtered range by
that field.

But those empty rows scare me. Excel may not see them as part of your range to
be sorted.

If you're using xl2002 or below (or any version of excel, really), you can use a
technique at Debra Dalgleish's site:

http://contextures.com/xlSort02.html

ramona wrote:

Dear Experts,

I've looked through almost all the posts and could not find an answer to this.

I have a spreadsheet (Excel 2003) with 10 columns that have been sorted
everyday for the last few months. The users delete info from a particular
row between 5 & 21 (information only, NOT the row), then highlight rows 5-21,
click DataSort, have been choosing the header column name from the first
'Sort by' option (header is in row 4), click OK and it sorts without having
to click any other buttons. Today, the 'Sort by' options in the drop down
list are showing the info in row 5 not the header names. Can anyone tell me
what's happened? Why would they now, after all this time, have to choose the
'No header row' button?

I'm just a little stumped. What am I missing and is there a way to default
the 'No header row' button?

Thanks for any and all your assistance!!!
ramona

--

Dave Peterson