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.

 

 

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).