EXCEL: I can't unhide columns A & B in .XLS sprdsht sent by cowor

M

martha_waters

This has happened several times. A coworker sends me a spreadsheet. I open
it and can see all columns except A and B. I cannot use the usual procedure
and unhide Columns A and B (select all columns by clicking on upper left
cell; Window; Unhide). We both use EXCEL 2002 SP-2.
 
J

Jason Morin

Unhiding windows has nothing to do with unhiding columns.
Press Ctrl+A, Format > Column > Unhide.

HTH
Jason
Atlanta, GA
 
D

Dave Peterson

And check to see if you have Frozen panes.

(Window|UnFreeze Panes would remove it)
 
G

goose

-----Original Message-----
And check to see if you have Frozen panes.

(Window|UnFreeze Panes would remove it)



--

Dave Peterson
[email protected]
.
Sorta tricky but if you go to the column "C" place your
Click to expand...
mouse just on the line to the left of "C" and the blank
box it will turn into the TWO Arrows Slid this to the
right Column "B" will appear do the same thing with
Column "A". Had this happen to me and that was the only
way around it after several moments of frustration. Hope
it works for you.

Goose
 
D

Dave Peterson

Or

F5
a1:b1
format|column|unhide

(some people may not have the / set up for Menus.)
 
Top