| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "sort" in auto filter not possible when protected?
I have a sheet that is protected and uses autofilter. The "Allow Autofilter"
box is checked and autofilter does work when protected. However, in the autofilter drop-down box, if I choose sort ascending or descending, it will not. I have also tried checking the "Allow Sort" box - no luck. Is it possible to sort with autofilter when a sheet is protected? NOTE: Using Excel 2007. All cells to be sorted/filtered are not protected when the sheet is. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing sort ascending or descending when go into "data" "sort"? | Excel Discussion (Misc queries) | |||
| Auto Filter - how to collapse "non-blank" cells in a column? | Excel Discussion (Misc queries) | |||
| how to auto "copy & paste" (or filter) from a Master spreadsheet? | Excel Worksheet Functions | |||
| Change the Auto-filter that is "on" to a RED arrow, can't see blu | Excel Worksheet Functions | |||
| Q: Auto filter "selected" color | Excel Discussion (Misc queries) | |||
Linear Mode
