How do I display a formula on the worksheet
 

Is there a way to display the formula on the worksheet insead of its value?

Deb: Put a ' in front of the formula.
************
Anne Troy
www.OfficeArticles.com

"Debi" wrote in message
...
Is there a way to display the formula on the worksheet insead of its
value?

You could use the toggle CTRL+` (hold the control button down, whilst
pressing the key immediately below Esc)

Repeating the process toggles the display of formulas back off again.

Regards

Roger Govier


Debi wrote:
Is there a way to display the formula on the worksheet insead of its value?

Another option... If you already have all of your formula's entered in the
spreadsheet, you can hit Ctrl+`, instead of going into each one and
preceeding it with a '

--
Regards,
Dave


"Debi" wrote:

Is there a way to display the formula on the worksheet insead of its value?

Debi

Show all formulas by hitting CTRL + `(backquote above Tab key)

OR to show just one or some use David McRitchie's GETFORMULA UDF

Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function

Copy/paste the UDF to a general module in your workbook.

In a cell enter =GETFORMULA(cell) where cell is the cell with the formula.

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the above code in there. Save the
workbook and hit ALT + Q to return to your workbook.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 12:35:06 -0700, "Debi"
wrote:

Is there a way to display the formula on the worksheet insead of its value?