Turning off auto unhide when calculating formulas
 

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.

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.

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.

Hi Pedro

do you have any worksheet_change code on the worksheet (right mouse click on
the sheet tab, choose view code ... is there any code there?)

by unhide do you mean literally unhide (as in the same as format / column/
unhide) or just included in the sum
e.g. if i hide columns B through D
then i type =SUM(
click on A, drag to F and the formula reads
=SUM(A1:F1)
which includes the hidden columns?

Cheers
JulieD


"Pedro Jimenez" wrote in message
...
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.

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.

Hi JulieD.

There is no code there?

And yes, it literally unhide the columns. That's what I don't understand why
is doing this. Maybe I need to reinstall the Office.

Thanks.

Pedro.

"JulieD" wrote:

Hi Pedro

do you have any worksheet_change code on the worksheet (right mouse click on
the sheet tab, choose view code ... is there any code there?)

by unhide do you mean literally unhide (as in the same as format / column/
unhide) or just included in the sum
e.g. if i hide columns B through D
then i type =SUM(
click on A, drag to F and the formula reads
=SUM(A1:F1)
which includes the hidden columns?

Cheers
JulieD


"Pedro Jimenez" wrote in message
...
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.

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.

Hi JB.

Is there a way of turning this off?


Thanks.

"JBoulton" wrote:

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.

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.

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.

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.

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.