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. Windows • MacOS • Linux • iOS • Android Select areas that need to improve Didn't match my interface Too technical or incomprehensible Incorrect operation instructions Incomplete instructions on this function Fields marked * are required please Please leave your suggestions below Tutorial Videos Uploaded time: November 22, 2021 Difficulty Beginner How to insert a background image and print it out in WPS Spreadsheet The trial has ended, please use the WPS client to continue watching

How to insert a background image and print it out in WPS Spreadsheet Does this video help you? 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? 1. Set the page printing area in WPS Office Spreadsheet 2. Explanations on print interface 3. Page setup and print-out for spreadsheets 4. Print out tables 5. Remove image background in WPS Writer 6. Page background: adjust background color and set a picture as background 15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.