Excel Formulas

[Pam]

There is a way to view all formulas on a spreadsheet at once and I can't remember how.

Please help!

Pam

 

[JugglerJAF]

Tools - Options
Tick the "Formulas" box on the View tab.

I think there is a shortcut key bit I can never remember what it is and I don't use it often enough to bother remembering!

 

[Mark W.]

Control+` (on the tilde key)

 

[shades]

Ctrl + `

_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-11-04 11:46

 

[Pam]

I think worded my request wrong. I'd like to see each set of cells that each formula is pulling from.

Thanks

Pam

 

[Mark W.]

Use the Tools | Auditing | Trace Precedents menu command.