CAN'T UNHIDE COLUMNS

  • Thread starter Thread starter William
  • Start date Start date
W

William

I have several hidden columns (F through K) that I am unable to unhide. I've
tried selecting the entire worksheet, but Window/Unhide is grayed out. I've
tried only selecting columns E through L but Unhide is still grayed out.
Help!

Thanks,

Wm
 
Check whether the sheet is protected..Tools>Protection

If this post helps click Yes
 
Maybe they're not hidden, perhaps they are just very narrow. Select these
columns and a couple of columns either side and reset the column width to 8.43

Mike
 
--Select at least one column to the left and one column to the right of the
column you are trying to unhide and then from menu Format>Column>Unhide

--Check whether it is really hidden or the column width is set to a small
value small.Selecting adjusant columns to left and right and use
Format>Column>Width and set that to 10...and see

--Have you applied Window>Freeze panes. If so just try turning that Off


If this post helps click Yes
 
Resetting the column widths as you suggested did indeed make the columns
visible. However, they originally disappeared from view by selecting the
columns and then Window/Hide, so it would seem that were hidden. Whatever,
though . . . you solved my problem, thanks.
 
Why do you think Window>Unhide will unhide columns?

Perhaps Format>Column>Unhide may be a better choice.


Gord Dibben MS Excel MVP
 
Back
Top