- In the Name box, enter A1
- Click Format > Columns > Width and enter a value, e.g. 1 cm or tick the box Default Value
1 Like
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.
In using Libre Calc spreadsheets, some sheets suddenly would not display Column A or column B (they DID display earlier!). Other spreadsheets showed Column A and B just fine. I drove myself nuts trying to get them to display, even looking online for pointers. Then, I finally discovered what it was. I finally noticed the EXTREMELY THIN horizontal slider at the bottom of the Libre Calc spreadsheet. I clicked and dragged the slider to the left, the spreadsheet moved to the right, and VoilĂ ! (thatâs French), Column A and B were back! I immediately palm-smacked my forehead and cried out, âDUH!â I guess I was used to Microsoft Excel (can I say that here?) which had a horizontal slider that was tall enough to actually notice.
If you look in this threads pictures you also see bigger sliders. They depend on your OS and desktop (different options on linux) and they are much smaller in Win11 than on earlier versions. (You have not mentioned your OS, so Iâm guessing.)
1 Like