how do I open a hidden column?

J

JP

This is a spreadsheet with hidden columns that I need to see.
Clicking & dragging at the top of the column is not working.
Could this be a protection problem?
 
C

CLR

This macro will toggle Column J to Hide and Unhide........change the "J" to
whatever column(s) you wish........

Sub ToggleHideAndUnhideColumn()
If Range("J:J").EntireColumn.Hidden = True Then
Range("j:j").Select
Selection.EntireColumn.Hidden = False
Else
Range("j:j").Select
Selection.EntireColumn.Hidden = True
End If
Range("k1").Select
End Sub

hth
Vaya con Dios,
Chuck, CABGx3
 
L

lk

Ctrl + ( unhides rows in the selection
Ctrl + ) unhides columns in selection

If you click the box to the left of column A and above row 1, your entire
spreadsheet will be selected, then you can do one (or both) of the above.
 
M

MT Stringer

Maybe the columns aren't "hidden" afterall. If the "unhide" methods don't
work for you, the column width may be set to zero. To test this theory, click
the button at the top left corner of the spreadsheet. It will select the
entire worksheet. Go to Format-columns-width and enter a value such as 21.
That should set all column widths at 21 pixels. You will find out immediately
if the column widths are set to zero. You can always "undo" if that doesn't
work or if it messes up your other column widths.
Good luck.
Mike
 
Top