View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Missing sort ascending or descending when go into "data" "sort

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


Jason wrote:

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

"Dave Peterson" wrote:

What do you see when you click on Data|Sort?

Jason wrote:

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?


--

Dave Peterson


--

Dave Peterson