Excel - Display Formula in Cell

December 2016




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 :

This document entitled « Excel - Display Formula in Cell » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.