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

G

Guest

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?
 
D

Don Guillett

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

Guest

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
 
G

Gord Dibben

Shortcut key to toggle View Formulas on/off.

CTRL + `(backquote above TAB key)


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is there some way to toggle between outlook views? 3
How do I display empty columns in a Pivot Table? 1
Is there a way to switch data between two cells? 1
#NAME? - is there a way to stop this error message? 3
Linking Groups of cells between workbooks 4
help: paste special with an operation (add, multiply,...) convertseverything to values, pasted formu 1
Excel 2002: Is there a way to default font for pasted data ? 2
Is there a quick way to toggle between two fonts in Word? 2

Top