Forum Discussion
Excel Custom Sort Beyond Default Range
- 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!
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 a confusing format on how to select a column beyond SI. In this case the sort is on column SP.
"...SEVERAL columns" !!??!! Running beyond SI to (and beyond?) SP ???!!!
I can't even conceive of a table of data that has that many columns, and it's certainly more than "several," unless the first column is something like column SE. But even then, it boggles the mind to attempt to picture what sort of spreadsheet this is.
So I hope it's not asking too much to request that you give us an explanation of the overall structure of that Excel spreadsheet you're working with. Are columns A through column SP (and possible beyond) actually full of data? Does the table in question begin somewhere to the right of column A, and if so, where?
That aside--and I (and I suspect others) really would appreciate a clear description of what we're working with here--that aside, there is a SORT function, separate from the options available across the tool bar, and perhaps you could use it instead, but if we were sitting down face-to-face and I were a consultant you'd brought in, I'd want to understand your situation more fully before pointing you to any solution.
