Excel - Display Formula in Cell

Latest update on April 16, 2012 at 12:55 PM by aakai1056 .

Issue
Solution
Note

Issue

Cell A4, contains a formula
```
=Sum(A1:B3)+A3/B2
```
.
How to display the formula in cell A6 for this formula please ?
That is =Sum(A1:B3)+A3/B2
I know Control + ~ can view the formula in a spreadsheet.
But that is view only. Another control + ~ will turn back to normal.
I want to display the formula in cell.

Solution

Create a personalized macro function in a new module :

Function DisplayFormula(cel As Range) 
        DisplayFormula = cel.Formula & "" 
End Function

and after use this new function to the column B cells.
For example, if you want to display the A2 formula in B2, you have to write in B2 the following formula :

=DisplayFormula(A2)

Note

Thanks to aquarelle for this tip on the forum.

Excel - Display Formula in Cell
Excel display formula bar - How-To - Excel
Excel display filename in cell - How-To - Excel
How to copy cells from one sheet to another in excel using formula - How-To - Excel
How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel
Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel

This document, titled « Excel - Display Formula in Cell », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

How to Delete Duplicates in Excel

Excel - Copy down formula if cells non-blank

Issue

Solution

Note

Subscribe To Our Newsletter!