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
 

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

HIDDEN ROWS 6
Unhide Problem in Vista & Excel 2007 6
Unhide Column 5
Unhide columns 2
Prevent unhiding columns 1
Unhiding Columns 4
Unhiding columns 7
Hide and Unhide Function 4

Back
Top