Link a Cell to a Shape in Excel – Quick Tip

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.

Steps to link a cell to a shape.
Steps to link to a shape.
  1. Type in some text in cell A1. Note: You can use a formula too. In our case, we typed “Happy birthday!
  2. Click on the shape. In our case, a circle. Note: Only click once to show sizing nodes.
  3. Click inside the formula bar and type in your link or click on cell A1.
  4. Press Enter.

You should see the same contents you have in cell A1 in your shape. See our results below.

Linked cell inside of a shape.
Linked cell inside of a shape.

Success!

Successful completion of linked shape inside Excel.
Successful completion of linked shape inside Excel.

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?


Additional Information

Related Quick Tips

Insert a Shape in an Excel Spreadsheet


Questions and Comments

If you have any questions or comments, feel free to contact us at training@techronology.com.


Quick Tips

Techronology Home