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 (8 steps)
Insert a printable background image in Excel with Kutools for Excel (3 steps)
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
(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.
Download and free trial Kutools for Excel Now !
Demo: Insert a printable background image in Excel with Kutools for Excel
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- 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.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!