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