• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Drawing Objects

Many of the tools on the Drawing toolbar let you draw objects—lines or shapes—in worksheet or chart windows. Excel lets you draw lines, rectangles, squares, ovals, circles, shapes (including complex AutoShapes), and text boxes. Objects you draw can be selected, resized, moved, or copied at any time.

To draw a line or arrow

1.
Click the appropriate button on the Drawing toolbar's Lines pop-up menu (Figure 4) to select it:

Figure 4. Although the Drawing toolbar includes a Line tool button, the Lines pop-up menu offers additional tools for drawing lines.


  • Line draws straight lines. (The Line tool also has a button on the Drawing toolbar.)

  • Arrow draws straight lines with an arrowhead on one end.

  • Double Arrow draws straight lines with arrowheads on both ends.

  • Curve draws smoothly curved lines.

  • Freeform draws lines combining straight and freeform segments.

  • Scribble draws lines wherever you drag the mouse.

    When you click the tool's button the mouse pointer turns into a crosshairs pointer (Figure 5) or, in the case of the Scribble tool, a pencil (Figure 6).

    Figure 5. When you click a drawing tool's button, the mouse pointer changes into a crosshairs pointer…


    Figure 6. …or, in the case of the Scribble tool, a pencil pointer.


2.
Position the mouse pointer where you want to begin drawing.

3.
To draw a line, arrow, or double arrow, press the mouse button down and drag. As you move the mouse, a line is drawn (Figure 7). Release the mouse button to stop drawing (Figures 8 and 9).

Figure 7. Drag to draw a line.


Figure 8. A freshly drawn line.


Figure 9. A freshly drawn arrow.


or

To draw a curve, move the mouse to stretch a line (Figure 7) and click where you want the curve to appear (Figure 10). Repeat this process to draw as many curves as desired. Then either click the starting point or double-click the ending point to stop drawing (Figure 11).

Figure 10. Using the Curve tool, click to indicate where the curve should appear.


Figure 11. A curved line with two curves.


or

To draw a freeform shape, combine clicking and dragging to draw straight lines and freeform lines: click from point to point to draw straight lines and drag (with a pencil tool that appears automatically) to draw freeform lines (Figure 12). Either click the starting point or double-click the ending point to stop drawing (Figure 13).

Figure 12. Using the Freeform tool, click to draw straight lines and drag to draw freeform lines.


Figure 13. In this example, the line has been turned into a closed-off shape by clicking the starting point to complete the drawing.


or

To draw a scribble, press the mouse button down and drag the pencil pointer to get the desired line shape (Figure 14). Release the mouse button to stop drawing (Figure 15).

Figure 14. To use the Scribble tool, hold the mouse button down and drag the pencil pointer.


Figure 15. Releasing the mouse button completes the scribble.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint