Sort Range Issue

[MikeG]

I have a data table and when I sort it, either with the Sort command on the Ribbon, or using the "A to Z" button I have in my Quick Access Toolbar, Excel assumes that the table is three rows higher than it really is. In order to do the sort, I have to use the Sort function and "redefine" the table area.

Now, I have had a similar thing sometimes in the past, but it has always been because I accidently left text or a formula in a column or row adjacent to the table. In this current case, there are no such problems - all the cells around the table are empty.

Other people use the workbook and they might have done something. Does anyone know how to help. Is there a place where I can see what Excel is assuming for the area and change it permanently?

I'm using Excel 2007.

Thanks,

MikeG

 

[shg]

Try deleting those rows.

 

[MikeG]

Try deleting those rows.

Thanks. That worked. I guess Excel just got confused.

MikeG