Excel: Display Formula Result in a Text Box

Updated 7 November 2026 · Standard formula, shown below

This guide shows you how to link a text box in Excel to a cell containing a formula, so the box displays the formula’s result and updates automatically when the value changes. You’ll need a worksheet with a formula already in a cell, plus access to the Insert and Formula Bar tools.

What You’ll Need

Excel 2010 or later (steps are similar in all modern versions).
A worksheet with at least one cell containing a formula (e.g., =SUM(A1:A5)).
Basic familiarity with selecting cells and typing in the Formula Bar.

Step-by-Step

Create the text box. Go to the Insert tab on the ribbon. In the Text group, click Text Box. Your cursor becomes a crosshair. Click and drag on the worksheet to draw the box. Type any placeholder text (e.g., “Result here”).
Select the text box. Click on the border of the text box (not the text inside). The border will become a solid line, and the box is now selected as an object.
Click in the Formula Bar. With the text box selected, look at the Formula Bar at the top of the Excel window. Click inside it. The cursor will appear, ready for input.
Type the cell reference. Type an equals sign (=) followed by the address of the cell that contains your formula. For example, if your formula is in cell C2, type =C2. You can also click the cell directly after typing the equals sign.
Press Enter. After pressing Enter, the text box will display the result of the formula in that cell. The box is now linked.
Test the link. Change a value that feeds into your original formula. The text box should update instantly to show the new result. If it doesn’t, double‑check the cell reference.

Common Mistakes

Typing the formula instead of the reference. In the Formula Bar, you must type =C2, not =SUM(A1:A5). The text box can only display a cell’s value, not execute a new formula.
Selecting the text inside the box. If you click the text, you’re in edit mode. You must click the border to select the whole text box object. Otherwise, the Formula Bar won’t show the link.
Using a relative reference when copying. If you copy the text box to another location, the reference may shift (e.g., =C2 becomes =D3). Use an absolute reference like =$C$2 if you plan to copy the box.
Forgetting to press Enter. If you click away without pressing Enter, the link is not applied.

Tips

Format the text box. Right‑click the border, choose Format Shape, and adjust fill, border, and text properties. The linked result will adopt the text formatting you set.
Use for dashboards. This technique is great for creating clean, floating displays of key metrics (e.g., a large total in a colored box).
Link to a defined name. If you give a cell a name (e.g., TotalSales), you can type =TotalSales in the Formula Bar. This makes the link easier to read and maintain.
Combine with text. You can type static text in the box and then add the linked cell. For example, type “Total: ” and then press Enter on a new line before linking the cell, or use the & operator in a helper cell.

Troubleshooting

Text box shows 0 or blank. Check that the referenced cell actually contains a formula that returns a value. If the cell is empty, the box will show 0 or nothing.
Text box doesn’t update. Make sure calculation is set to Automatic. Go to Formulas > Calculation Options and select Automatic. If it’s on Manual, press F9 to recalculate.
Formula Bar is grayed out. The text box may not be selected as an object. Click the border until you see the solid outline, then try again.
Linked cell shows #REF! or #VALUE!. The original formula has an error. Fix the formula in the cell first; the text box will then display the corrected result.
Text box disappears when scrolling. Text boxes are floating objects. To keep them visible, go to View > Freeze Panes and freeze the rows above and to the left of the box.

Frequently Asked Questions

Can I link a text box to a formula that isn’t in a cell?
No. The text box only displays the value of a cell. You must put the formula in a cell first, then link the box to that cell.

Will the text box update if I change the formula in the linked cell?
Yes. As long as calculation is set to Automatic, the text box will reflect any change in the cell’s value, including when the formula itself is edited.

Can I use a text box to show a date or time?
Yes. Link the box to a cell containing a date/time formula (e.g., =TODAY()). Format the cell as a date, and the box will display it accordingly.

How do I remove the link but keep the text?
Select the text box, click in the Formula Bar, delete the equals sign and reference, then press Enter. The box will keep the last displayed value as static text.

Does this work in Excel for Mac?
Yes. The steps are the same, but the ribbon layout may differ slightly. Look for the Text Box button under the Insert tab.

Can I link a text box to a cell on another sheet?
Yes. In the Formula Bar, type the sheet name followed by an exclamation mark, e.g., =Sheet2!A1. If the sheet name has spaces, enclose it in single quotes: ='My Sheet'!A1.

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