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:

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:


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.


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.


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%.


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.


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:


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