Sort Warning disabled? Need to enable it

[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?

 

[Luke M]

Select all of your data before sorting. The warning only appears (sometimes)
if XL can easily detect that you ahve adjacent data.

 

[Gord Dibben]

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

 

[Vish]

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