I have a pretty complex calc file which I use for my budget. In one of the sheets, column A holds item names, and each subsquent pair of columns contains the corresponding cost for a year.
I masked all columns of the past years (i.e., columns B to AM). Now I cannot unhide them.
I found out that if I copy the sheet to another one, all the masked columns reappear. But I cannot replace the broken sheet with this new one, as all references from other sheets to data in the broken one then break down. Pasting the displayed columns from the new sheet into the broken one doesn’t display them.
Any ideas on how to display the hidden data?
Thanks
To unhide all click on the top left corner, then open context menu (right mouse key) and unhide columns.
.
You may also select hidden columns via the address box to unhide, as shown by Mike Kaganski here:
2 Likes
Thank you very much! It worked even better than expected!
Details:
- Using the right context menu to unhide didn’t work (I had tried it before).
- But entering the name of one of the hidden cells in the address box and pressing Enter sufficed to display them all, even without doing the next step (Format → Columns → Show). It solved - in such an easy way I’m ashamed I never thought of trying it - a problem which had been upsetting me for months.
Thanks again!
Michael