Forum Discussion
Solved
Excel Custom Sort Beyond Default Range
There are several columns in an Excel spreadsheet. From the Home page when clicking on Sort & Filter, then selecting Custom Sort, then going to the Sort by option it goes up to column SI, then gives ...
- Thanks, Detlef, that's the example I was looking for! When I click on the "(More columns...)" and put SP in the box, then click OK, I get an error message. However, when I type in SP:SP it works perfectly. That's not intuitively obvious from the message, and I was unable to find that answer in any of the Help sections. Thanks again!
It seems you reached one of many restrictions in Excel.
It is very clear what the message says:
Click on the button on the right, select the column, click on the button on the right again, click OK.
Alternatively you can type the column reference into the box: TS:TS
Thanks, Detlef, that's the example I was looking for! When I click on the "(More columns...)" and put SP in the box, then click OK, I get an error message. However, when I type in SP:SP it works perfectly. That's not intuitively obvious from the message, and I was unable to find that answer in any of the Help sections. Thanks again!