Missing sort ascending or descending when go into "data" "sort"?

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

When I go into "data" "sort" I do not have the option of sorting into
ascending or descending? Any idea how I add or find this function?
 
Is the worksheet protected? Unless Allow Sorting was selected when the sheet
was protected you will not have the option to sort.
 
What do you see when you click on Data|Sort?
When I go into "data" "sort" I do not have the option of sorting into
ascending or descending? Any idea how I add or find this function?
Click to expand...
 
Hi
Apologies it is when I am using filter that the ascending/descending is not
present.

When I have highlighted a column with auto-filter I have the option of "top
10" "custom" or the entries in cells but I cannot sort in any way
 
Hi

Meant to say that it is when using auto filter - I have tried opening a new
spreadsheet and entering a few numbers and there is still no ascend/descend?
It only appears to be my computer - same spreadsheet on colleagues computer
will allow the function!

Thanks
 
You're using multiple versions of excel. The older version (at home???) doesn't
have that feature. The newer version (at work???) has it.
 
Back
Top