How to

How to Print an Excel Spreadsheet with a Background

By default, when you print an Excel spreadsheet, it just consists of cells that contain data. Additional content is usually omitted, but it is possible to include a background to your Excel printouts– here’s how to do it.

While you can utilize the “background” option (Page Layout > > Background )to add a background image to your spreadsheet, Excel will not enable you to print backgrounds that are used this way. You need to utilize shapes, images, or cell colors as a work-around to accomplish the very same effect.

These instructions apply to current variations of Excel, consisting of 2016, 2019, and Microsoft 365.

Place a Shape

The easiest way to add a quick, background to a worksheet in Excel is to insert a things, like a shape, to cover your information or fill the whole page.

You can then alter the transparency of the item so you can see any data beneath it. You can also utilize the “Picture Fill” formatting option to fill the shape with an image.

To get started, open your Excel spreadsheet and click the “Insert” tab in the ribbon. From there, you can click “Pictures” or “Shapes” in the “Illustrations” section.

When you click “Shapes,” a drop-down menu with numerous options appears. Select the shape you desire, like a rectangular shape or square.

Utilize your mouse to drag and drop and create a shape that fills the page or your data. After you produce it, you can hold and drag the circular buttons around the shape to resize it.

After you have it sized and placed the way you desire, right-click, and then select “Format Shape” from the pop-up menu.

In the menu that appears, click the arrow beside “Fill” to open the submenu.

You can pick a color from the “Color” drop-down menu, and after that use the slider to set the openness to the suitable level (like 75 percent).

Your modifications are used automatically. When you’re done, you can close the “Format Shape” menu.

Add an Image

Thanks to the “Pattern Fill” alternative, you can also fill your shape with an image instead of a color. This indicates you can add an image background to your Excel worksheet.

Include your shape initially (Insert > > Shapes) and utilize your mouse to draw it, as we covered above. Make sure it fills enough of your worksheet to cover an appropriate hard copy area. Right-click your shape, and then click “Format Shape.”

Click the arrow beside “Fill” to open the options, and after that pick the “Picture or Texture Fill” radio button. To add your image, click “Insert.”

To utilize an image from your computer, click “From a File” in the “Insert Pictures” pop-up menu.

Click “Online Pictures” if you wish to search for an image on Bing or click “From Icons” to use among Excel’s predetermined images.

After you place it, the image fills the shape. Utilize the “Transparency” slider to set a portion that permits you to see the data below the image-filled shape.

Include a Background with the Fill Color Tool

To add a color to all the cells on your Excel worksheet at the same time, press Ctrl+A or click the vertical arrow in the top-left corner under the cell choice menu.

Click the “Home” tab, and after that click the Fill Color icon. Select the color you desire the background of your spreadsheet to be– remember it needs to be light enough that the information on your worksheet can be seen when you print it.

Modification the Print Area

By default, Excel won’t consist of empty cells in the print location (the area that appears on a printout). However, you can modify the print location to consist of the entire page (or numerous pages), regardless of whether the cells are empty.

To alter the print area to consist of empty cells, ensure you’re in the “Page Layout” view. Click the Page Layout icon in the bottom-right corner of Excel. This enables you to see the rows and columns that will fill a single, printed page.

Click the “Page Layout” tab on the ribbon, and after that click the Page Setup icon (the diagonal arrow at the bottom-right of the “Page Setup” category).

Click the “Sheet” tab, and then click the up-arrow beside “Print Area.” Use your mouse to select a cell range that fills the area you want to print, including any empty cells.

To ensure the best cells were selected, click File > > Print to see a print sneak peek.

If the cell variety you picked does not fill the page, repeat the actions above to alter it, so it includes more cells.

To get started, open your Excel spreadsheet and click the “Insert” tab in the ribbon. When you click “Shapes,” a drop-down menu with different alternatives appears. Thanks to the “Pattern Fill” choice, you can also fill your shape with an image instead of a color. Click the “Home” tab, and then click the Fill Color icon. Click the Page Layout icon in the bottom-right corner of Excel.

Leave a Reply

Need help with the Commons? Visit our
help page
Send us a message