Excel - Columns Missing but Don't Appear to be Hidden.

%3CLINGO-SUB%20id%3D%22lingo-sub-529851%22%20slang%3D%22en-US%22%3EExcel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-529851%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20not%20able%20to%20see%20columns%20F%20and%20G.%20There%20is%20no%20double%20line%20showing%20as%20it%20would%20if%20the%20columns%20were%20hidden%20but%20I%20did%20try%20to%20unhide%20them%20with%20no%20success.%3C%2FP%3E%3CP%3ECan%20anyone%20suggest%20how%20to%20resolve%20this%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3ENell%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-529851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-530461%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-530461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F333325%22%20target%3D%22_blank%22%3E%40Neilphi%3C%2FA%3E%26nbsp%3Bupload%20the%20file%20so%20that%20people%20can%20help.%20J%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-530842%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-530842%22%20slang%3D%22en-US%22%3Eif%20the%20column%20is%20not%20Hidden%20then%20maybe%20column%20width%20is%20a%20very%20small%20number%20giving%20the%20appearance%20of%20being%20hidden.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-530859%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-530859%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259521%22%20target%3D%22_blank%22%3E%40Rich99%3C%2FA%3E%26nbsp%3B%2C%20it's%20the%20same.%20When%20you%20hide%20the%20column%20the%20only%20what%20Excel%20does%20is%20set%20the%20width%20of%20such%20column%20to%20zero.%20Two%20vertical%20lines%20shall%20indicate%20such%20column%2C%20was%20it%20hide%20or%20manually%20set%20to%20zero%20width.%20Unhide%20shall%20work%20in%20both%20cases.%20However%2C%20sometimes%20doesn't.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20try%20to%20select%20columns%20from%20E%20to%20H%20and%20set%20column%20width%20to%20any%20reasonable%20one%2C%20e.g.%208%20(Home-%26gt%3BFormat-%26gt%3BColumn%20Width)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-530867%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-530867%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259521%22%20target%3D%22_blank%22%3E%40Rich99%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20right%2C%20I%20didn't%20catch%20your%20idea.%20If%20column%20width%20is%200.1%20it's%20practically%20invisible%20and%20at%20the%20same%20time%20not%20hidden.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-530919%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-530919%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EI%20tried%20selecting%20the%20columns%20around%20the%20missing%20ones%20and%20setting%20the%20column%20width%20to%2015%20and%20it%20didn't%20work.%3C%2FP%3E%3CP%3EThis%20is%20a%20banking%20file%20and%20I%20was%20reluctant%20to%20go%20the%20%22undo%22%20route%20because%20I%20was%20afraid%20of%20losing%20data%20but%20I%20finally%20did%20try%20it%20and%20after%20several%20udos%20the%20columns%20reappeared.%3C%2FP%3E%3CP%3EI'd%20still%20like%20to%20know%20what%20happened%20in%20case%20it%20happens%20again.%3C%2FP%3E%3CP%3EThanks%20for%20everyone's%20input.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-530922%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-530922%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F333325%22%20target%3D%22_blank%22%3E%40Neilphi%3C%2FA%3E%26nbsp%3B%2C%20it's%20hard%20to%20say%20what%20it%20was%20exactly%20without%20sample%20file.%20As%20a%20comment%2C%20if%20you%20are%20not%20sure%20in%20operations%20better%20to%20do%20the%20copy%20of%20your%20file%20and%20test%20on%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnyway%2C%20glad%20to%20know%20you%20resolved%20the%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848488%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848488%22%20slang%3D%22en-US%22%3Ehi%20Neilphi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20same%20happened%20to%20me%20just%20now.%20I%20resolved%20the%20issue%20however%20by%20unfreezing%20panes%20(that%20is%20if%20you%20have%20freezed%20your%20panes)%20Freezed%20panes%20shows%202-3%20columns%20before%20the%20freeze%20so%20it%20automatically%20hides%20the%20columns%20before%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445610%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445610%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20experienced%20this%20issue%20before%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eunhidden%20Columns%20but%20still%20disappeared%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20due%20to%20%3CU%3E%3CSTRONG%3EFreeze%20option%3C%2FSTRONG%3E%3C%2FU%3E%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20order%20to%20solve%20the%20issue%20%3A%20first%20%3CSTRONG%3E%3CU%3Eunfreeze%3C%2FU%3E%3C%2FSTRONG%3E%20the%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewaiting%20for%20your%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1450206%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1450206%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%20very%20much%20..%20worked%20with%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1855772%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1855772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EThis%20worked%20for%20me.%3CBR%20%2F%3EI%20needed%20to%20select%20the%20column%20using%20arrow%20keys%20or%20name%20field.%3CBR%20%2F%3EThe%20columns%20width%20was%20set%20to%20(%22%22)%20which%20gave%20it%20no%20size%20even%20after%20hiding%2Funhiding.%3CBR%20%2F%3EChanging%20the%20size%20to%2030%20units%20after%20following%20your%20instruction%20resolved%20the%20issue%20for%20me.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1856113%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20-%20Columns%20Missing%20but%20Don't%20Appear%20to%20be%20Hidden.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F638367%22%20target%3D%22_blank%22%3E%40Jacob_Porter%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGreat%20to%20know%20that%20helped%20you%2C%20thanks%20for%20sharing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

15 Replies

@Neilphi upload the file so that people can help. J

if the column is not Hidden then maybe column width is a very small number giving the appearance of being hidden.

@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)

@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.

@Sergei BaklanI 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.

 

@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.

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.

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 very much .. worked with me

@Sergei Baklan 
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,

@Jacob_Porter 

Great to know that helped you, thanks for sharing.

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. 

@Lizzie259 

Thanks for the info. I resolved  my problem some time ago but I don't remember how so I will keep this information for the next time.

Thanks again.