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?
Thanks.
Nell
28 Replies
I had same proble but none of the solutions above (or under) helped.
So I selected all cells with Ctrl+A, then right click over the selection, then on the pop up menu click on "See changes", then I serch for the missing cells on the changes list that appeared, and then press show change.
That was it :). hope this helps to someone else in the future! Cheers!
- I also have same problem
Try to unhide or select all set column width but not work.
At the end i select all copy and paste at the new sheet or new excel file it work. Hope this can help. I had a similar issue where I could not see columns A & B. The unhide, ungroup, column formatting and width adjustments did not appear to work for me.
I fixed the error by unfreezing columns and rows in the view tab. This brought the columns back to view and I could access all data and expected functionality. When freezing columns and rows again, the error did not continue.
Good luck! 🙂
amymac90 I have the same issue right now, that's how I found this page. I was missing E and F. so after a while of trying to hide/unhide and other things, I used the drag bar at the bottom to go to the end of the chart at the right to see if the columns were somehow moved to the end (after column AD). They were not there, but when it dragged it all the way back to column A, E&F were there. It just so happens that someone FROZE columns A,B,C, and D, so when you drag the table those stay on the left side. And whoever used the document last left E & F hidden behind A,B,C,D.
i have experienced this issue before .
unhidden Columns but still disappeared !
This is due to Freeze option :
in order to solve the issue : first unfreeze the sheet.
waiting for your reply.
- Thank you so much!!! You have solved the 'disappearing column for no good reason mystery' once and for all!!! You rock!
That's works perfectly right Emad_Abdelmonem
this worked like magic. 🙂
- if the column is not Hidden then maybe column width is a very small number giving the appearance of being 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.
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,
