Forum Discussion
Excel - Columns Missing but Don't Appear to be Hidden.
Sometimes the simplest answers are the best - nailed it!
Some loony in my org decided to shrink to nothing rather than hide :) Thank you for saving my sanity :)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.
Rich99 , it's the same. When you hide the column the only what Excel does is set the width of such column to zero. Two vertical lines shall indicate such column, was it hide or manually set to zero width. Unhide shall work in both cases. However, sometimes doesn't.
I'd try to select columns from E to H and set column width to any reasonable one, e.g. 8 (Home->Format->Column Width)
SergeiBaklan
This worked for me.
I needed to select the column using arrow keys or name field.
The columns width was set to ("") which gave it no size even after hiding/unhiding.
Changing the size to 30 units after following your instruction resolved the issue for me.
Thanks,Great to know that helped you, thanks for sharing.
