"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Excel Users Become Local Spreadsheet Experts"

How To Link a Text Box to Data in a Cell

This is a really neat trick that I learned a few years ago.

In Excel, you can link a text box to a cell so that the text box displays the contents of the cell. Now that's pretty cool, but even better than that, you can format the data in your text box regardless of how it is formatted in the cell.

Here's what you do:

  1. Click the Text Box button on the Drawing toolbar, click in the worksheet, and drag the pointer to create the text box.
  2. Click in the formula bar or press F2.
  3. Type an equals sign (=) and then either enter the address of the cell (for example, type =A1) or select the cell that you want the text box to link to. In the example below I clicked the Sheet 2 tab and selected cell B25 which contained the value I wanted to display in the text box.
  4. Press the ENTER key. Whatever is in the linked cell will appear in the text box.
  5. Now you can format the text box however you like.

I'll bet there are many uses for this trick that you haven't even thought of yet. Just use a little imagination.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.