Getting Back Hiden Columns

G

Guest

Does anyone know how to Unhide Column A once the file has been saved? I'm
working in an Excel 2003 Spreadsheet and is obvious Column A is not there. I
tried to select Column B,C, & D and used the Unhide command but it did not
work.

Any Suggestions?

Thanks,
 
G

Guest

click on the small square above row 1 and to the left of column B. this will
highlight the whole worksheet. then choose format, column, unhide.
 
D

Dave Peterson

I like:

Edit|goto|type: A1
format|column|unhide

And if you try scrolling to the left and still can't see it, try:
Window|Unfreeze panes

Then scroll to the left to test.
 
G

Guest

Thank You ALL for the responses. I tried both methods, I selected everything
in the worksheet and went to Forma, Column, Unhide but nothing happened. I
also did the Edit, Go to, A1 and although I see is going to A1 I cant see the
column. When I go into Print Preview I can see the information in Column A,
but I don’t see when I'm in normal view. I even try viewing the Spreadsheet
in Page Break Preview and I cant see Column A.

Can someone please help me this is driving me crazy
 
D

Dave Peterson

You didn't write about trying window|unfreeze panes.

Did you try that and it didn't help or what?
 
G

Guest

I unfreeze all the panes and that did not work.

Dave Peterson said:
You didn't write about trying window|unfreeze panes.

Did you try that and it didn't help or what?
 
D

David Biddulph

Select the whole sheet & try Format/ Column/ Width ... and choose an
suitable value.
--
David Biddulph

Marilyn said:
I unfreeze all the panes and that did not work.
 
G

Guest

Ok, I had to select everything like David suggested go to Format, Column,
Width I set the width to 25 and it did not bring column A back. I set the
width to 0 which made everything disappear and when I set the width again to
10 column A came back along with everything else.

What a weird things to happen
 
D

David Biddulph

Glad it worked.
--
David Biddulph

Marilyn said:
Ok, I had to select everything like David suggested go to Format, Column,
Width I set the width to 25 and it did not bring column A back. I set the
width to 0 which made everything disappear and when I set the width again
to
10 column A came back along with everything else.

What a weird things to happen
 

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

Top