How To Display Formulas In Excel

When you’re trying to teach people how to use MS Excel, it helps to easily show them the formula. Instead of just moving the mouse to the cell and then looking at the contents of that cell, you can use a macro…

Found this over at

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 :


Am saving a copy here in case the source website is offline.

In the future, I’ll add a video tutorial explaining how we added the DisplayFormula function to our MS Excel spreadsheet.

“Yes, I Want To Grow My Financial Life & Get The 11 TrulyRichClub Blessings!”

To Grab This Offer, Click Option Below:

» Truly Rich Club – Philippine Residents Click Here

» Truly Rich Club – International Residents Click Here

Gusto mo bang kumita sa internet, kahit super-BUSY ka? Here's the secret to making money online...

Share on Facebook

Do you appreciate the FREE info that you found here? Please show your support and click the LIKE button below, and we will publish more of the content that YOU want. Thanks!