In Excel, we will create a shape link to a cell. Meaning, we will put the value of a cell inside a shape. And, when you update that cell, the value within that shape is updated.
After you establish a link, that ordinary shape turns into a dynamic floating shape. Good stuff, huh!
For the purpose of this quick tip, you will need Excel 2007 or higher or compatible.
As shown in the above image, we have a spreadsheet that contains sales and rank data for three states. So, what we want to do is create a shape link that will display the rank for Nevada.
Follow the steps below to create a shape link to a cell in Excel.
There you have it! A shape linked to a cell.
Additionally, we applied formatting to our shape. And, you can do the same thing. For the most part, you can format a shape link in the same fashion as a regular shape.
If you had an issue performing this task, then try going through the steps again. Sometimes, people get stuck on step 2 of Create a link. Therefore, what you can do is just select the shape and type in the entire link directly, and press Enter.
Remember, if the value of the cell changes
I guess you are wondering, what can I do with this? Well, many things.
Below is an example of what you can do with a shape link in Excel.
Again, good stuff, huh! Enjoy doing some fun stuff with this new knowledge.
Create a shape link to a cell in Excel
by Excel Effects :: October 20, 2020