'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Make an Excel Background Image Print Across the Full Page
Question details
The user needs to print a background image in Excel so that it covers the entire printed page without leaving any white margins.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Setting up an Excel worksheet to print with a custom background or watermark that spans edge-to-edge on the physical paper.
- Observed behavior
- When an image is inserted into the worksheet header, it does not cover the complete printed page and leaves a white border.
Before modifying your print layout, ensure your background image has a high enough resolution to be stretched across a full page without becoming pixelated, and create a test copy of your workbook to safely adjust settings.
Adjust Page Margins and Header Scaling
To make an image inserted into the header cover the full page, you need to eliminate all page margins and scale the image to fit the paper dimensions.
Excel adds default margins to all printed pages. By setting these margins to zero and adjusting the image properties within the header, you can force the picture to span the entire sheet.
Navigate to the 'Page Layout' tab, click on 'Margins', and select 'Custom Margins'. Change the Top, Bottom, Left, Right, Header, and Footer values to 0.
In the same Page Setup dialog, switch to the 'Header/Footer' tab and click on the 'Custom Header' button.
Select the section containing your image (e.g., Center section), then click the 'Format Picture' button. Under the 'Size' tab, adjust the Height and Width to match your physical paper dimensions (like 11 inches by 8.5 inches).
Go to 'File' > 'Print' and click on 'Printer Properties'. If your printer supports it, enable the 'Borderless Printing' option to remove the hardware-enforced white edges.
Use a Rectangle Shape Filled with an Image
Since Excel's standard 'Background' feature does not print, using a rectangle shape filled with your desired picture is a reliable alternative for full-page backgrounds.
Easily Adjust Print Layouts with WPS Spreadsheet
WPS Spreadsheet offers an intuitive interface for adjusting print margins, headers, and backgrounds, making it simple to print edge-to-edge documents without the hassle of complex formatting.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your workbook. Navigate to the 'Page Layout' tab on the top ribbon.
- 2. Adjust page margins: Click 'Margins' > 'Custom Margins' and set all margin values (including Header and Footer) to 0.
- 3. Insert your image: Use 'Insert' > 'Picture' to place your image or use the Header/Footer tool to embed it in the background.
- 4. Preview and print: Click 'Print Preview' to verify the image spans the full page, then proceed to print utilizing your printer's borderless setting.
Frequently Asked Questions
Why doesn't the standard Excel background print?
The 'Background' feature located under the Page Layout tab in Excel is designed specifically for on-screen viewing and will not print. To print a background, you must either insert an image into the header/footer or use a shape filled with a picture.
How do I remove the small white border around my printed Excel page?
Even if you set your Excel margins to zero, most printers have a hardware limitation known as the minimum printable margin. To remove this white border entirely, you must access your printer's specific properties in the print dialog and enable 'Borderless Printing' if your printer model supports it.
How do I type over the background image if I use the shape method?
If you use a shape filled with an image, it sits on top of your cells. You can increase the shape's transparency in the Format Shape pane so the underlying cells show through, or simply enter your data in text boxes placed over the shape.
