Strategy: Follow these steps:
1) Display the Drawing toolbar.
2) Click on the Rectangle tool. Draw a white rectangle to cover your print area, as shown in Fig. 1200.
3) Select the Line Color icon and choose No Line, as shown in Fig. 1201.
4) Right-click the rectangle and choose Format AutoShape.
5) On the Colors and Lines tab, there is a fill dropdown. This has the usual color palettes. Select the Fill Effects choice, which is below the color palette, as shown in Fig. 1202.
6) There are four tabs in Fill Effects. Choose Picture, the rightmost tab. Choose the Select Picture button. Select your picture, as shown in Fig. 1203.
7) In the lower left corner, select Lock Picture Aspect Ratio. Choose OK to close fill effects.
8) Back on the Format AutoShape dialog, move the transparency slider from 0 to 80, as shown in Fig. 1204.
9) On the Properties tab of the Dialog, check to make sure the item will print, as shown in Fig. 1205.
10) Choose OK to Close the Format AutoShape tab.
Result: As shown in Fig. 1206, you’ve added a background that can be printed.
Summary: With this technique, you can add a semi-transparent background that will print behind your spreadsheet.
Commands Discussed: Format AutoShape