0

So I would like to be able sort all my data using the little drop down arrow created by the filter function, all the way from F to JE. At the moment it will only sort from F to AK.

Any idea how I can fix this? It needs to sort regardless of whether there are blanks or not

screenshot

Improve this question

2 Answers 2

Reset to default
1

Ensure you highlight all the data you want to filter / sort before you hit filter.

Improve this answer
0

All your Column should have headers even if no data under it, if the whole column is blank the sort will stop just before it

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .