Any blank rows or columns?

I have found over the years and several versions of Excel to not let Excel
guess the range,

Select all columns to be sorted before hitting the Sort button.


Gord Dibben MS Excel MVP

On Tue, 29 Sep 2009 09:11:02 -0700, markholt
wrote:

Something has happened to my file that causes Excel 2007 to select PART of my
file when I sort. I've looked at everything & can't figure why it's doing
this. When I click sort - I want the whole sheet sorted.

No fields or columns are hidden.

If I work fast I risk getting my info all srewed up ....

Mark