Forum Discussion
Excel - Columns Missing but Don't Appear to be Hidden.
I am not able to see columns F and G. There is no double line showing as it would if the columns were hidden but I did try to unhide them with no success. Can anyone suggest how to resolve this? Th...
if the column is not Hidden then maybe column width is a very small number giving the appearance of being hidden.
Rich99 , you are right, I didn't catch your idea. If column width is 0.1 it's practically invisible and at the same time not hidden.
SergeiBaklanI tried selecting the columns around the missing ones and setting the column width to 15 and it didn't work.
This is a banking file and I was reluctant to go the "undo" route because I was afraid of losing data but I finally did try it and after several udos the columns reappeared.
I'd still like to know what happened in case it happens again.
Thanks for everyone's input.
- hi Neilphi,
The same happened to me just now. I resolved the issue however by unfreezing panes (that is if you have freezed your panes) Freezed panes shows 2-3 columns before the freeze so it automatically hides the columns before it.- This worked in my case.
Neilphi , it's hard to say what it was exactly without sample file. As a comment, if you are not sure in operations better to do the copy of your file and test on it.
Anyway, glad to know you resolved the issue.
