Excel: Link a Cell to a Text Box or Shape

Did you know that you can make any text box or shape display a value from a cell in your spreadsheet?

The process to link a cell to a text box or shape is really quite simple. Select the text box or autoshape, and now go to the formula bar and type in an equals sign and the address of the cell that you would like to display. For example, to show the contents of cell A3, I would type:


If it's in another worksheet, it's not problem! For example, to link it to cell B6 in the second worksheet, I would type:


After you've entered your formula, just press the Enter key and you'll see your text box or shape is displaying the contents of the cell you've chosen.

Happy linking!


Post a Comment