I open your document which has column A hidden.
Click the grey box above the row headers which selects the entire sheet. Alternatively you may enter the cell address A1 into the name box above, left of the formula bar.
menu:Format>Columns>Show unhides column A.
1 Like
Thanks, yes, after closing and re-opening, both works with my newly created test, unfortunately it does not work with my old spreadsheet, maybe because it was created with an older version.
As a circumvention I create a new spreadsheet document, copy all the sheets of my old document, and of course then I have to redo all the changes I made, like changing default font, creating and assigning page styles, print ranges and so on.
“Create an empty spreadsheet. Then hide columns A and B. You cannot show them after that. It is a bug that cannot show any hidden front columns. Hide column C also to prove my point. Try to show columns A to C now. No joy. It also cannot be shown again Caution therefore never hide initial columns until this issue has been solved ASAP please…”
@Navrae Thank you! I just tried this, and YES! This seems to be the crux of the bug for me! My column A disappeared too after freezing the C2 cell. I attached my buggy worksheet in a different post. But I just tried unfreezing the cell as instructed here, and now I can scroll back and see column A again!
It is also possible that the above solutions do not work because column A may be hidden in another way.
If you scroll in your worksheet so that column B, C etc. are visible and column A is not visible and you set ‘freeze rows and columns’ (e.g. in cell C2) you will never be able to see Column A until you unfreeze the rows and columns.
3 Likes
Had the same problem, in that column D “disappeared” and could not be recovered.
Solution -
Found that C1 was a merged cell [with C2] - unmerged and a small arrow appeared in C1 - Clicked on small arrow and D re-appeared. Re-merged C1 with C2 and column D stayed in view.
If this does not mirror your problem and does not cure it - apologies.