Copying Excel 2007 Formatting with Format Painter
Renaming an Excel 2007 Worksheet
Applying Conditional Formatting in Excel 2007

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.


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.


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.


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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Adding a Standard Header or Footer in Excel 2007
How to Hide and Unhide Rows and Columns in Excel 2007
Applying a Table Style to an Excel 2007 Table
Previewing Excel 2007 Formatting with Live Preview
Hiding and Unhiding Excel 2007 Worksheets