Microsoft Office Tutorials and References
In Depth Information
Applying colors and patterns
Adding graphic backgrounds to worksheets
Adding background images to worksheets is easy. Click the Page Layout tab on the
ribbon, and click the Background button. A standard Windows file-management dialog box
appears, from which you can open most types of image files, located anywhere on your
computer or network. Excel then applies the graphic image to the background of the active
worksheet, as shown in Figure 9-59.
Figure 9-59 Add a background graphic to any worksheet.
Here are some tips for working with background images:
The example in Figure 9-59 is a cover sheet for a large workbook; be careful when
using backgrounds behind data. It can be difficult to read cell entries with the wrong
You might want to turn off the display of gridlines, as shown in Figure 9-59. To do so,
clear the Gridlines View check box, which is also located on the Page Layout tab.
If you don’t like the way the background looks with your data, click the Background
button again, whose name changes to Delete Background when a background is
The graphic image is tiled in the background of your worksheet, which means the
image is repeated as necessary to ill the worksheet.
Cells to which you have assigned a color or pattern override the graphic background.
Backgrounds are preserved when you save the workbook as a webpage.