Is there a way to toggle cells between display of referenced data.
 

Would like to somehow simply toggle between a sheet of data provided by
various cell references and formulas and the acutal reference addresses and
formula equations, e.g., instead of seeing 12, I want to see the worksheet
cell display =3*4, etc. Is there any way to accomplish this without a mass
copy-paste special command?

Try using control + tilde at the same time
tilde is the key just to the left of the 1

--
Don Guillett
SalesAid Software

"williejoeshaver" wrote in
message ...
Would like to somehow simply toggle between a sheet of data provided by
various cell references and formulas and the acutal reference addresses
and
formula equations, e.g., instead of seeing 12, I want to see the worksheet
cell display =3*4, etc. Is there any way to accomplish this without a
mass
copy-paste special command?

You could record two macros: 1st - tools - macro - record new macro - tools -
options - view and select formulas. 2nd - record new macro - tools - options
- view and uncheck formulas. Customize a tool bar by placing these two
macros on it. Not very elegant, but it works. HTH

"williejoeshaver" wrote:

Would like to somehow simply toggle between a sheet of data provided by
various cell references and formulas and the acutal reference addresses and
formula equations, e.g., instead of seeing 12, I want to see the worksheet
cell display =3*4, etc. Is there any way to accomplish this without a mass
copy-paste special command?

Shortcut key to toggle View Formulas on/off.

CTRL + `(backquote above TAB key)


Gord Dibben Excel MVP

On Fri, 11 Mar 2005 11:07:11 -0800, williejoeshaver
wrote:

Would like to somehow simply toggle between a sheet of data provided by
various cell references and formulas and the acutal reference addresses and
formula equations, e.g., instead of seeing 12, I want to see the worksheet
cell display =3*4, etc. Is there any way to accomplish this without a mass
copy-paste special command?