Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"working" filters on protected sheet
Hi
is it possible to lock a part of a worksheet and have a functional filters on the same sheet? I've tried to lock/unlock different cells, and tried other ways but I can't seem to find a solution. ex. (see below) I have a set of editable data ( this is where i need a filter) which rolls up on top of the worksheet (rolled up data should be locked and uneditable <-this sort of work like a dashboard of the below dataset...) can someone help? thanks! roll up (locked) Title 1 Title 2 Title 3 Title 4 Title 5 A data data data data data B data data data data data C data data data data data D data data data data data data (filter this row) Title 1 Title 2 Title 3 Title 4 Title 5 a1 data data data data data b1 data data data data data c1 data data data data data d1 data data data data data a2 data data data data data b2 data data data data data c2 data data data data data d2 data data data data data |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"working" filters on protected sheet
When you go to protest sheet, click on Use Autofilter checkbox.
OR, protect workbook. This will allow use of Autofilters as well. Have to ask, do you have any cells in the workbook that you want to be changed and saved? If not, just go to Tools - Options - Security and create a workbook password. Then, if anyone else opens the file, you can use it read-only and use all functions without ruining the book for anyone else! "filterdude" wrote: Hi is it possible to lock a part of a worksheet and have a functional filters on the same sheet? I've tried to lock/unlock different cells, and tried other ways but I can't seem to find a solution. ex. (see below) I have a set of editable data ( this is where i need a filter) which rolls up on top of the worksheet (rolled up data should be locked and uneditable <-this sort of work like a dashboard of the below dataset...) can someone help? thanks! roll up (locked) Title 1 Title 2 Title 3 Title 4 Title 5 A data data data data data B data data data data data C data data data data data D data data data data data data (filter this row) Title 1 Title 2 Title 3 Title 4 Title 5 a1 data data data data data b1 data data data data data c1 data data data data data d1 data data data data data a2 data data data data data b2 data data data data data c2 data data data data data d2 data data data data data |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ungroup "+" on a protected sheet | Excel Worksheet Functions | |||
sheet protected but cells "cleared of all" become locked | Excel Discussion (Misc queries) | |||
Why Can I not "Find" data in Protected Sheet | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Working out age from "Day" "Month" "Year" | Excel Worksheet Functions |