how do i unhide column after saving file

[Guest]

I was using excell 2000
Saved worksheet with 3 colums hidden.
opened worksheet
Highlighted column before and after columns i hid.
clicked unhide.
Hidden Columns did not display.
How can I recover these columns?thank you sharon m brown

 

[CLR]

That should have done it..........
Two things come to mind.........is the sheet "Protected"
Maybe the columns are showing but very narrow...........try highlighting the
columns on either side and setting the colunn width to something like 8 ro
10........

Vaya con Dios,
Chuck, CABGx3

 

[Max]

Some quick diagnostics ..

Press CTRL+A (selects the entire sheet)
Click Format > Column > Unhide
Click Format > Column > Width > 8.5 (say)
(Some column widths may have been inadvertently set to zero)

Clear any frozen pane (another possible culprit ..)
Click Window > Unfreeze Panes

 

[Guest]

Hi Sharon
Chuck has just about got it covered, but if you want to do a global unhide,
select the button where the row headers and column headers intersect, ( up in
the top left hand corner).....and then click Unhide.

HTH
Michael Mitchelson

 

[Guest]

Thanks for your help,
how do i find out if the worksheet is protected?
assigning a column width of 8 didn't solve the problem..
sharon

 

[Max]

......... is the sheet "Protected"

But wouldn't the options to unhide be grayed out if so ?

Vaya con Dios,
... CABGx3

What does the above mean, Chuck ?
(.. always wondered about this <g> )

 

[Max]

Clear any frozen pane (another possible culprit ..)
"culprit" as in: why you may not be able to see the columns, that is

 

[CLR]

Tools > Protection > UnProtectSheet......if it don't say "UnProtect" then it
wasn't protected

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Indeed it would Max, indeed it would...........

CABGx3 = Coronary Artery Bypass Graft, times 3 ............I'm a "Zipper
Club" member.......

Vaya con Dios,
Chuck=SUM(091938,USMCe4,CABGx3,MMOUS2k)

 

[Max]

Thanks, Chuck !

 

[Guest]

Thanks Everyone.... The global unhide solved my problem.
Sharon