Download WPS Office for your device
Choose Windows, Mac, Linux, Chromebook, Android, or iOS.

Download WPS Office for All Platforms
Find your device and get the right version
- Choose your platform
- Download WPS
- Install and launch
Search Results
462 results for how to set the print area in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
462 results for how to set the print area in excel
How to set the print scaling
01:15How to set the print scaling
We want to print the table on one page, but the table is too large. It is divided into several pages when printed. Then, how can we do? The print scaling feature of WPS Presentation can help you solve this problem quickly. Take this document as an example. We can see that without scaling, the table will be divided into four pages for printing. Just click the Page Layout tab above, then Page Zoom, and finally click Fit Sheet on One Page. In this way, the table will automatically adapt ....
Set the page printing area in WPS Office Spreadsheet
00:47Set the page printing area in WPS Office Spreadsheet
What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....
How to print the notes in PDF
01:21How to print the notes in PDF
We may add notes to important content when reading a PDF document. Do you know how to print them out?Take this document as an example. We have added several notes on the page. 1. Click Menu and click Print.2. On the right of the pop-up dialog, select Document and Note Contents in the "Print content" drop-down button.3. Then the marks of notes are displayed in the preview window. However, we still fail to print out the contents in the text boxes. What can we do? There are two methods fo....
How to set the background in WPS Presentation
01:38How to set the background in WPS Presentation
Do you think the slideshow with a blank background is a little boring? If you want to make the slideshow look more beautiful, we can try to use the Background function in WPS Presentation. First, we click the Design tab above and then click the Background drop-down menu. Here, you can choose your favorite gradient fill preset. If we want to make more settings for the background, we can click Background. In the Object Formatting task pane that pops up on the right side of the screen, we....
How to set the text direction in WPS Writer
01:47How to set the text direction in WPS Writer
Usually, when editing a document, the text is input horizontally from left to right by default. In the following video, we will teach you how to change the direction of the text. First, select the text that needs to be changed, and click the Text Direction drop-down button in the Page Layout tab. Here, we can see six styles in the list. 1.Horizontal Text Box: This is the default text direction in WPS Writer. 2.Vertical from right to left: At this time, the text is vertical and aligned ....
How to set the picture outline in WPS Presentation
01:48How to set the picture outline in WPS Presentation
When creating a presentation file, inserting too many pictures can easily lead to messy typesetting. Properly adding outlines to pictures can highlight key pictures and make the layout more logical and the slides more beautiful. Select the picture, click the Picture Tools tab, and then click the Picture Outline drop-down button. Here, we can set the Colors, Weight, and Dashes of the Picture Outline with just one click. If we want to set the Picture Outline further, we can click the Mor....
How to set the table properties in WPS Writer
02:19How to set the table properties in WPS Writer
After we insert the table in the document, we may want to set the table. So how are we going to do that? Take the table in this document as an example. The width of the table is too long. If we need to adjust it, just click the cross cursor in the upper left corner of the table. Select the entire table, click the Table Tools tab, and click the Table Properties button. Now we can see a dialogue box has popped up. In the Table tab, we can enter an appropriate value in Size to adjust the....
How to set the text fill in WPS Presentation
01:55How to set the text fill in WPS Presentation
The various filling effects added to the text can beautify the slide while emphasizing the text. So, how can we add and set the text fill? Select the text, click the Text tool tab and the Text Fill button. Here, we can fill the text with different effects, including Solid fill, Gradient fill, Picture or texture fill and Pattern fill. We can choose from a variety of colors recommended by WPS Office for filling the text quickly with one click. If you want to choose more kinds of colors, ....