Cell protection with hidden columns
Is there a way to view hidden columns when the cells in those columns are
protected? Thanks, Anat |
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 |
All times are GMT +1. The time now is 10:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com