Reader Level:

FormulaText in Excel 2013

By Megha Goyal on Aug 29, 2012
In this article we will discuss how to use the FormulaText formula in Excel 2013.

This is a new feature introduced in Excel 2013. This is used to return the string formula (if any) present in the cell of which we provide a reference to. If the cell does not contain a formula then it returns a NULL value .i.e. NA. The syntax of it is =FORMULATEXT(reference). Here reference is the reference to the cell of which we need to determine the formula.

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now open the blank workbook template from the available templates.


Step 3

Now enter some data into a few cells of the sheet as the outcome of the formula that we are using like this:


Step 4

Now if we want to see the formula which we have applied in the few cells by using keyboard shortcut key then first we will select the cell and then will press the ctrl+` key in the keyboard.

Step 5

The output will be like this:


Step 6

If we want it to return to the same position then we will again press the ctrl + ` key on the keyboard and the output will be like this:


Step 7

If we want to see the formula we applied in the few cells but in front of the cells then we will use the FormulaText() function and  for that we write a title named FormulaText in the cell.


Step 8

Now write the following formula in front of the cell:


Step 9

Now press enter; the output will be like this:


Step 10

Now copy this cell in which we have used the formulaText() formula and paste it into the cells we want to show the formula just in front of the formula applied cells and the output will be like this: