Column A is Off-screen (no, it's not hidden)

  • Thread starter Thread starter Mike Hartsough
  • Start date Start date
M

Mike Hartsough

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
 
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
 
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!
 
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.
 
And to add to Jim's response...

In xl2003 menus, you can find that setting under Window (on the worksheet menu
bar)
 
Doh!

It was the Freeze pane that did it.

I got my column A back.

Thanks for the help!

Mike
 
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
 
Back
Top