un-hide a single column 1

[mscallisto]

I know how to un-hide all hidden columns but don't know how to un-hide just one column.

 

[SkipVought]

Hi,

    Cells(1, 1).EntireColumn.Hidden = False

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[mscallisto]

Thanks Skip but I need to un-hide a single column outside of vba.


I know I can highlight (select) all columns, Right mouse click the column header and check Un-Hide (all hidden columns).

How can I un-hide just one column?

There is a Format > Column > Un-Hide but when a column is hidden I can't see how to unhide it.

 

[Dreamboat]

Suppose it's column D.

Hit Ctrl+G (Edit-Go to) and type "D1".

That takes you to D whether it's hidden or not.
Then Format-Column, Unhide.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[mscallisto]

Thanks Dreamboat...that's worth a big star!!

You're not by chance Skip's boss are you?

 

[Dreamboat]

I think "colleague" would be more appropriate.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[IFRs]

To unhide a single column, right click on the column head and pick UnHide. Same for rows.

 

[Dreamboat]

IFRs, if a column is hidden, how will you see its column head? You could select the column heads to the left and right of the hidden column and do that, tho.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[IFRs]

Sorry about my stupid post. Duh!!

To unhide column C that is hidden, press and hold Shift while you left click column B head and move the mouse to column D head. It will select columns B through D. Now right-click and select UnHide.