Show a hidden column Solved

Question

Hello,

I'd like to know how to display the columns that are hidden in Excel?
Since they're no longer there, I can't select them anymore.. so it's hard to click "unhide" lol.
Thanks in advance.
Have a nice day

Configuration: Windows 98 Internet Explorer 6.0

Raymond PENTIER · Accepted Answer

eriiic provided you with the solution (hello, Eric!).  You can also, to only re-display the hidden column E and leave the others hidden:  * either go to Edit/Go To/Reference/E1 * or press Ctrl+T/Reference/E1 ------ then go to Format/Column/Show.  To re-display all the hidden columns of the sheet: * either press Ctrl+A * or select the entire sheet by clicking in the empty box to the left of A and above 1 ------ then go to Format/Column/Show.  And there are other ways to do it, particularly by bringing the cursor just to the right of the cell containing the letter D and dragging to the right. --  A retiree in the sun of the Antilles :-)Raymond

eriiic · Answer

Hello,  If E is hidden you select D:F and there you can do 'format / column / unhide' eric

eriiic · Answer

Hello Raymond,Have a good day :-)

mumu · Answer

Hello, you highlight the columns before and after, for example, the column that does not appear is located between COLUMN F and H.
At the top of the column, you only highlight the first cell at the top of F and H and right-click to display.

hukaro44@hotmail.com · Answer

You need to select the cells that are before and/or after, right-click, and select "show."

Raymond PENTIER · Answer

Thank you, guys: It was about time (2 years of reflection)!
Did you not notice that the status of this old discussion has changed to "Resolved"?
hukaro, why repeat what mumu already explained 1 month ago? And did you notice that you are the only CCM participant revealing your email address to the entire population?
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂

Emyyyyy · Answer

Hello,
Thank you all for your explanations, I am also experiencing this problem but not in a column. I have a document where the first 50 lines have been hidden and this method (format/row/show) has no effect. I tried testing by hiding and then showing but only hiding works....

Does anyone have the solution??

Thanks in advance.

Sopeople · Answer

Hello, after trying all the techniques above, I finally double-clicked between the 2 columns where the hidden columns are, and it worked...

Show a hidden column

8 answers

How to contact to have someone online

Get office for free

Arabic qwerty keyboard

Keyboard keys misalignment issue

Iphone apple 6s creating an apple id problem

Hacked facebook contact

Vpn port udp tcp

Toshiba tv menu unavailable

My samsung a32 keyboard no longer appears

Cannot connect to wi-fi