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

Comments  

+7#Mike M.2013-10-25 17:18
Thanks - but the image is not in the background. It is covering the excel data. Was a step missed?
Reply | Reply with quote | Quote
0#HelloKelly2013-12-06 06:39
Hi,

In the Step 6, change the Transparency to 75% or lower. If the picture is not transparent, it will cover the excel data completely.

Hope this help you
Reply | Reply with quote | Quote
+2#Anonymous2014-03-24 16:58
insert the image in the header, you are able to work on your data and also print it as the background.
Reply | Reply with quote | Quote
-1#Ailyn V. Mibato2014-06-06 08:22
:-) good day.....uhmmm.. please read and follow the steps carefully and for sure you will get it...:)
Reply | Reply with quote | Quote
0#Ailyn V. Mibato2014-06-06 08:24
:-) Good day!.. please read and follow the steps carefully and for sure you will get it...:)
Reply | Reply with quote | Quote
-1#skyyang2013-10-28 01:55
Dear Mike, it can’t insert image as background in Excel by default, using this method, it just make the image look like the watermark.
Reply | Reply with quote | Quote
+2#Flo2013-12-05 18:23
The way to make this work and still show data through the image is to save the image as a .emf file!
Reply | Reply with quote | Quote
+1#Mark H.2013-12-05 20:01
Mike M., the purpose of this is to add a printable background (through methods of a loop hole), 0% transparent image. This was exactly what I needed. Thanks a bunch!
Reply | Reply with quote | Quote
+2#anon2013-12-07 12:25
Yes, BUT, how to make it so you can click on the cells over the image and edit them without selecting the background image?
Reply | Reply with quote | Quote
0#Rajendran2014-01-01 12:41
You can hide the picture using Selection Pane (in Format Tab under Arrange tools) and work on your data. While printing, the same shall be enabled. Sending back wont be working on this..
Reply | Reply with quote | Quote
+1#anon2013-12-07 19:58
I just discovered the LibreOffice allows one to add an image as a background and print with the background as well...
Reply | Reply with quote | Quote
-1#Nasim Khaliqhey2014-02-11 09:20
can you please interduce the pogrammer module for inserting the background picture & text in PIC 18F4455 I have been using EB006 I can not teransfer the data from my window Vista to my PIC18F4455
Reply | Reply with quote | Quote
+1#eldonjon722014-02-25 19:31
If you need to keep the picture, but allow for Excel data to show through (for example, a form in the background with Excel data in the cells showing through, so you can print a filled-in form):

Follow the instructions above, except keep the transparency at 0%.
Using "Picture Tools" in Excel, use the "Remove Background" function
Remove the background of the picture (for example, the white space on the form), keeping only the form text/design itself

The form/background picture will now be visible but the Excel data will show through, and will print out a filled in form.
Reply | Reply with quote | Quote
0#frustrated12014-05-08 17:50
I couldn't get any of these options to work. :(

75% or 0%, hiding the picture...none of them will allow me to enter in cells and print the background.
Reply | Reply with quote | Quote
0#aldo2014-05-19 16:29
Another (and far faster) way could be:
1- print the image you want as background from Photoshop or whatever program you used to generate it. Just one, or many if you are printing out invoices for example.
2- Print on the same paper sheet the excel chart.
If using a laser printer, be aware that the paper will bend after the first printout.
Reply | Reply with quote | Quote
0#aldo2014-05-19 16:39
Another way that will keep cells editable.
Take a screen picture of the chart at 100% zoom.
Open it in Photoshop, select all and copy.
Open the image you want as background and paste the screen capture.
Press v and 5, this will make the layer with the screen capture 50% opaque. You'll use this as a guide.
Select the background image layer, and resize it to better fit the chart.
Now, press and hold on the crop tool button and select the "slices" tool.
Slice the image in squares and rectangles to isolate the cell's areas in the chart.
Export for Web and Devices, Images only.
In Excel, insert the slices, except the ones on top of the cells.
Reply | Reply with quote | Quote
0#Rico2014-05-28 20:45
Thank you! You're a life saver. Very easy and simple, yet effective fix. It's a bit different if you do it on Excel 2010 for OSX; there isn't a shape button in the menu by default so it has to be found through Insert > Shape...
Reply | Reply with quote | Quote
0#Smithe5442014-06-07 14:40
Normally I do not read post on blogs, but I wish to say that this writeup very compelled me to try and do it! Your writing style has been surprised me. Thanks, quite great article. dgbgceadegcdddek
Reply | Reply with quote | Quote
0#DumdumDarren2014-06-17 13:23
DO NOT USE THIS TERRIBLE, BASIC SOLUTION!
Any colouring in the image will tint your text, even at 75% transpareny and so you'll effectively have the colour of your text changing throughout each line.
What's more important to you and your business? Pretty background pictures or a professional looking document?

Give that the screenshots all show the Ribbon menu, its safe to assume whoever posted this 'solution' is using a new enough version to simply click Page Layout > Background. Done.
Reply | Reply with quote | Quote
0#Notsodum2014-07-20 01:06
Wow, you are a dum dum. This works perfectly. The problem with using Page Layout > Background is you can resize or adjust the transparency in Excel. So no, that does not work well for most backgrounds. I have no text color changes at all. For those who still can't figure out how to edit. There is a post above that tells you how.

Quoting Rajendran:
You can hide the picture using Selection Pane (in Format Tab under Arrange tools) and work on your data. While printing, the same shall be enabled. Sending back wont be working on this..
Reply | Reply with quote | Quote

Add comment


Security code
Refresh