Forum Discussion

Muchty's avatar
Muchty
Copper Contributor
Jan 24, 2021

Adding text to filled shapes

I'm trying to add numerals to filled shapes , but cannot work out how to do it! 

 

4 Replies

  • Muchty 

    If you want the text to change then typing

    =$J$7

    into the formula box while the shape is selected will cause it to display the cell content as it changes.

     

  • Charla74's avatar
    Charla74
    Iron Contributor

    Muchty 

     

    Try right clicking on the shape and you should see 'Edit Text', select this option and you should be able to add text inside the shape.

  • Muchty 

    Select the shape, then simply type the digits (or other characters) that you want.

    You can use the Font and Alignment groups on the Home tab of the ribbon to format the text.

Resources