Printing formulas entered in cells

[Dave]

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

 

[Frank Kabel]

Hi Dave
one way: Format the cell as 'Text' prior to entering the formula

 

[Andy B]

Dave

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

Andy.

 

[Norman Harker]

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.

 

[Tess]

-----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:

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.

 

[Chris R. Lee]

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