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.
Insert a printable background image in Excel with drawing a shape
To finish this job, please do with the following steps one by one:
1. Click the Insert > Shapes, and select a rectangles shape, see the following screenshot:
2. Draw a shape as large as you need in active worksheet.
3. The Drawing Tools is active now, please click the Shape Fill button and fill the shape with white.
4. Click the Shape Outline button, and replace the outline color with white as well as following screenshot shown.
5. Then right click the shape, and select the Format Shape item from the context menu.
6. In the Format Picture dialog box in Excel 2010 or Format Picture pane in Excel 2013, please do the following operations:
In Excel 2010: (1.) Click Fill option from the left pane;
(2.) Select the Picture or texture fill option;
(3.) Click the File button to specify a image to fill this shape;
(4.) Check the Tile picture as texture option;
(5.) Change the Transparency to 75% as you need to make the background image like watermark.
In Excel 2013 and later versions: (1.) Click Fill & Line button;
(2.) Under the Fill section:
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% as you need to make the background image like watermark.
7. In the same dialog, then do the following operations:
In Excel 2010: (1.) Click Properties option at left bar;
(2.) Select the Move and size with cells option in Object positioning section;
(3.) Check the Print Object option.
In Excel 2013 and later versions: (1.) Click Size & Properties button;
(2.) Under the Properties section:
Select the Move and size with cells option;
Check the Print Object option.
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:
Note: After inserting this background picture, you will not be allowed enter any text within the picture range.
Insert a printable background image in Excel with Kutools for Excel
The above method has its own limit that you can’t enter any text after inserting the background image, but, if you have Kutools for Excel, with its Insert Watermark feature, you can quickly insert the image or text watermark which can be printable as well as you need.
After installing Kutools for Excel, please do as follows:
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.
1. Go to the worksheet which you want to insert the printable background image, and click Kutools > Insert > Insert Watermark, see screenshot:
2. In the Insert Watermark dialog box, select Picture Watermark option, and click Select Picture button to select a picture that you want to insert as printable background, and then, specify the image scale or formatting as you need, see screenshot:
3. Then click Apply or Ok, and the selected image has been inserted into the worksheet background, when you print it, the background image will be printed as well. See screenshot:
1. After inserting the watermark background, you can also type the text into the worksheet.
2. With this feature, you can also insert the text watermark as you need.
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel
2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features
30-day free trial. 60-day money back guarantee.
If you need the background strictly for printing purposes, I set the image as my background using typical methods. Set cells to no fill as necessary, then highlight everything that I am planning to print. Next I copy and paste in the same position except make sure to paste as an image. Now you can print all of your information with your background. If you need to edit something later, delete the image edit the data than repeat the procedure.
The downside to this tool is that it doesn't seem to work like the Word watermark function that allows me to scale the image watermark. So I started over and opened the image in Photoshop to manually enlarge the image to scale it into Excel properly.
That didn't work because Kutools scaled it back what it was prior to me enlarging the image manually.
Not sure why this is done this way unless I'm missing a step whereby I can set the scale.
I have a solution: Just keep in excel format * .kls and open it in OpenOffice. Go to the Format / Page and select the image. After 3 hours of time various forums I found this solution, I'd be glad to someone else this solution help. Greetings from Serbia.
[quote name="Goran from Serbia"]I have a solution: Just keep in excel format [b]*.xls[/b] and open it in OpenOffice. Go to the Format / Page and select the image. After 3 hours of time various forums I found this solution, I'd be glad to someone else this solution help. Greetings from Serbia.
Now I have in mind fill out form in Acrobat Reader. Is it possible in Excel 2013 to merge two separate sheets one with the outline and forms and one with the fill in data with for example look up functions? Or merge two sheets during the printout?
When I do this the text from the excel come out faded. So if i were to increase the transparency of the picture then the text will be darker but the test on the picture will be faded. Anyway to get them both about the same to print out?
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.
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.
[quote name="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..[/quote]
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...
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.
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.
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.