Excel 2019 Bible

(singke) #1

Part III: Creating Charts and Other Visualizations


FIGURE 23.20
Text Box shapes can be linked to cells.

Be aware that Text Box shape objects cannot display more than 255 characters.

Creating linked pictures
A linked picture is a special kind of shape that displays a live picture of everything in a
given range. Think of a linked picture as a camera that monitors a range of cells.

To “take a picture” of a range, follow these steps:


  1. Select the range.

  2. Press Ctrl+C to copy the range.

  3. Activate another cell.

  4. Choose Home ➪ Paste ➪ Linked Picture (see Figure 23.21).


The result is a live picture of the range you selected in step 1.
Free download pdf