Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked cells
Is there any simple way of identifying all locked cells on a sheet?
-- Boots |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked cells
Are you using Format|Conditional Formatting for anything?
If no, then how about using it to show the locked/unlocked cells? Select your range (ctrl-A for all the cells). Format|Conditional formatting formula is: =CELL("protect",A1) (Use the activecell's address instead of A1.) Boots wrote: Is there any simple way of identifying all locked cells on a sheet? -- Boots -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
locked cells | Excel Discussion (Misc queries) | |||
locked cells | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions |