Forum Discussion
George_1
Aug 04, 2025Copper Contributor
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...
HansVogelaar
Aug 04, 2025MVP
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.