Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Utilizng full AutoFilter features while specific cells are protect
I have three worksheets going on with dynamic content between all three
worksheets (data is entered on sheet and then shows up on another sheet). I manually protected individuals cells that contain these formulas so a person could not inadvertently "screw things up." (Format/Protection/then clicked "Locked"). I then activated the protection feature for the entire worksheet (Tools/Protection/Protect Sheet). On the top of each worksheet sheet I activated the AutoFilter function so that each column in that worksheet can be filtered. When I click on the AutoFilter drop down menu I am able to filter each column by the lower options (All, Top 10, Custom, Blanks, Non Blanks) but I cannot use the two top options (Sort Ascending, Sort Descending). Is there a way to have the protection of formulas in individual cells and also have the ability to utilize the full functionality of the AutoFilter and sorting features? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Utilizng full AutoFilter features while specific cells are protect | Excel Discussion (Misc queries) | |||
Utilizng full AutoFilter features while specific cells are protect | Excel Discussion (Misc queries) | |||
Can I format to always AutoFilter specific cells | Excel Worksheet Functions | |||
Protect/Lock Specific Cells | Excel Discussion (Misc queries) | |||
How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) |