Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
display / print 0's in pivot table cells | Excel Discussion (Misc queries) | |||
Excel: To Display Formula in the cells Instead of Value | Excel Discussion (Misc queries) | |||
How do I get merged cells to display all text. | Excel Discussion (Misc queries) | |||
how do i display formulas in only certain cells? | Excel Worksheet Functions |