| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing sort ascending or descending when go into "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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Missing sort ascending or descending when go into "data" "sort"?
Is the worksheet protected? Unless Allow Sorting was selected when the sheet
was protected you will not have the option to sort. -- HTH... Jim Thomlinson "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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Missing sort ascending or descending when go into "data" "sort
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 "Jim Thomlinson" wrote: Is the worksheet protected? Unless Allow Sorting was selected when the sheet was protected you will not have the option to sort. -- HTH... Jim Thomlinson "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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Missing sort ascending or descending when go into "data" "sort"?
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Missing sort ascending or descending when go into "data" "sort
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The "Sort" function is missing....... | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
Hybrid Mode
