Display cell contents in a shape or text box

  1. Click the AutoShape (AutoShapes: A group of ready-made shapes that includes basic shapes, such as rectangles and circles, plus a variety of lines and connectors, block arrows, flowchart symbols, stars and banners, and callouts.) or text box you want to link.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.), type an equal sign (=).
  3. Click the worksheet cell that contains the data or text you want to link to.

You can also type the reference to the worksheet cell. Include the sheet name, followed by an exclamation point, for example:

Sheet1!F2

  1. Press ENTER.

 Note   You cannot use this procedure in a freeform, scribble, line, or connector.

 
 
Applies to:
Excel 2003