CAN'T UNHIDE COLUMNS

[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

 

[Jacob Skaria]

Check whether the sheet is protected..Tools>Protection

If this post helps click Yes

 

[William]

It is not protected.

Check whether the sheet is protected..Tools>Protection

If this post helps click Yes

 

[Mike H]

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

 

[Jacob Skaria]

--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

 

[Jim Thomlinson]

Shared? Sharing is essentailly a type of protection...

 

[William]

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.

 

[Gord Dibben]

Why do you think Window>Unhide will unhide columns?

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


Gord Dibben MS Excel MVP