ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Getting Back Hiden Columns (https://www.excelbanter.com/excel-discussion-misc-queries/116664-getting-back-hiden-columns.html)

Marilyn

Getting Back Hiden Columns
 
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,


RichN

Getting Back Hiden Columns
 
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.

"Marilyn" wrote:

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,


Dave Peterson

Getting Back Hiden Columns
 
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.

Marilyn wrote:

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,


--

Dave Peterson

Marilyn

Getting Back Hiden Columns
 
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 dont 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

"Dave Peterson" wrote:

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.

Marilyn wrote:

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,


--

Dave Peterson


Dave Peterson

Getting Back Hiden Columns
 
You didn't write about trying window|unfreeze panes.

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

Marilyn wrote:

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 dont 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

"Dave Peterson" wrote:

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.

Marilyn wrote:

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,


--

Dave Peterson


--

Dave Peterson

Marilyn

Getting Back Hiden Columns
 
I unfreeze all the panes and that did not work.

"Dave Peterson" wrote:

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

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

Marilyn wrote:

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

"Dave Peterson" wrote:

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.

Marilyn wrote:

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,

--

Dave Peterson


--

Dave Peterson


David Biddulph

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

"Marilyn" wrote in message
...
I unfreeze all the panes and that did not work.

"Dave Peterson" wrote:

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

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

Marilyn wrote:

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?Tt 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

"Dave Peterson" wrote:

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.

Marilyn wrote:

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,

--

Dave Peterson


--

Dave Peterson




Dave Peterson

Getting Back Hiden Columns
 
I don't have any more guesses.

Marilyn wrote:

I unfreeze all the panes and that did not work.

"Dave Peterson" wrote:

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

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

Marilyn wrote:

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

"Dave Peterson" wrote:

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.

Marilyn wrote:

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,

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Marilyn

Getting Back Hiden Columns
 
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

"Marilyn" wrote:

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,


David Biddulph

Getting Back Hiden Columns
 
Glad it worked.
--
David Biddulph

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

"Marilyn" wrote:

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,





All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com