Forum Discussion
hullm1
Aug 08, 2021Copper Contributor
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 ... ...
- Aug 08, 2021
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.
hullm1
Aug 08, 2021Copper Contributor
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
Riny_van_Eekelen
Aug 08, 2021Platinum Contributor
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.
- hullm1Aug 08, 2021Copper ContributorThanks Riny ..... yep it is protected ... and no don't have the password ...
- Riny_van_EekelenAug 08, 2021Platinum Contributor
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.
- hullm1Aug 08, 2021Copper ContributorOk thanks for the information!