How to view your Excel formulas in a cell

A reader contacted me asking how I displayed formulas on the squaring numbers post (see image below) and it got me thinking about adding this short post. I was asked whether I typed in the text in columns D and E from each formula manually or whether there was a quicker way and the answer was I used the FORMULATEXT function.

 

squaringnumbers1

 

The formula does exactly what it says on the tin, so cell D2 had the formula =FORMULATEXT(B2) in this example.

 

If you wanted to view all the formulas on a worksheet at once, you can go to the Formulas tab and within the Formula Auditing section of the ribbon select ‘Show Formulas’ (or use the shortcut A, M, H).

Leave a Reply

Your email address will not be published. Required fields are marked *