Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell protection with hidden columns
Is there a way to view hidden columns when the cells in those columns are
protected? Thanks, Anat |
#2
|
|||
|
|||
Cell protection with hidden columns
You could unprotect the worksheet.
Visit JE McGimpsey's site: http://mcgimpsey.com/excel/removepwords.html Or you could toggle a setting. Tools|Options|transition tab|check transition navigation keys. Then find an unlocked cell and type = (just an equal sign) Then use the mouse (or arrow keys) to drag through the hidden column range. That unlocked cell could be on any worksheet if you don't have unlocked cells available. Anat wrote: Is there a way to view hidden columns when the cells in those columns are protected? Thanks, Anat -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Cell protection | Excel Discussion (Misc queries) | |||
Determine if another cell is hidden in a Formula | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Hidden Columns are unhidden when inserting a Formula | Excel Discussion (Misc queries) | |||
Cell Colors and Sheet Protection | Excel Discussion (Misc queries) |