Sort Warning disabled? Need to enable it

  • Thread starter Thread starter gnat
  • Start date Start date
G

gnat

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?
 
Select all of your data before sorting. The warning only appears (sometimes)
if XL can easily detect that you ahve adjacent data.
 
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
 
Thanks Gord, it worked for me. Some time we try to find out settings instead of pre-requisite of the required functionality..I was so spend a lot of time to do r & d to find out settings :)

Thanks again
 
Back
Top