Hi,

Maybe the column isn't hidden at all, perhaps it is just set very narrow, in
which case unhide doesn't work

F5 goto A1. Format column width and set to (say) 8

Mike

"David Crothers" wrote:

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