Excel Text Box Linking: Dynamic Data Presentation

Linking Text Box To A Specific Cell

1. Go to the ribbon to the Insert tab.

2. Click a Text Box button.

3. Draw a text box into your worksheet.

4. Click your text box.

5. Go to Formula Bar and type an address of cell eg. B2.

6. In your text box you’ll see a content of the cell.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References