O'Reilly logo

Excel 2010: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Drawing Shapes

If the stock graphics provided in the clip art collection don't satisfy your inner art critic, you can create your own pictures. Excel's drawing features make this process a lot easier than you might expect. In fact, you can create everything from simple shapes to complex art without leaving your worksheet.

The starting point for all drawing activity is the ribbon's Insert→Illustrations→Shapes section, which is filled with potential shapes (Figure 19-10).

Before you can really get started drawing anything, you should understand the basic shape categories. They include:

  • Lines. This category includes straight lines, curved lines, and arrows.

  • Rectangles. Albeit ordinary, rectangles are great for storing bits of text or just wrapping themselves around groups of other shapes.

    Depending on how large your Excel window is, you may see a few shapes in the Insert→Shapes section. But if you click the drop-down arrow, you get a complete list, sub-divided into logical sections.

    Figure 19-10. Depending on how large your Excel window is, you may see a few shapes in the Insert→Shapes section. But if you click the drop-down arrow, you get a complete list, sub-divided into logical sections.

  • Basic Shapes. This category includes geometric shapes like the square, circle, rectangle, octagon, and more. Leave it to Microsoft to also include not-so-basic shapes like rings, lightning bolts, suns, moons, and even a happy face.

  • Block Arrows. This category includes a variety of one-way and two-way arrows, as well as shapes with arrows attached to them.

  • Equation Shapes. This category includes large ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required