Arrow left
Back to product guides
Google Sheets Formulas

How to Use FORMULATEXT function in Google Sheets

In this article, you will learn how to use the FORMULATEXT formula in Google Sheets.

What is the purpose of the FORMURATEXT?

This function allows you to show formula in a cell as text. Typically, when you want to see a formula in a cell, you need to put your cursor on the cell and look at the formula bar or press “F2”. With the FORMUEATEXT, you can make a formula remain on the sheet even when your cursor is not on the cell containing the formula.

How to use the FORMULATEXT formula in Google Sheets

  1. Type “=FORMULATEXT” or go to “Insert” “Function” “Info”“FORMULATEXT”
  2. Refer to a cell containing a formula that you want make visible
How to insert the FORMULATEXT in Google Sheets

The generic syntax of the formula is as follows:


Cell: You just need to refer a cell that contains the formula you want to make visible.

The following screenshots includes five examples of the application of the FORMULATEXT. You can see specific formulas in Column E. They are visible because of each FOUMULATEXT function from cell E3 to cell E8.

What the FORMULATEXT functions look like in Google Sheets

How do I use the autofill function in Google Sheets?

Check this article if you want to know how to turn on and use the autofill function in Google Sheest.

Analyze your live financial data in a snap

Are you learning this formula to see how your financial model works If so, LiveFlow can put your reporting with custom formulas on autopilot and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access more than fifty templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711