Forum Discussion
Solved
Unhide columns of an excel spreadsheet
so I'm working on a spreadsheet ... I know how to unhide cells .. but these cells I am trying to unhide are somehow locked ... how do I unlock them? it jumps from line 1 to 32 ... then 34 to 78 ... ...
hullm1 Select all cells in the protected sheet, Copy and Paste to an empty sheet. That removes the protection so that you can unhide the rows. But it might mess up the functionality of the workbook.
Thanks Riny ..... yep it is protected ... and no don't have the password ...
hullm1 Select all cells in the protected sheet, Copy and Paste to an empty sheet. That removes the protection so that you can unhide the rows. But it might mess up the functionality of the workbook.
- Ok thanks for the information!