To show a formula result in a text box in Excel, put the formula in a cell first. Then click the border of the text box, type = in the formula bar, click the cell with the formula, and press Enter. The text box now shows the result and updates whenever the cell changes.
These steps follow Microsoft’s Dynamically display the contents of a cell or range in a graphic object article. The rest of this guide covers what you need first, how to add a label to the number, how to undo the link, and what to check when it does not work.
What you need before you start
- A desktop version of Excel. Microsoft’s instructions use the Insert tab and the formula bar in the Excel desktop app. The article was first written for Excel 2010, and the same method applies to newer versions, including Excel for Microsoft 365.
- A cell that holds the formula. This is often called a helper cell, which simply means a cell that exists to feed another part of the sheet. It can sit anywhere, including on a different worksheet in the same workbook.
- A text box or shape. If you do not have one yet, you will add it in step 2 below.
Why you can’t type a formula into the text box itself
A text box doesn’t calculate anything. If you type =SUM(B2:B10) inside it, you will just see those characters as text. The formula has to live in a cell, and the text box points to that cell through the formula bar. The only thing a text box accepts in the formula bar is a reference to one cell, such as =D2.
How to link a text box to a cell
- Click an empty cell, such as D2, and enter your formula, for example
=SUM(B2:B10). Press Enter and check that the cell shows the result you expect. - If you don’t have a text box yet, select the Insert tab, then select Text Box in the Text group. Drag on the worksheet to draw the box in the size you want.
- Click the border of the text box to select the whole box. You should see the sizing handles around it, with no blinking cursor inside.
- Click in the formula bar above the worksheet and type =.
- Click cell D2. The formula bar now reads
=D2. You can also type the reference yourself. - Press Enter. The contents of the cell appear in the text box.
Heads up: linking replaces whatever was typed in the text box. If the box already holds text you want to keep, copy that text into a cell first.
Link to a cell on another worksheet
The formula cell does not have to be on the same sheet as the text box. In step 5, type the sheet name, an exclamation point, and the cell, such as =Sheet1!F2. Microsoft gives this exact format as a tip in its instructions. This is handy when you want to keep your calculations on one sheet and a clean summary on another.
How to confirm the link works
- Click the border of the text box and look at the formula bar. It should show the cell reference, such as
=D2. - Change one of the numbers your formula uses, such as a value in B2:B10.
- Check the text box. It should show the new result without any extra steps.
How to show a label and a number together
A text box can only link to one cell, and it shows that cell’s contents and nothing else. You cannot type words in front of the linked result. To show something like “Total: $4,500”, build the whole sentence in the helper cell and link the text box to that cell.
Use the & operator to join text and a formula, and the TEXT function to control how the number looks. For example:
="Total: "&TEXT(SUM(B2:B10),"$#,##0")
The text in quotation marks is your label. The TEXT function turns the sum into text using a format code, here a dollar sign with a thousands separator and no decimals. Microsoft lists more format codes in its TEXT function reference, including these:
| What you want | Formula for the helper cell | Sample result |
|---|---|---|
| Currency with two decimals | ="Total: "&TEXT(SUM(B2:B10),"$#,##0.00") | Total: $1,234.57 |
| Percentage | ="Growth: "&TEXT(D5,"0.0%") | Growth: 28.5% |
| Today’s date | ="Updated: "&TEXT(TODAY(),"MM/DD/YY") | Updated: 10/04/26 |
| Day of the week | ="Report for "&TEXT(TODAY(),"DDDD") | Report for Sunday |
One caution from Microsoft: TEXT converts the number to text, so the helper cell is not a good source for other calculations. Keep the original value in its own cell and point any other formulas at that cell instead.
The helper cell can hold any formula that returns a single value. An IF formula, for instance, lets the text box show one message when a total is above a target and a different message when it is below. If you need help joining cell contents, see our guide on how to combine first and last names in Excel, which uses the same technique.
How to keep the helper cell out of sight
You often don’t want the formula cell to show next to the text box. Two simple options:
- Put the formula on another worksheet and link to it with the sheet name, such as
=Sheet2!D2. - Put the formula in a cell that sits outside the printed or visible area of your report.
Don’t delete the helper cell or the row or column it sits in. The text box depends on it, and without the cell there is nothing left to display.
How to change or remove the link
To point the text box at a different cell, click its border, click in the formula bar, and replace the reference with the new one, then press Enter.
Microsoft’s article doesn’t describe a separate command for unlinking. In general, selecting the text box, deleting the reference from the formula bar, and pressing Enter leaves the box as a normal text box that you can type in again. If that doesn’t behave as expected in your version, delete the text box and draw a new one. Deleting the text box never affects the formula cell.
Other objects you can link the same way
- Shapes. Go to Insert, select Shapes in the Illustrations group, draw the shape, then follow steps 3 to 6 above. Microsoft notes that this does not work with scribble, line, or connector shapes.
- Chart titles, labels, and text boxes on a chart. Select the chart element, type = in the formula bar, click the cell, and press Enter. Microsoft covers this in Link a chart title, label, or text box to a worksheet cell. Linking is not currently available for map, treemap, sunburst, histogram, Pareto, box and whisker, waterfall, and funnel charts.
- A picture of several cells. A text box holds one cell only. To show a whole range, Microsoft suggests the Camera command. Add it by clicking the arrow next to the Quick Access Toolbar, choosing More Commands, selecting All Commands, then Camera, Add, and OK. Select the range, click Camera, and click where you want the linked picture.
Troubleshooting
The text box shows the formula as text
The formula was typed inside the box instead of in the formula bar. Delete the text, click the border of the box so that no cursor is blinking inside it, and repeat steps 4 to 6.
Excel shows an error when you press Enter
The formula bar for a text box accepts a single cell reference only. Entries such as =SUM(B2:B10), =D2&" units", or a range like =B2:B10 will not be accepted. Move that formula into a cell and link the text box to the cell.
The text box doesn’t update
First, select the text box and confirm that the formula bar shows the right cell. Then check whether the workbook is set to calculate manually. In Excel for Windows, go to File > Options > Formulas and, under Workbook Calculation, select Automatic. Be aware that this setting applies to every workbook you have open. To recalculate once without changing the setting, press F9 or select Calculate Now on the Formulas tab. Our guide on how to make an Excel spreadsheet update automatically goes into more detail.
The number looks different from the cell
If the result in the text box doesn’t have the currency symbol, decimals, or date layout you want, don’t rely on the cell’s formatting. Wrap the value in the TEXT function, as shown above, so the helper cell produces the exact text you want to see.
You can’t type an equal sign in the formula bar
Make sure a shape or text box is selected and that it is not a line, connector, or scribble. If the worksheet is protected, objects may be locked, so you may need to unprotect the sheet first.
Frequently asked questions
Can a text box in Excel contain a formula?
Not a calculating one. A text box can only hold a link to a single cell, entered in the formula bar as something like =D2. Put the real formula in that cell, and the text box displays its result.
Does the text box update automatically?
Yes. Microsoft states that because the cell is linked to the object, any change to the data in that cell automatically appears in the text box. If it doesn’t, check that calculation is set to Automatic.
Can I link a text box to more than one cell?
No. Join the values in one helper cell with the & operator, such as =A1&" - "&B1, and link the text box to that cell. To show a block of cells as they appear on the sheet, use the Camera command instead.
Can I format a linked text box?
Yes. The link controls what the box says, not how it looks. Select the text box and use the font, size, and color tools on the Home tab, or the fill and outline options on the Shape Format tab that appears when the box is selected.
Can the linked cell be on a different sheet?
Yes. Type the sheet name and an exclamation point before the cell, such as =Sheet1!F2, which is the format Microsoft shows.
Next steps
Once your text box is linked, try building a more useful result to feed it. You can calculate percentages in Excel for a growth figure, or learn how to put a bulleted list in an Excel cell if you want several lines in one place. For more, browse our Excel guides.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read hundreds of millions of times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.