View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default 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