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 ... I know how to do that ... somehow these rows are locked and you can't ... not sure how to unlock them ... Riny_van_Eekelen
hullm1 Perhaps the sheet is protected. Unprotect it first. You'll find an icon on the Review ribbon. You'll need a password if it was entered when it was protected.
- 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!