Forum Discussion
Excel won't sort properly.
Beginning a few months ago Excel forced me to make a choice between options to expand my sort to continue sorting only with what I've highlighted. Neither option allows me to sort properly. Sorting...
If you select a range that has adjacent non-blank cells, Excel will always ask whether you want to expand the sort range. To avoid that, make sure that the selected range is isolated, i.e. the adjacent cells are all blank.