Linking a Cell to a Text Box in Excel 2010

05/08/2016 17:42

 

 

Microsoft Excel has a functionality where we can link a textbox to a specific cell. If we change the data in the cell, the value of the linked cell gets updated automatically. Below are the following steps to link a cell to a text box:

1. Open Excel
2. Click on the Insert tab
3. Click the Text Box button

4. A text Box will Open

 

image2

 

5. Select the Text Box
6. Type = in the Formula Bar
7. Select the cell where you want to give a reference

 

Let us take an example

1. Open Excel
2. Click on the Insert tab
3. Click the Text Box button
4. A text Box will Open
5. Select the Text Box
6. Type = in the Formula Bar
7. Select the cell A1

 

image3

 

8. After we select Cell A1, automatically it will display “=$A$1”
9. Now when we change the Text in cell A1, automatically text in the Text Box will change

 

Source: https://www.exceltip.com/excel-editing/linking-a-cell-to-a-text-box.html

 

 


Crie um site com

  • Totalmente GRÁTIS
  • Centenas de templates
  • Todo em português

Este site foi criado com Webnode. Crie um grátis para você também!