To link a text box to a cell, have the text box selected, click in the Formula Bar and press = and then click the cell to link to and press Enter – see Figure 02. Then use the mouse to draw the text box above the sheet grid. To insert a text box, click the Insert ribbon and click the Text Box icon on the far right. The formulas are explained in the companion video to this article. There is a drop-down in cell A3 that allows you to choose a different comparison figure from the list below. In Figure 01, we have the sheet structure that we will use to create a group of text boxes to display on a report or dashboard. You can insert a default text box in the middle of the sheet by pressing in sequence Alt N X. You can use grouping to combine multiple text boxes to get the best of both worlds. Normal text boxes allow you to apply multiple formats to individual parts of the text. You can only apply formats to the whole text box.
This means you can use formulas and functions in a cell to create a dynamic heading, sentence or calculation, and then have the freedom to place it anywhere on the sheet.
Text boxes are independent of the Excel grid, and can be positioned anywhere on the sheet.
