autofilter sort not visible

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Similar Threads

How to Sort within AutoFilter with Protection on (and AutoFilter . 1
AUtofiltering dates 1
Sorting with AutoFilter 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting while protected - this question may not have been covered. 1
AutoFilter issues 4
Cannot See Sort Ascending/Descding option in drop down filter 1
Excel 2003 - turn off option in autofilter 1

Back
Top