Hi Gord

always wondered what that check box did :)

Cheers
JulieD

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You can turn it off by de-selecting "Transition Navigation Keys" on the
ToolsOptionsTransition tab.

Gord Dibben Excel MVP



On Thu, 9 Dec 2004 15:25:34 -0800, "JBoulton"
wrote:

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.