Show Formula For a Single Cell

September 24th, 2004 | Categories: Formatting | Tags:
-->

You can display the formulas in all cells on a worksheet instead of displaying the actual result. For an example you can read the post Print the formulas in a worksheet.

But what if you want to display the formula instead of the result for just one cell? Excel does not have the built in ability to do this, however placing an apostrophe before your formula will get the job done.

Placing the following formula in a cell with a leading apostrophe:

‘=G8/F8

Will result in the formula to be displayed instead of the result.

FormulaInCell

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
No comments yet.