I used Column D to store our cost of materials then I referenced it in some
formula's in Columns G & H but I screwed up.

I hid Column D before generating a hardcopy and then I quit Excel with
Column D hidden!

Though Columns G & H still hold the correct values and still refer to Col D,
I am not able to restore it to make additional changes and I don't necessary
want to reinput all the data. UNDO does not work and Tools-Options-View
doesn't either.

Can anyone tell me how to restore Col D?

Thanks a lot,

Carlos

Select both columns C and E
Goto the menu FormatColumnUnhide

--
Biff
Microsoft Excel MVP


"CarlosJumenez" wrote in message
...
I used Column D to store our cost of materials then I referenced it in some
formula's in Columns G & H but I screwed up.

I hid Column D before generating a hardcopy and then I quit Excel with
Column D hidden!

Though Columns G & H still hold the correct values and still refer to Col
D,
I am not able to restore it to make additional changes and I don't
necessary
want to reinput all the data. UNDO does not work and Tools-Options-View
doesn't either.

Can anyone tell me how to restore Col D?

Thanks a lot,

Carlos

Another way.
Edit|goto (or hit F5 or ctrl-g)
type: D1
Format|column|Unhide
(xl2003 menu system)

CarlosJumenez wrote:

I used Column D to store our cost of materials then I referenced it in some
formula's in Columns G & H but I screwed up.

I hid Column D before generating a hardcopy and then I quit Excel with
Column D hidden!

Though Columns G & H still hold the correct values and still refer to Col D,
I am not able to restore it to make additional changes and I don't necessary
want to reinput all the data. UNDO does not work and Tools-Options-View
doesn't either.

Can anyone tell me how to restore Col D?

Thanks a lot,

Carlos

--

Dave Peterson

Select columns C and E, then Format/ Columns/ Unhide
Or if you right-click columns C and E, you'll get the Unhide option
directly.
--
David Biddulph

"CarlosJumenez" wrote in message
...
I used Column D to store our cost of materials then I referenced it in some
formula's in Columns G & H but I screwed up.

I hid Column D before generating a hardcopy and then I quit Excel with
Column D hidden!

Though Columns G & H still hold the correct values and still refer to Col
D,
I am not able to restore it to make additional changes and I don't
necessary
want to reinput all the data. UNDO does not work and Tools-Options-View
doesn't either.

Can anyone tell me how to restore Col D?

Thanks a lot,

Carlos