Do you have any blank columns?

Excel will only ask to expand if it notices adjacent data, otherwise it just
picks the current region.

I never leave it up to Excel in any case.

Pre-select all columns you want included in the sort.


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 09:41:01 -0700, gnat
wrote:

I am trying to Sort from A-Z, but the normal warning to expand the selection
does not appear? Is there some way to enable this or work around it to
filter the entire document by the column I choose?