Excel Convert Formula Cell References to Values or Text

Updated 10 November 2026 · Standard formula, shown below

To convert a formula cell reference in Excel, first decide whether you want to replace a formula with its current result, change the reference style, or turn a reference into text. For a fixed result, copy the formula cell and use Paste Special → Values; for other goals, use the appropriate reference or text function instead.

What “convert a formula cell reference” can mean

The phrase can describe several different Excel tasks. These are not interchangeable: replacing a formula with its result removes the calculation, changing a reference style affects how a formula points to cells, and converting a reference to text produces a label rather than a live link to a cell.

Formula to value: Keep the displayed result but remove the formula that produced it.
Relative to absolute reference: Lock a row, column, or both when copying a formula.
Cell address to text: Display an address such as A1, or create a reference dynamically from text.
Formula to text: Show the formula itself as characters instead of calculating it.

Before changing cells, check which meaning fits your task. In particular, a formula’s displayed number is not necessarily a permanent value: it can change when its inputs change or when Excel recalculates.

Replace a formula with its current value

This is the usual method when someone asks how to convert a formula cell to a value. Copying and pasting values over the original cell preserves the result currently shown, while discarding the formula.

Select the formula cell or range and copy it with Ctrl+C on Windows or Command+C on Mac.
Keep the same cells selected, open the paste options, and choose Values. You can also right-click and choose the values-only paste option. The exact presentation of paste options can vary by Excel version.
Click a cell and inspect the formula bar. A converted cell should show a number, date, or text value rather than a formula beginning with =.

For example, if A1 contains 12, B1 contains 3, and C1 contains =A1*B1, C1 displays 36. Pasting C1 as a value changes its contents to 36. If A1 later changes to 15, C1 remains 36 because the formula is gone.

If you want to keep the original calculation, paste the result into another location instead of over the source cell. This is also safer when you need to compare the formula and its output or may need to restore the calculation.

Change relative and absolute references

Cell references inside formulas can move when you copy a formula. A relative reference such as A1 adjusts according to the destination. An absolute reference such as $A$1 stays fixed. Mixed references lock only one part: $A1 fixes the column, while A$1 fixes the row.

For example, enter =A2*$D$1 in a row of a sales table and copy it downward. The reference A2 becomes A3, A4, and so on, but $D$1 continues pointing to the rate in D1. To change a reference’s style while editing a formula, select the reference and press F4 on Windows. Depending on the keyboard and Excel version, you may need Fn+F4. Repeated presses cycle through relative, absolute, and mixed forms. On Mac, keyboard shortcuts can differ; you can type the dollar signs directly.

To change the display of worksheet references between A1 and R1C1 notation, open File → Options → Formulas in Windows Excel and toggle R1C1 reference style. On Mac, look under Excel’s settings or preferences for its formula or general options. This changes how references are shown, not the underlying calculation or the cell values.

Turn a cell reference into text or build one dynamically

If you need a cell’s address as text, use the ADDRESS function. For example, =ADDRESS(2,1) returns the text $A$2 under the default options. The row and column arguments are numbers, so =ADDRESS(2,3) represents C2. Optional arguments let you choose absolute or relative notation and the reference style.

To get the address of a cell reference already in a formula, CELL can return address information. For example, =CELL("address",A2) returns the address of A2 as text. The precise result can include sheet or workbook context depending on the reference and Excel’s behavior, so check the output if you plan to use it in another formula.

To turn text into a live reference, use INDIRECT. For example, if A1 contains the text B3, =INDIRECT(A1) returns the value in B3. This is different from displaying the address: INDIRECT interprets the text as a reference. It can make a workbook harder to audit, and references created from text do not always update as straightforwardly as ordinary references when rows or columns are inserted.

Show a formula as text

To display a formula itself rather than its result, enter an apostrophe before the equals sign, such as '=A1+B1. Excel treats the entry as text, and the apostrophe is generally not displayed in the cell. You can also format a cell as Text before entering the formula, then type it again; changing a cell’s format after a formula is already entered does not necessarily convert that existing formula into text.

For a temporary view of formulas across a worksheet, use Show Formulas on the Formulas tab, or the keyboard shortcut shown in Excel for your platform. This changes the worksheet display, not the contents: turn the option off to return to calculated results.

Common problems and checks

The formula is still present: A normal paste may copy formulas. Choose the values-only paste option and check the formula bar.
The result changed before conversion: Excel may recalculate formulas when inputs change. Confirm the displayed result before replacing the formula, especially if it uses volatile functions such as NOW or RAND.
The cell shows a date or rounded number: Paste Values preserves the value, but destination formatting can affect how it looks. A date is stored as a numeric value with date formatting; check both the formula bar and number format if the display seems unexpected.
References shift after copying: Lock the required row or column with dollar signs, such as $A$1 or A$1, before filling the formula.
Text does not become a working reference: A string such as “B3” is only text until a function such as INDIRECT interprets it. ADDRESS works in the opposite direction, returning reference notation as text.

Frequently Asked Questions

How do I convert a formula to a value without changing the displayed result?
Copy the cell, then paste Values over it. This preserves the result currently displayed but removes the formula, so later changes to its inputs will not update that cell.

Can I convert formulas to values for an entire worksheet?
You can select a range or worksheet cells, copy them, and paste Values over the selection. Be careful: this removes formulas throughout the selected area, including formulas you may want to retain. Save a copy first if the change is difficult to undo.

How do I make a cell reference absolute?
Add dollar signs to the parts that must stay fixed. Use $A$1 to lock both column and row, or press F4 while editing a selected reference on supported keyboards.

How do I convert a cell address to text?
Use ADDRESS with row and column numbers, such as =ADDRESS(2,1) for A2-style address text. Use CELL when you need address information for a cell reference already in a formula.

Does Paste Values keep the formula’s formatting?
Values-only paste is intended to paste results rather than formulas. Depending on the paste command and version, formatting may be handled separately; choose the specific Values option and check the destination’s number format if appearance matters.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.