autofilter sort not visible

G

Guest

I created an excel file and have autofilter applied.
Obviously, it gives me the option to filter, or to sort ascending/descending.
I sent it to the person who needs to use it.
They opened it, however, when the click on a column heading to filter, the
sort ascending/descending option is not visible, and they can only filter.
Is there any reason for this?
the sheet isn't protected/shared or anything. I have tried disabling
autofilter, and re-applying the autofilter on the user's pc.
Is this just a quirky excel thing?

Thanks for the help.
 
D

Debra Dalgleish

Perhaps you're using different versions of Excel. The Sort command is
only available in the AutoFilter dropdown in Excel 2003, not earlier
versions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top