It also means that lines and arrows stay true to horizontal or vertical. This applies constraints that force it to remain as a regular shape, whatever size you make it, meaning that circles don't become ovals and squares can't become rectangles. The answer to this problem is to hold down as you drag the object into place. It can be difficult to draw perfect circles and squares, even if you're simply resizing an autoshape. You can find the 'Group', 'Ungroup' and 'Send to front/back' options on the Drawing toolbar in earlier versions of Excel.

You can now resize, modify and move these shapes around at the same time, enabling you to use them like a logo if you wish. To group a number of shapes together, select each one while holding down and then choose 'Group' from the Arrange section of the ribbon.

When you select a shape in Excel 2007, the ribbon switches to the Format tab and you can change its colour and style using the options in 'Shape Styles'. In earlier versions of Excel, choose 'AutoShapes' from the Drawing toolbar, choose a category and select the shape you want. Click-and-drag the shape into place and use the handles to resize it if necessary.

In Excel 2007, select the Insert tab on the ribbon, click the 'Shapes' button and select the desired shape from the palette. You can insert vector graphics directly into an Excel spreadsheet by using the Shapes tool. In earlier versions, launch the Chart Wizard from the toolbar.

How to add word art to excel