Printing formulas entered in cells

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

How do you, or, is it possible to print not the value of a
calculated cell, but the formula enterd in a cell?
 
Dave

Try Ctrl and ` which is the key to the left of number 1 on your keyboard.
Alternatively, try Tools / Options / View / Formulas.

Andy.
 
Hi Dave!

In addition to Frank and Andy's suggestions, you might like to try a
user defined function:

Function GETFORMULA(cell As Range) As String
GETFORMULA = cell.Formula
End Function

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
-----Original Message-----
How do you, or, is it possible to print not the value of a
calculated cell, but the formula enterd in a cell?
.
Dave:
Click to expand...
I have Office 97 Excel. Tools, Options, View--
under "Window Options" check "formula" box, and OK. You
might need to use landscape to print the page tho, due to
length of formulae in the cells.
 
Can't get the thing either to textwrap or automatically expand column so the
formulae fit.

Unless you fiddle around, the formulae get truncated.

Regards
 
Back
Top