Hi Susan

if you have hidden columns C & D for example so you see A, B, E, F....
select the column letter B and drag across to E
then right mouse click on B (or E) and choose unhide

alternatively, if you really get stressed about hiding / unhiding columns
you can use grouping instead, say you want to hide column C & D again
select C drag across to the D and choose data / Group & OUtline / Group
you're notice a little - above the letter E, click on it, C&D disappear to
get them back click on the +

i like this second method for where i'm hiding & unhiding the same columns
(or rows) regularly.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Susan" wrote in message
...
It's driving me crazy. I can't get columns to unhide after hiding them.
I have to go to the "select all" and then drag the columns open. It said
something in Help about a column going to zero. How do I stop that so the
UNHIDE will work?
Thanks!