Link an Excel Text Box to a Table Heading or Cell
Question details
Display a changing cell value or table heading in an Excel text box.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants a text box to display a value from an Excel table or worksheet cell.
- Observed behavior
- Structured table references do not work directly in the text box formula bar.
Identify the worksheet cell containing the value or table heading you want to display. Make sure the text box is selected by its border rather than placing the cursor inside its text.
Link the text box to the worksheet cell
Use a direct cell reference when a structured table reference does not work in the text box formula bar.
Click the border of the text box to select the entire object.
Click the formula bar and type a reference such as =$A$2, using the address of the cell containing the desired value or table heading.
Press Enter. The text box displays the cell value and updates when that value changes.

Work with spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and compatibility with Excel files, making it easy to move existing spreadsheets into a new workflow.

Frequently Asked Questions
Why won't a structured table reference work in my text box?
Excel text boxes do not recognize structured table references directly. Select the text box border and enter the worksheet cell address, such as =$A$2, in the formula bar instead.
How do I display a table heading in a text box?
Find the worksheet cell containing the heading, select the text box border, and enter that cell's address in the formula bar. Press Enter to create the link.
Will the text box update when the cell changes?
Yes. After you link the text box through the formula bar, it displays the source cell's value and updates when that value changes.
Why can't I enter a reference for my text box?
Make sure you click the text box border to select the object, then click the formula bar. Typing inside the text box edits its text rather than creating the cell link.




