Turning off auto unhide when calculating formulas

[Guest]

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.

 

[Frank Kabel]

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

 

[Guest]

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.

 

[JulieD]

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

 

[Frank Kabel]

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

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

Hi JB.

Is there a way of turning this off?


Thanks.

 

[JulieD]

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 then in F1 typed
=Sum(and used arrow keys to select A1:E1 ... everything stayed hidden

Cheers
JulieD

 

[Guest]

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?

 

[Gord Dibben]

You can turn it off by de-selecting "Transition Navigation Keys" on the
Tools>Options>Transition tab.

Gord Dibben Excel MVP

 

[JulieD]

Hi Gord

always wondered what that check box did

Cheers
JulieD