| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
| Adding columns w/new formulas BUT keeping subtotals | Excel Discussion (Misc queries) | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
