Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

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 your worksheet data to be read over the image. This feature can be quite effective if you have a special corporate watermark graphic that adds just a hint of a background without obscuring the data being presented in its cells.

Keep in mind that a graphic image that you assign as the worksheet background doesn’t appear in the printout, unlike pattern and background colors that you can assign to ranges of cells.

1

Display the worksheet to which you want to assign a graphic in the background.

You can apply a background image to just one sheet at a time. If you select multiple sheets, the Background button becomes unavailable.

2

Click the Background command button in the Page Setup group of the Page Layout tab.

The Sheet Background dialog box appears. This is where you select the graphic file for the worksheet background.

3

Open the folder that contains the image you want to use, click its graphic file icon, and then click Insert.

Excel closes the Sheet Background dialog box, and the image in the selected file becomes the background image in the current worksheet.

To remove a background image, click the Delete Background command button on the Page Layout tab of the Ribbon (which replaces the Background button the moment you assign a background image to a worksheet). Excel immediately clears the image from the entire worksheet.

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!