Link Autoshape to a Cell

November 23rd, 2004 | Categories: Formatting | Tags:
-->

You can link Autoshapes that can contain text to a cell. The text in the Autoshape will change when the cell is updated.

linkautoshape

1. Draw an Autoshape on your spreadsheet
2. In the formula bar type an equals sign (Make sure the Autoshape is still selected)
3. Click the cell you want to link to the Autoshape and hit Enter
4. Add formatting to your Autoshape

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. elif
    December 29th, 2009 at 11:47
    Reply | Quote | #1

    I couldnt be sucsessful can u explane this both .
    2.In the formula bar type an equals sign (Make sure the Autoshape is still selected)
    3. Click the cell you want to link to the Autoshape and hit Enter

    thank u

  2. Sasikumar
    May 31st, 2011 at 11:06
    Reply | Quote | #2

    Hi.,

    Its wonderful, I am searching many days to find this. Thanks for the same.

    In this I want something extra, it was linking only one cell, but we need to show 2 cells for example In Cell A1 having Person X and Cell B1 having Employee Number example 00125, we want to show in one autoshape like “Person X 00125″.

    How to do this please help us

    Thanks in advance

    Regards

    S SASIKUMAR