Drawings & Graphics

How to Add a Background Image to an Excel 2007 Worksheet

You can add a graphic image to the background of an Excel 2007 worksheet. The background image (sometimes called a watermark) should be very light in color or use a greatly reduced opacity in order for [more…]

How to Edit and Format Text Boxes in Excel 2007

When you insert a text box in Excel 2007, it can look quite plain. You can format text boxes to make them stand out on the worksheet. Use the options on the Format Shape dialog box to dress them up with [more…]

How to Insert Pictures from Graphics Files in Excel 2007

In Excel 2007, you can insert pictures such as digital photos or scanned images that are saved as graphics files into your worksheets.

If you want to bring in a graphic image created in another graphics [more…]

How to Insert Shapes in an Excel 2007 Worksheet

You can insert graphic shapes such as lines, rectangles, block arrows, stars, and other basic shapes into your Excel 2007 charts and worksheets. All you need to do is select a thumbnail on the Shapes drop-down [more…]

Reordering and Grouping Graphic Objects in Excel 2007

In Excel 2007, you may find the need to reorder objects in a worksheet or group multiple objects together so that they act as one unit. Reorder objects if you want to move an object in front of or behind [more…]

How to Add Data Visualizations in Excel 2007

In Excel 2007, you can instantly apply data visualizations to cells by using data bars, color scales, and icon sets that help you quickly understand data variations in your tables. Excel provides several [more…]

How to Manipulate Excel 2007’s Graphic Objects

Excel 2007 provides many tools that enable you to manipulate graphic objects in your worksheets. You can delete, move, resize, rotate, flip, and crop objects, for example. Cropping an image or picture [more…]

Aligning Multiple Graphic Objects in Excel 2007

When you're working with multiple objects or shapes in Excel 2007, you may occasionally need to align the objects in certain ways to improve their appearance in the worksheet. Excel provides several alignment [more…]

Formatting an Excel 2007 SmartArt Graphic

After you create a SmartArt graphic in a worksheet, Excel 2007 provides many ways to format that graphic on the SmartArt Tools contextual tabs. For example, you can change the color scheme and style of [more…]

Editing and Formatting Clip Art and Pictures in Excel 2007

When a clip art image or imported picture is selected, Excel 2007 adds the Picture Tools Format tab to the Ribbon. Use the commands on the Picture Tools Format tab if you need to edit or format clip art [more…]

Hiding Graphic Objects in Excel 2007

The Selection and Visibility task pane in Excel 2007 enables you to control whether various graphic objects in the worksheet are hidden or displayed. Hiding objects can make it easier to select other objects [more…]

Annotating with Text Boxes in Excel 2007

Text boxes in Excel 2007 are graphical boxes that you can use to add explanatory text or commentary to a worksheet or chart. Text boxes can be positioned wherever you like and can be formatted to match [more…]

Excel 2007’s Graphic Object Basics

Add graphic objects such as shapes, pictures, clip art, text boxes, WordArt, and SmartArt diagrams to add visual interest to Excel 2007 charts and worksheets. Excel supports two types of graphic objects [more…]

How to Insert and Format WordArt Text in Excel 2007

Use WordArt — stylized text objects — to add pizzazz and emphasis to headings and other text in your Excel 2007 worksheets. WordArt objects can be moved, resized, arranged, rotated, and formatted just [more…]