Print an Excel Spreadsheet with a Background



RECOMMENDED: Click here to fix Windows errors and optimize system performance

By default, when you print an Excel spreadsheet, it contains only cells that contain data. Additional content is usually excluded, but it is possible to add a background to your Excel printouts – you can learn how to do this here.

Although you can use the Background option (Layout > Background) to add a background image to your spreadsheet, Excel does not allow you to print backgrounds applied in this way. To achieve the same effect, you must use shapes, images, or cell colors as an alternative.

These instructions apply to the latest versions of Excel, including 2016, 2019, and Microsoft 365.

Adding a Background Image in Excel Spreadsheet

Open the worksheet you want to print with a background image. Click the Layout tab and then click the Background button in the Layout group. Select an option to insert your image. For example, click the “Browse” link next to “From File” to select an image on your computer – or search for an image online using the fields next to “Office.com Clip Art” and “Bing Image Search”. Select an image, then click Open or Paste to apply it to your background.



January 2021 Update:

We now recommend using this tool for your error. Additionally, this tool fixes common computer errors, protects you against file loss, malware, hardware failures and optimizes your PC for maximum performance. You can fix your PC problems quickly and prevent others from happening with this software:

  • Step 1 : Download PC Repair & Optimizer Tool (Windows 10, 8, 7, XP, Vista – Microsoft Gold Certified).
  • Step 2 : Click “Start Scan” to find Windows registry issues that could be causing PC problems.
  • Step 3 : Click “Repair All” to fix all issues.

download



Insert a printable background image in Excel with drawing of a shape

To complete this work, please follow the steps below in order:

1. Click on Insert > Shapes and select a rectangular shape, as shown in the following figure
2. Draw a shape as large as needed in the active worksheet.
3. the drawing tool is now active, please click on the “Shape Fill” button and fill the shape with blank
4. Click the “Shape Outline” button and replace the outline color with white, as shown in the following screenshot
5. Then right-click on the shape and select Format Shape from the context menu.
6. Perform the following operations in the Image Format dialog box in Excel 2010 or in the Image Format area in Excel 2013
7. Then perform the following operations in the same dialog box:


8. Click the Close button. The shape filled with images will look like a background image. It can also be printed when you print the active worksheet.

Changing the Print Area

By default, Excel does not include empty cells in the print range (the range that appears on a printout). However, you can change the print range to include the entire page (or several pages), regardless of whether the cells are empty or not.

To change the print range to include empty cells, make sure you are in the Layout view. Click the Page Setup icon in the lower right corner of Excel. This allows you to see the rows and columns that will fill a single printed page.

  • Click the Layout tab on the ribbon, and then click the Layout icon (the diagonal arrow in the lower right corner of the Layout category).
  • Click the Page Setup tab, then click the up arrow next to the print area. Use the mouse to select a series of cells that will fill the area you want to print, including empty cells.
  • To make sure the correct cells are selected, click File > Print to see a print preview.
  • If the range of cells you selected does not fill the page, repeat the steps above to change it to contain more cells.

https://support.microsoft.com/en-us/help/213977/you-cannot-print-a-background-graphic-for-a-excel-worksheet



RECOMMENDED: Click here to troubleshoot Windows errors and optimize system performance