For those who use the conventional methodology to add a background picture to your spreadsheet; Excel received’t print the picture. For those who want to print an Excel spreadsheet with a background picture. then this tutorial will present you ways to do it. You want to add the image individually in your spreadsheet in order that it detects the image whereas printing. This tutorial is for Microsoft 365, Workplace 2019, and 2016 customers solely.
By default, you possibly can go to the Web page Format tab and click on the Background choice to add an image to the background. Nonetheless, it really works so long as you retain the spreadsheet in your laptop solely. Everytime you strive to print the file, it deletes the background picture instantly. Generally, you might want to paste a picture in the background of the spreadsheet to customise it higher or as a watermark.
How to print the Background Image in Excel
To print an Excel spreadsheet with a background picture, observe these steps-
- End enhancing your spreadsheet in Excel.
- Insert a form protecting your information.
- Add a picture from Image or texture fill part.
- Alter the transparency.
- Print the spreadsheet.
To study extra about these steps, proceed studying.
After getting completed enhancing your spreadsheet you possibly can insert the background image; as a result of as soon as the background picture is inserted, it may be awkward to edit the spreadsheet. If you’re performed with the enhancing, go to the Insert tab and click on on the Shapes choice.
From right here, select a rectangle form and use your mouse to cowl the complete space that features your information. In case you have information from A1 to Z100, it’s essential to cowl the total space with that form. In different phrases, the background picture can be inserted in accordance to this chosen space. After that, right-click on the form, and choose the Format Form choice.
It should open a pane in your proper facet. Broaden the Fill menu and choose Image or texture fill choice from the record. As the title defines, it helps you add an image or a texture as the background. To switch the default texture, click on the Insert button below the Image supply choice.
Now you want to select a picture. If you have already got the image in your PC, click on on the From a File choice. If you need to fetch the picture from a web site, it is best to click on the On-line Image button, and observe the display screen directions.
After inserting the picture, change the transparency stage in order that it acts as a watermark. For that, use the Transparency menu to alter it in accordance to your necessities.
Now, you possibly can print the spreadsheet, and it received’t take away the picture from the background.
Hope this tutorial helps.
Learn: How to print chosen cells in Microsoft Excel or Google Sheets
How do I print a background picture in Excel?
To print a background picture in Excel, you want to insert a form first. Then, right-click on that form and choose the Format Form choice. Subsequent, develop the Fill pane and select the Image or texture fill choice. Click on on the Insert tab and select a picture. Then, change the opacity stage to 70-80%. Now, you possibly can print the spreadsheet as typical.
How do I print a background grid in Excel?
To print a background grid in Excel, you want to open the spreadsheet and go to the Web page Format tab. Then, head to the Sheet Choices panel. Subsequent, discover the Print menu and tick the corresponding checkbox. Following that, you possibly can press Ctrl+P to go to File > Print to begin the printing course of. If no information is on the market, it’s going to print solely cells.
Learn: How to change Web page Orientation to Panorama in Excel
