Hidden columns - get them back

M

Marlenek

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?
 
K

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 :)
----------------------------------------------------------------------------



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

Frank Kabel

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

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.)
 
Top