Display cell contents in a shape or text box
- Click the AutoShape or text box you want to link.
- In the formula bar, type an equal sign (=).
- Click the worksheet cell that contains the data or text you want to link to.
You can also type the reference to the worksheet cell. Include the sheet name, followed by an exclamation point, for example:
Sheet1!F2
- Press ENTER.
Note You cannot use this procedure in a freeform, scribble, line, or connector.