Set options for sorting columns in a worksheet

I have a worksheet (more or less a template) on which I often have to sort 1
out of 4 columns at first (the 3rd one), then all 4 columns after (using the
1st of the 4 to sort, this time). I just switched to a newer version of
Excel and this new version keeps asking me if I want to expand my selection
because the program found data in adjacent cells.

Not such a big deal (2 more clicks), but it gets rather annoying, because I
used to have the job done immediately.

So I would like to know if somewhere in the program, there is a possibility
to modify the options for sorting and remove this internal check done by
default.

I don't think so. You could put a gap on either side (an empty column to both
the right and left of the column you wanted to sort).

Or just record a macro that sorts it the way you want.

And rerun that macro when you need to.

I think that this warning was added because of the number of users who actually
messed up their data by just sorting a single column (in error). I'd hate to
see it go (or even become a toggle).

FiluDlidu wrote:
>
> I have a worksheet (more or less a template) on which I often have to sort 1
> out of 4 columns at first (the 3rd one), then all 4 columns after (using the
> 1st of the 4 to sort, this time). I just switched to a newer version of
> Excel and this new version keeps asking me if I want to expand my selection
> because the program found data in adjacent cells.
>
> Not such a big deal (2 more clicks), but it gets rather annoying, because I
> used to have the job done immediately.
>
> So I would like to know if somewhere in the program, there is a possibility
> to modify the options for sorting and remove this internal check done by
> default.

--

Dave Peterson