Prev: outlook 2007 wont recognize my profiles
Next: saving with excel 2007 and oppening with excel 2003
From: gnat on 1 Apr 2010 12:41
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?
From: Luke M on 1 Apr 2010 12:52
Select all of your data before sorting. The warning only appears (sometimes)
if XL can easily detect that you ahve adjacent data.

--
Best Regards,

Luke M
"gnat" <gnat(a)discussions.microsoft.com> wrote in message
news:95B1329C-2A83-4C37-8010-BF0E0BC1D10A(a)microsoft.com...
>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?


From: Gord Dibben on 1 Apr 2010 12:55
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 <gnat(a)discussions.microsoft.com>
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?

 | 
Pages: 1
Prev: outlook 2007 wont recognize my profiles
Next: saving with excel 2007 and oppening with excel 2003