ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell protection with hidden columns (https://www.excelbanter.com/excel-discussion-misc-queries/54412-cell-protection-hidden-columns.html)

Anat

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

Thanks,
Anat

Dave Peterson

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