How to insert a background image and print it out in WPS Spreadsheet

Uploaded time: November 22, 2021 Difficulty: Primary

How to insert a background image and print it out in WPS Spreadsheet

How to insert a background image and print it out in WPS Spreadsheet

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out.

 

First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate.

_1.gif


Here is a smart way for adjusting those undesired pictures, where the Screenshot function is needed. Hold down the shortcut key Ctrl+Alt+X, and select the area that contains the table. The screenshot size will be displayed in the upper left corner, providing a reference for the picture to be inserted. All you need to do is to adjust the background image to the size of the screenshot.

_2.gif


Once inserting the adjusted image, we can click the Print Preview button, but the background image fails to display. That's where the Camera can help, an old friend in our previous tutorial, remember? Select the cell area to be printed, click the Insert tab, click the Camera button. Then, come to Sheet2, and use the Camera to drag out the wanted area.

_3.gif


Double-click the image to return to the original data in Sheet1, any modified content will reflect in Sheet2. Finally, click the Print Preview button, and you can see the background picture displayed in the print preview.

_4.gif


Did you get it?