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 réponses

Texture issues in enshrouded

Driver his

Peritel to hdmi conversion

How to access the bios on a compaq notebook

Dsi won't turn on anymore

Search for a song with the lyrics

Left mouse click, touchpad click inactive

Codes stronghold crusader

Stuck computer system repair

Disable write protection mp3 player