Julie,

That's fascinating. I use ver 2002, SP3 and the cols do "unhide" while
entering a formula in F1. I've seen this in every version I've ever used. I
wonder if this means there *is* a way to turn it off?

"JulieD" wrote:

Hi

never seen this either - just tried it on ver 2002 & ver 2003 columns don't
unhide for me if i use the arrow keys while entering a formula (entered
numbers in row 1 from column A to E, hid columns B:D then in F1 typed
=Sum(and used arrow keys to select A1:E1 ... everything stayed hidden

Cheers
JulieD

"JBoulton" wrote in message
...
I think OP is describing the temporary "unhiding" of hidden columns while
entering a formula and using the arrow keys. The cols go back to hidden
when
the formula is completed.

"Frank Kabel" wrote:

Hi
really: never encountered that behaviour. Could you email me a sample
sheet

--
Regards
Frank Kabel
Frankfurt, Germany

"Pedro Jimenez" schrieb im
Newsbeitrag ...
Hi Frank.

I work with worksheets with a lot information, so I hide the columns
I don't
want to see at a moment using the FORMAT/COLUMN/HIDE option.

Then, when I try to sum two columns, from the columns I can see, the
worksheet auto unhide all the hiding columns, which make difficult to
make
the sum.

I hope I can get some help here.

Thank you!

Pedro.

"Frank Kabel" wrote:

Hi
I've never encountered this. what formulas are you entering and how
did
you hide the rows/columns

--
Regards
Frank Kabel
Frankfurt, Germany

"Pedro Jimenez" <Pedro schrieb
im
Newsbeitrag
...
When creating formulas, the worksheet auto unhide hiden rows and
columns that
I have.

How do I turn this off? It really complicates working with the
columns and
rows.

I use Office 2003.

Thanks,

Pedro.