Document Editing Problems

Link an Excel Text Box to a Table Heading or Cell

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

Display a changing cell value or table heading in an Excel text box.

Link an Excel Text Box to a Table Heading or Cell
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the text box

Click the border of the text box to select the entire object.

2
Enter the cell reference

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.

3
Confirm the link

Press Enter. The text box displays the cell value and updates when that value changes.

Link the text box to the worksheet cell
Table headings: For a table heading, use the address of the worksheet cell containing the heading instead of entering a structured table reference directly.
Free Microsoft Office alternative

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.

Open and edit Excel-compatible XLSX and XLS files.Work with spreadsheet tables and cell values in a familiar interface.Use a free, lightweight office suite for everyday document work.
microsoft office alternative - wps office

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.