This quick tip shows you how to link a cell to a shape in Excel. We will link cell A1 to a circle, which will update automatically upon change.
Steps to Link a Cell to a Shape in Excel
Now that you have a shape in Excel, let’s do something with it.
Follow the steps below to link a cell to a shape in Excel.
- Type in some text in cell A1. Note: You can use a formula too. In our case, we typed “Happy birthday!“
- Click on the shape. In our case, a circle. Note: Only click once to show sizing nodes.
- Click inside the formula bar and type in your link or click on cell A1.
- Press Enter.
You should see the same contents you have in cell A1 in your shape. See our results below.
You done it! A linked shape in Excel.
Guess what? You can format the text, change the shape, resize, or even move it around. Almost anything you want to do. Just do not remove the link from the formula toolbar.
Good stuff, huh?
Related Quick Tips
Questions and Comments
If you have any questions or comments, feel free to contact us at email@example.com.