how do i unhide column after saving file
 

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

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


"moodysmb" wrote in message
...
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

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"moodysmb" wrote in message
...
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

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

"CLR" wrote:

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


"moodysmb" wrote in message
...
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

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


"CLR" wrote:

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


"moodysmb" wrote in message
...
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" wrote:
......... 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 )
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Clear any frozen pane (another possible culprit ..)
"culprit" as in: why you may not be able to see the columns, that is
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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

Vaya con Dios,
Chuck, CABGx3


"moodysmb" wrote in message
...
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

"CLR" wrote:

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


"moodysmb" wrote in message
...
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

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" wrote in message
...
"CLR" wrote:
......... 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 )
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thanks, Chuck !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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

"Michael" wrote:

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


"CLR" wrote:

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


"moodysmb" wrote in message
...
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