CAN'T UNHIDE COLUMNS

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
 
J

Jacob Skaria

Check whether the sheet is protected..Tools>Protection

If this post helps click Yes
 
M

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
 
J

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
 
W

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top