View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Missing Column "A" in an Excel Spreadsheet - another case

Hi

Click on column B (the Column label) and drag left with the mouse while you
hold down left mouse button. You have now selected 2 columns (A:B) and
column A can be unhidden.

Hopes this helps.
....
Per

"David Crothers" skrev i meddelelsen
...
I've tried:
1. Using - Go To:A1, then using Format/Column/Unhide.

2. Highlighting the hidden column "A" by moving black down-arrow cursor
from column B to include column A, right'click "Unhide". Note that is is
clear that "A" is included from two indicators - the column count that
appears above the cursor - roughly where the Named Range box sits - and by
the change in thickness of the vertical line between the Excel's row
numbers column and column "B".

3. As in 2. above, highlighting the hidden column by moving black
down-arrow cursor from column B to include column A, then using
Format/Column/Unhide.

4. Customising the View through the View menu, ticking the box "Include
Hidden Columns".

I've also proven the on-going existence of column A by merging a cell in
column "A" with one in column "B" and typing in text that goes across both
columns.



Jes wrote:

Missing Column "A" in an Excel Spreadsheet
24-Aug-08

I've tried the "GoTo" function and the "change column width" to unhide
Column A, but that's not working. Any other suggestions?

EggHeadCafe - Software Developer Portal of Choice
Windows Forms ListBox - 101
http://www.eggheadcafe.com/tutorials...istbox--1.aspx