How would you put a formula in a text box in Excel?
Rajesh Pathak
Here are the steps:
  1. Insert text box in the worksheet from ‘Insert’ ribbon tab.

  2. Now click inside formula bar and type = sign.

  3. Click on the cell that needs to be linked with the text box.

  4. Press Enter.
  5. Now changing the value or the formula of the linked cell in the spreadsheet will change the value in the text box as well.