Lesson 59 – FORMULATEXT function in Excel | Display formulas or functions of individual cells only

In this lesson, I’m going to be showing you how to:

  1. Use the FORMULATEXT function to permanently show on the screen, the formulas or functions that’s been used

Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 60: What is the AVERAGEIF function in Excel | How to insert the AVERAGEIF function in Excel?

Or go back to:

Lesson 58: SUMIFS function in Excel to ADD multiple CRITERIONS from different columns

Lesson 57: SUMIF function used to ADD up MULTIPLE different items in one column in Excel | SUMIF+SUMIF

Lesson 56: SUMIF function in Excel | What it is & how to insert the SUMIF function in Excel?

Lesson 55: COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel

Lesson 54: COUNTIFS function in Excel with 2 examples | How to use Data Filter in Excel

Lesson 53: COUNTIF function used to COUNT MULTIPLE different items in a column in Excel | COUNTIF+COUNTIF

Lesson 52: COUNTIF function in Excel | What it is & how to insert the COUNTIF function in Excel?

Lesson 51: How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than

Lesson 50: How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

Lesson 49: How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

Lesson 48: How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

Lesson 47: How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

Lesson 46: Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel

Lesson 45: How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel

Lesson 44: Use the IF function to work out if you are over BUDGET or not in Excel

Lesson 43: How to change a DATE to different FORMATS in Excel

Lesson 42: How to set and print rows & titles automatically at the top of each page in Excel

Lesson 41: How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

Lesson 40: How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel

Lesson 39: How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Lesson 38: How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Lesson 37: How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel

Lesson 36: Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!

Lesson 35: How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

Lesson 34: What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Lesson 33: How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 32: What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 31: Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30: Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29: Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28: A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27: What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26: Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25: Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24: How to SORT data in ASCENDING order in Excel

Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22: How to RENAME a worksheet in Excel

Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

27 thoughts on “Lesson 59 – FORMULATEXT function in Excel | Display formulas or functions of individual cells only”

  1. What if we have applied the wrong formula? Can it be corrected in this function? I mean, suppose I were to calculate the circumference of a circle and instead of 2pieR, I use 3pieR. Would I come to know my mistake? Does it tell us when we make a mistake?

    • Hi Aparna – this function will only display the functions you’ve used in front of you, so you can then analyse them and see if any mistakes has been made.

      Habib (ICT tutor)

  2. This is another formula I didn’t know existed until today. I would always have to go back and click on the formula box then read it above. Wow, what a neat trick and very handy might I add. This will make it so much easier when you have a lot of formula’s to work out. Is this something new they added recently?

    • Hi Rick, the formulatext function was introduced in 2013 version of Excel. Happy to hear you enjoyed this function and it will be very useful for you. Take care 🙂

      Habib (ICT tutor)

  3. Thank you for educating us more with Excel and the numerous functions that are available.

    With so many different functions, unless you are competent with this application then you are missing out on so much.

    Many of the functions you mention I had never heard of before and I now know some great functions that could make my life a little easier.

    Thanks for sharing

  4. Hi Habib,

    Thank you for sharing. It is an interesting function. But I’m just wondering when do we need to display the formulas on Excel. Is it a common function in our daily work? Since I never need to display formulas in my daily Excel work to my colleagues. Anyway, thank you for sharing. It is still good to learn an interesting function.

    All the best,


    • Hi Alex, using the formulatext function, you can display them on the screen to check each one for errors or perhaps show others how it is done.

      Habib (ICT tutor)

  5. I did not know about this FORMULATEXT function in Excel. When I used Excel years ago (over a decade ago …) I did not come across this function. Is it something new? Or perhaps I have gotten rusty and I am lucky to have found this lesson 😉
    Great tutorial again! And extremely useful!

    • Hi Christine, the formulatext function was introduced from the 2013 excel version. Thank you for your feedback, hope it was very educational for you. Take care 🙂

      Habib (ICT tutor)

  6. The FORMULATEXT function in Excel is very cool! Having learned Excel on older versions (where the FORMULATEXT function was not included), I can see how this feature could be very helpful to have.

    Thank you for another great lesson. I sure enjoy your teaching style and appreciate all the work that you do for your audience.

    • Thank you for your supportive feedback Michael. I sure hope all my other fans and visitors appreciate all my hard work and time I have dedicated to create all these free lessons for everyone to benefit by. Take care 🙂

      Habib (ICT tutor)

    • You’re very welcome Alyse. Formulatext function certainly makes our lives so much better, as we can have them on the screen and check for any mistakes we may have made with any of the formulas and functions. Take care 🙂

      Habib (ICT tutor)

  7. Hi Habib,

    Another great lesson that you have shared with us here. I will share your website with a friend of mine who is considering undertaking an Excel course. I believe there is no need to pay for training when you could find everything you need to know here on your youtube channel.

    Thank you for all the hard work you are putting in for all of us.

  8. You definitely have a great post.

    You are certainly recommendable if someone wants something with Excel.

    I think this post should be bookmarked for future references.

  9. Thanks again for sharing a valuable lesson on Excel. As a newbie to Excel functions, I find these blog posts very useful and have learned a lot from your site so far. Keep doing a great job!

    • You’re very welcome Ivan as always. I have plans for hundreds of many more lessons to come yet, so watch this space. Take care 🙂

      Habib (ICT tutor)

  10. Oh Habib thank you for your new training! Because I always have problems on how to show up the formula in Excel, I saw some other videos but they couldn’t help a lot. This video helps me a lot since I started watching video trainings from you, and I learnt a lot, especially for beginners who uses Excel at work like me. It’s very informative and useful even with your daily live.

    • Yes Ling, I have made my lessons very user-friendly and have explained all the jargon into plain English. Happy to hear you are leaning and enjoying my lessons. Take care 🙂

      Habib (ICT tutor)

      • What a great resource is this FORMULATEXT function in Excel! I am a fan of your tutorials, and this one is in great detail, but in particular is useful for me, because I have the problem that many times, when a financial file is not showing the right numbers or shows some check-sums, at times is difficult for me to identify the formula or the root of the problem, but this makes it all much easier.

        Thank you for putting together another great tutorial!


        • Thank you Pablo – yes, the formulatext function will allow you to check any issues with the formulas or functions while having them on the screen permanently. Of course, then you can delete it when not required anymore. Take care 🙂

          Habib (ICT tutor)


Leave a comment

1 Share
Share via
Copy link
Powered by Social Snap