how do I show column a

[AmmaMia]

“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!

[winfrieddonkers]

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.

[dibbyf15]

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.