Permanently Display a formula in Excel

merlin75

New Member
Joined
Nov 4, 2002
Messages
12
I am trying to find a way to get a cell to read another cell's formula and display that formula. I know Ctrl-~ will cause the entire workbook to show formulas, but I only want a single cell to do so. Any ideas?
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Asala42

Well-known Member
Joined
Feb 26, 2002
Messages
2,318
Here's a UDF that may help:

Code:
Function FormulaText(x As Range) As String
     FormulaText = x.Formula
End Function

(hit Alt+F11, Insert/Sub, then paste in the code above)

Say you want to display the formula from A1 in another cell, you can now use the formula above:

=formulatext(A1)

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,122,193
Messages
5,594,774
Members
413,934
Latest member
austinb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top