Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Cell Formulas
I would like to be able to view a column of data alongside the formulas used
to calculate the data. I'm aware that all of the formulas can be displayed via Tools/Options/Formulas and that Ctrl~ will toggle between the formulas and values. The best I've come up with so far is to copy the formulas and convert them to text cell by cell. At worst, is there a function to convert the formulas to text as a group? -- Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying Cell Formulas | Excel Discussion (Misc queries) | |||
Excel sees cell formulas as constants, will not solve | Excel Worksheet Functions | |||
Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
Cell references in formulas become text | Excel Discussion (Misc queries) | |||
Displaying in a cell the formula from another cell | Excel Discussion (Misc queries) |