See all How-To Articles

How to Print a Background Image in Excel & Google Sheets

This tutorial demonstrates how to print a background image in Excel.

 

picture background print

 

Insert a Background Image as a Shape

If you want to insert a printable background picture in Excel, you should use shapes and insert a background image in a shape.

  1. In the Ribbon, go to Insert > Shapes > Rectangle.

 

insert shape excel

 

  1. Now, draw a shape and position it over the data table. A rectangle shape filled in blue is the default.

 

insert shape excel 2

 

  1. Now, insert a picture to replace the blue color fill. Select the shape and, in the Format Picture window, choose Picture or texture fill and click Insert.
    Note that, if the Format Picture window does not open automatically, it can be opened by right-clicking on the shape and selecting Format Shape…

 

insert picture in shape

 

  1. In the pop-up window, choose From a File to insert a picture from your computer.

 

insert picture in shape 2

 

  1. In the browse window, select a picture and click Insert.

 

insert picture in shape 3

 

  1. The selected picture is now shown in the shape. In the Format Picture window, set Transparency to 75%, so you can see the data in the picture. Increase or decrease the transparency to get the desired look.

 

insert picture in shape 4

 

Background Image Size

To resize the image so it prints on the whole page, go to Size in the Format Picture window, and adjust the Height and Width.

 

picture size excel

 

Now the background image is spread across the whole page, and if you go to File > Print (or use the shortcut CTRL + P), you’ll see in Print Preview that the entire page has the background picture you inserted.

 

picture background print