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 ... ETC.
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.
8 Replies
- Sorry, unhide of rows doesn't work for me. I click on "unhide" of the selected rows and it doesn't expand the hide rows!
I assume it is because of the table (Ctrl + T). I don't know. And I can't follow when it accidently works... (and the help doesn't explain it correctly!!)
Thank for updating the response/the behave of "unhide" and inform user(me) that the "unhide" of rows works according your help.. - I meant unhide "Rows"
hullm1 Select row 1 and 32. Right-click, Unhide.
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
