Disappearing Columns in Excel that aren't "hidden"

[Guest]

I have quite a large workbook in Excel. Columns A, B, and C each have data in them, but for some reason A and/or B has disappeared. I try to resize those columns because maybe they went to 0 but it will never give the resize cursor. I know these cells aren't "hidden" because if I'm in a cell in column C and hit the left arrow, it puts me into the B cell and displays it's contents on the input line up top. Then I can hit left again and get into the A cells.

 

[jeff]

HI,

this should get them back if all else is OK.

Sub SetWidth()
ActiveSheet.Range("$A:$B").ColumnWidth = 20
End Sub

jeff

-----Original Message-----
I have quite a large workbook in Excel. Columns A, B,

and C each have data in them, but for some reason A
and/or B has disappeared. I try to resize those columns
because maybe they went to 0 but it will never give the
resize cursor. I know these cells aren't "hidden"
because if I'm in a cell in column C and hit the left
arrow, it puts me into the B cell and displays it's
contents on the input line up top. Then I can hit left
again and get into the A cells.

 

[Dave Peterson]

Maybe unfreezing panes would help:

Windows|unfreeze panes