This page created on Thursday, February 2, 2017 by Bill Jelen
This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Add a Printable Background to a Worksheet
Problem: The image I added as a background using the instructions in the previous topic will not print. How do I add a background image that will print?
Strategy: You can add a shape to cover the printable area of your worksheet and then change the shape fill to be your picture. Microsoft allows you to alter the transparency of the shape. Follow these steps:
Choose Insert, Shapes dropdown, Rectangle. Draw a rectangle to cover your print area.
Select Drawing Tools Format, Shape Outline, No Outline.
Right-click the shape and choose Format Shape. Excel displays the Format Shape dialog.
In the Fill category, choose Picture or Texture Fill.
In the Insert From section, click the File button. Browse, select a picture, and click Insert.
At the bottom of the Format Picture dialog, increase the Transparency slider. You can preview the picture transparency as you slide. Around 60% seems to be appropriate. The figure below shows the worksheet at 60% behind the dialog.
Click Close to dismiss the Format Picture dialog box.
Results: Excel will add a background that can be printed.
When you use fill for a shape, you can adjust picture transparency.
Gotcha: It is now difficult to select a cell with the mouse. If you click on a cell that is covered by the transparent picture, you will select the picture. To avoid this, you click outside the picture and then use the arrow keys to navigate to cells behind the picture.