Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Adding Text to a Shape. You can add text to all sorts of drawing shapes, not just text boxes. Here's how easy it is.

Changing the Appearance of Arrows. Arrows are a common addition to a worksheet, as they can be used to point out data you want highlighted. Excel supports several different types of arrows, and you can easily switch from one arrow type to another.

Changing the Appearance of Lines, Dashes, and Arrows. Do you want to change the way that an existing line, dash, or arrow appears? You can change the drawing object in any number of ways, as described in this tip.

Changing the Layering Order of Drawing Objects. Drawing objects can be layered over each other in almost any manner you desire. If you want to change the order in which those drawing objects are layered, you'll want to use the techniques in this tip.

Drawing a Line in Excel. One of the common things that people draw in workbooks is the simple line. Excel allows you to draw several different types of lines.

Flip a Drawing Object. Want your drawing object to be mirrored horizontally or vertically? It's easy to do using the controls on the Format tab of the Ribbon.

Specifying the Line Color of a Drawing Object. Excel allows you to create some simple line drawings in your worksheets. If you want, you can change the color of the lines used for those drawing objects.