Welcome toExcel2007.Tips.Net
Beauty Tips
Excel2007 Tips
Pest Tips
Pet Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
The following articles are available for the 'Drawing Objects' topic. 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 Color Inside a Shape
Adding a shape to your workbook is easy. If you want to fill the shape with a color, you'll want to follow the information provided 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.