Forum Discussion
Larry_Paxton
Jul 13, 2023Copper Contributor
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 ...
- Jul 15, 2023Thanks, 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!
Kansan1956
Jul 25, 2024Copper Contributor
I am working on a spreadsheet that has columns A-S however, when I attempt to sort the data the AZ Sort and filter icon is grayed and will not allow me to select the option. What is going on?