Hidden columns - get them back

[Guest]

In a worksheet I "Hid" several columns so that I could view the information in column A and Column R on the same page. How do I bring back the columns that are hidden?

 

[Ken Wright]

Drag the cursor across the surrounding columns and do Format / Columns / Unhide,
or hit CTRL+A and then do it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

In a worksheet I "Hid" several columns so that I could view the information in

column A and Column R on the same page. How do I bring back the columns that are
hidden?

 

[Frank Kabel]

Hi
select the columns right and left to your hidden columns and goto
'Format - columns - Unhide'

 

[Dave Peterson]

I like to hit F5 (edit|goto or ctrl-G) and then type in the address of a cell
that's hidden, say R1.

Then hit enter.

Then Format|Column|Unhide

I don't have to worry about disturbing the other columnwidths.

(I could also type in A1,R1 in that address box and get both columns at one
time. And watch out for Window|freeze Panes. sometimes you have to remove that
to see the unhidden columns.)