Hidden Columns won't Unhide

[Guest]

I hid columns A-G, and now I want them back. Nothing I can do seems to return
them. I followed the instructions in the Help File, but they didn't work:

GoTo A1
Format/Column/Unhide

Next instruction is to go to the top and look for the column separator to
change from arrow to -||-. It doesn't, so if the width was zero I can't make
it wider.

Any Ideas?

 

[Dave Peterson]

Try:

Edit|Goto
type:
A:G
then Format|Column|Unhide
and scroll to the left.

If you still can't see those columns, make sure you're not freezing panes:
Window|Unfreeze Panes
(and scroll left)

 

[Guest]

Select the whole worksheet by clicking the box above the row numbers and to
the left of the column letters. From the menu bar, select Format >> Column >>
Unhide

Hope this helps,

Hutch

 

[Paul B]

Dave, try selecting column H and drag your mouse over to the left, or click
on the square above row 1 to unhide all columns and then format columns
unhide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Carl Hartness]

In the Immediate Window of VB editor,
Range("A1:G1").EntireColumn.Hidden=false

Carl.

 

[Guest]

«If you still can't see those columns, make sure you're not freezing panes:
Window|Unfreeze Panes»

Oh, organic fertilizer -- thereby hung the tale! However all the responses
are helpful -- all contributing to the learning curve <g>!

 

[Guest]

Gotta learn to use that Immediate box more. Actually the problem turned out
to be frozen panes (which I, being extremely old, forgot <g>!)
--
Dave
Temping with Staffmark
in Rock Hill, SC

In the Immediate Window of VB editor,
Range("A1:G1").EntireColumn.Hidden=false

Carl.