How to insert a printable background image in Excel?

When we insert a background with clicking Background button under Page Layout tab in Excel, the background is not printable, and you cannot view the background in print preview. Is it possible to print a background image in Excel? Yes, there is a special method to insert a printable background image in Excel.

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

To do it, follow these steps:

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

Step 1: Click the Insert > Shapes, and select a rectangles shape, see the following screenshot:

doc-insert-printable-image1

Step 2: Draw a shape in active worksheet.

Step 3: Drawing Tools is active now, please click the Shape Fill button and fill the shape with white.

doc-insert-printable-image2

Step 4: Click the Shape Outline button, and replace the outline color with white.

Step 5: Then right click the shape, and select the Format Shape item from the context menu.

doc-insert-printable-image3

Step 6: Click the Fill button at left bar, see the following screen shot:

  • Select the Picture or texture fill option;
  • Click the File button to specify a image to fill this shape;
  • Check the Tile picture as texture option;
  • Change the Transparency to 75%.

doc-insert-printable-image4

Step 7: Click the Properties button at left bar, and

  • Check the Move and size with cells option in Object positioning section;
  • Check the Print Object option.

doc-insert-printable-image5

Step 8: Click Close button. Then the shape filled with pictures looks like a background image. What's more, it can be printed out when you print the active worksheet. See the following screenshot:

doc-insert-printable-image6


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh