Forum Discussion
Neilphi
May 03, 2019Copper Contributor
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...
SergeiBaklan
May 04, 2019Diamond Contributor
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)
Jacob_Porter
Nov 05, 2020Brass Contributor
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,
- SergeiBaklanNov 05, 2020Diamond Contributor
Great to know that helped you, thanks for sharing.