Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column A is Off-screen (no, it's not hidden)
I was working away on a spreadsheet when I noticed that Column A had
disappeared. I first thought that I had somehow "hidden" it, so I ran the command to unhide column A. Column A did not reappear. I have discovered that if I <Alt<Tab from column B, the cursor moves off the left side of the window, effectively disappearing, and the A1 cell ID appears in the "Name Box" pane, and the contents of A1 appears in the "fx" pane. So column A isn't hidden, it's just somewhere off the left side of the Excel window. Can someone tell me how I can get column A to actually be displayed? Office Excel 2003, sp3. Thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column A is Off-screen (no, it's not hidden)
Maybe it's the column Width. Select a cell in Column A like you say you
can, then do Format - Column - Width and increase the width. HTH Otto "Mike Hartsough" wrote in message ... I was working away on a spreadsheet when I noticed that Column A had disappeared. I first thought that I had somehow "hidden" it, so I ran the command to unhide column A. Column A did not reappear. I have discovered that if I <Alt<Tab from column B, the cursor moves off the left side of the window, effectively disappearing, and the A1 cell ID appears in the "Name Box" pane, and the contents of A1 appears in the "fx" pane. So column A isn't hidden, it's just somewhere off the left side of the Excel window. Can someone tell me how I can get column A to actually be displayed? Office Excel 2003, sp3. Thanks, Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column A is Off-screen (no, it's not hidden)
When a column is "hidden" XL gives it a width of 0.
As long as the width is *not 0*, it's not considered "hidden", so UNHIDE doesn't work. Just increase the column width! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mike Hartsough" wrote in message ... I was working away on a spreadsheet when I noticed that Column A had disappeared. I first thought that I had somehow "hidden" it, so I ran the command to unhide column A. Column A did not reappear. I have discovered that if I <Alt<Tab from column B, the cursor moves off the left side of the window, effectively disappearing, and the A1 cell ID appears in the "Name Box" pane, and the contents of A1 appears in the "fx" pane. So column A isn't hidden, it's just somewhere off the left side of the Excel window. Can someone tell me how I can get column A to actually be displayed? Office Excel 2003, sp3. Thanks, Mike |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column A is Off-screen (no, it's not hidden)
Another possibility...
You moved Column A off screen. You added a Freeze Pane The window is now frozen with Column A off of the screen. To fix just remove the freeze pane. -- HTH... Jim Thomlinson "Mike Hartsough" wrote: I was working away on a spreadsheet when I noticed that Column A had disappeared. I first thought that I had somehow "hidden" it, so I ran the command to unhide column A. Column A did not reappear. I have discovered that if I <Alt<Tab from column B, the cursor moves off the left side of the window, effectively disappearing, and the A1 cell ID appears in the "Name Box" pane, and the contents of A1 appears in the "fx" pane. So column A isn't hidden, it's just somewhere off the left side of the Excel window. Can someone tell me how I can get column A to actually be displayed? Office Excel 2003, sp3. Thanks, Mike |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column A is Off-screen (no, it's not hidden)
And to add to Jim's response...
In xl2003 menus, you can find that setting under Window (on the worksheet menu bar) Jim Thomlinson wrote: Another possibility... You moved Column A off screen. You added a Freeze Pane The window is now frozen with Column A off of the screen. To fix just remove the freeze pane. -- HTH... Jim Thomlinson "Mike Hartsough" wrote: I was working away on a spreadsheet when I noticed that Column A had disappeared. I first thought that I had somehow "hidden" it, so I ran the command to unhide column A. Column A did not reappear. I have discovered that if I <Alt<Tab from column B, the cursor moves off the left side of the window, effectively disappearing, and the A1 cell ID appears in the "Name Box" pane, and the contents of A1 appears in the "fx" pane. So column A isn't hidden, it's just somewhere off the left side of the Excel window. Can someone tell me how I can get column A to actually be displayed? Office Excel 2003, sp3. Thanks, Mike -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column A is Off-screen (no, it's not hidden)
Doh!
It was the Freeze pane that did it. I got my column A back. Thanks for the help! Mike "Dave Peterson" wrote: And to add to Jim's response... In xl2003 menus, you can find that setting under Window (on the worksheet menu bar) Jim Thomlinson wrote: Another possibility... You moved Column A off screen. You added a Freeze Pane The window is now frozen with Column A off of the screen. To fix just remove the freeze pane. -- HTH... Jim Thomlinson "Mike Hartsough" wrote: I was working away on a spreadsheet when I noticed that Column A had disappeared. I first thought that I had somehow "hidden" it, so I ran the command to unhide column A. Column A did not reappear. I have discovered that if I <Alt<Tab from column B, the cursor moves off the left side of the window, effectively disappearing, and the A1 cell ID appears in the "Name Box" pane, and the contents of A1 appears in the "fx" pane. So column A isn't hidden, it's just somewhere off the left side of the Excel window. Can someone tell me how I can get column A to actually be displayed? Office Excel 2003, sp3. Thanks, Mike -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column A is Off-screen (no, it's not hidden)
Sorry, I had forgotten to mention that I had already tried increasing the
column width. It was already set to 14, but I increased it to 30 just in case, but that didn't "reveal" the column. Thanks for the suggestion! Mike "Otto Moehrbach" wrote: Maybe it's the column Width. Select a cell in Column A like you say you can, then do Format - Column - Width and increase the width. HTH Otto "Mike Hartsough" wrote in message ... I was working away on a spreadsheet when I noticed that Column A had disappeared. I first thought that I had somehow "hidden" it, so I ran the command to unhide column A. Column A did not reappear. I have discovered that if I <Alt<Tab from column B, the cursor moves off the left side of the window, effectively disappearing, and the A1 cell ID appears in the "Name Box" pane, and the contents of A1 appears in the "fx" pane. So column A isn't hidden, it's just somewhere off the left side of the Excel window. Can someone tell me how I can get column A to actually be displayed? Office Excel 2003, sp3. Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
How do a make a column wider than the screen? | Excel Discussion (Misc queries) | |||
How can I reveal hidden column and row headings on screen? | Excel Discussion (Misc queries) | |||
Bottom of spreadsheet hidden in full screen view | Excel Discussion (Misc queries) | |||
How do i keep the first column of info on my screen? | Excel Discussion (Misc queries) |