Excel text box link to cell to auto update text box or shapes

How to add textbox or shapes?

Before learning how excel text box link to cell, if you dont know how to add textbox or shapes in excel, you can refer below steps:

To insert textbox, click on Insert on ribbon tab and click on text box.

text box insert

In case if you want to insert shapes to excel sheet, you can go to insert in ribbon tab and click on shapes and select the shape which you want to add.

shape insert

The text box and shapes will facilitate the easy movement in the sheet and additional formatting features as compared to cells in excel.

Excel text box link to cell

You can directly enter the text in text box and shapes and format that as per your requirement. However, in case if you want to link the textbox to a cell and automatically change the value of the textbox or shape as per the cell value, you can follow below steps:

  • Select a textbox or shape to link to cell.
  • Go to formula bar  and enter “=” and click on cell you want to link to textbox or shape.

Excel text box link to cell

Every time when you change the link of the textbox, it will reset the formatting and you will loose all formatting changes you have done to that shape. Therefore, be careful before changing the link of a textbox or shape.

 

Leave a Reply

Your email address will not be published. Required fields are marked *