Adding Drawing Objects to a Worksheet

Adding graphics or pictures of items described in your worksheets makes it easier to understand the data in those worksheets; you’re not limited to adding images from other sources. If you want, you can add drawing objects to your worksheets. For example, you can add shapes such as rectangles and circles to your worksheets, with the rectangles holding explanatory text and the circles displaying a one- or two-word caption describing the contents of a cell.

Add a Simple Shape

  1. Click the Insert tab.

  2. In the Illustrations group, click the Shapes button.

  3. Click the button representing the shape you want to add.

  4. Drag where you want your shape to appear.

    Tip

    Tip

    To create a circle or square, instead of an oval or rectangle, hold down the Shift key while you drag the mouse pointer.

    Tip

Add Text to Any Shape

  1. Click the shape.

  2. Type the text you want and press Enter.

    Add Text to Any Shape

    Caution

    Caution

    If the text you add to a shape won’t fit in the shape, you’ll see only the first part of the text you added. To view the rest of the text, you can enlarge the shape or make the text’s font size smaller.

Format Text in a Shape

  1. Click the shape.

  2. Click the Home tab.

  3. Using the controls in the Font group on the ribbon, follow any of these steps:

    • Click the Font down arrow and then click the desired font.

    • Click the Font Size down arrow and then click the desired size.

    • Click the Font Color down arrow and then click the desired color.

    • Use the other controls to assign bold, italic, underline, and other formatting options.

      Format Text in a Shape
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.118.152.58