Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protect cells
Is there a way that I can see which cells are protected without having to
select them and then go to Format/Cell.../Protection? -- Thanks Dave |
#2
|
|||
|
|||
Do you use Format|Conditional formatting?
If no, then you could do this: Select your range (say A1:X99) Then Format|conditional formatting Formula is: =cell("protect",a1) and give it a nice fill color. You could even use a cell that would allow you to show it or hide that CF formatting. I used $A$1 in this formula: =AND($A$1="show",CELL("protect",A1)) Put Show in A1 and you'll see the locked cells. Change A1 and it's back to normal. ========= An alternative that I like better. Customize a toolbar to include the locked icon. Tools|Customize|Commands Tab|Format Category Scroll down the list of commands and drag the "Lock Cell" icon to your favorite toolbar (a new one just for your stuff????) Then when you select a single cell, look at that icon. If it's depressed, the cell is locked. Dave wrote: Is there a way that I can see which cells are protected without having to select them and then go to Format/Cell.../Protection? -- Thanks Dave -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protect Cells | Excel Discussion (Misc queries) | |||
Protect Cells | New Users to Excel | |||
How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) | |||
about protect just cells | Excel Discussion (Misc queries) | |||
Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions |