Excel will not sort my entire sheet????

Hi,

I have an excel sheet that is not very large. It starts at A1 and goes to Q-112.

Row 1-3 are the Header Rows... The date is always in Column A... I need to sort by column A so that it keep things in chronological order. (Data is not always entered in chronological order)...

The problem is that when I get in cell A4 and click the <Sort> button, it only sorts A5-O112...

I have no idea why row A4 is not sorting or the other two columns P & Q??? Any help would be much appreciated!

Excel 2002- SP3

Wolvie

Try clicking in A3 then sorting. Or deselect the My Data Range Has a Header Row in the Sort window. By clicking in A4, Excel treats that has a header (hence, does not include in the sort range!)

As for cols P & Q, I would verify the existance of data in the first rows (P4:P5, Q4:Q5). Possible that Excel is ignoring this part of range because of blanks.

A workaround is to SELECT the entire range prior to sorting (i.e. select A4:Q112), click Data>Sort, select NO HEADER ROW, choose Column A to Sort By and click OK to sort.

How's that?

Good Luck