Cell protection with hidden columns

A

Anat

Is there a way to view hidden columns when the cells in those columns are
protected?

Thanks,
Anat
 
D

Dave Peterson

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.
 
Top