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

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?
 
J

Jim Thomlinson

Is the worksheet protected? Unless Allow Sorting was selected when the sheet
was protected you will not have the option to sort.
 
D

Dave Peterson

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?
 
J

Jason

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
 
J

Jason

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
 
D

Dave Peterson

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

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