Excel 2010 All-in-One For Dummies
Book image
Explore Book Buy On Amazon

You can add a graphic image to the background of cells in an Excel 2010 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 an 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. On the Page Layout tab, in the Page Setup group, click the Background button.


    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 button on the Page Layout tab of the Ribbon (which replaces the Background button when you assign a background image to a worksheet). Excel immediately clears the image from the entire worksheet.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

This article can be found in the category: