Excel - Display Formula in Cell
April 2018
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.
Related
- Excel - Display Formula in Cell
- LibreOffice Calc - Display formulas in cells » How-To - Office Software
- Display Formula in Cell with values » Forum - Excel
- Excel formula if cell contains text then return value in another cell (Solved) » Forum - Excel
- Transfer Data Between Excel Spreadsheets » How-To - Excel
- How to use conditional format based on text [Solved] (Solved) » Forum - Excel