WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


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

Uploaded time: November 22, 2021 Difficulty Beginner

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

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.

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.

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.

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.

Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.