Download WPS Office for your device

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....

When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell? In this spreadsheet, select a range of cells. In the Home tab , we can change text settings including Size and Text Color , and add effects for the texts such as Bold, Italic, Fonts, Underline, etc. 1. Select the cells filled with WPS Academy.2. Right-click the cells, and choose Format cells in the pop-up menu. Or we can just select the cells and press the shortcut Ctrl+1.3. Click the Font tab ....

When using WPS Spreadsheets, we can use the Fill Color tool to change the cell color. Are there any other methods to change the table style quickly? WPS Spreadsheets can realize it with its Format as Table function. 1. Select a cell range to be set. Get into the Home tab and click Format as Table to show its dropdown menu, where we can choose one from the default formats. 2. Left-click on any of the formats. Then, we can see the Format as Table dropdown menu. 3. Check the option titled....

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....

Sometimes we need to crop the picture into the shape we want after inserting it. So how can we do that? Take this table as an example. We have inserted a picture of the clothes on the table, but the picture is a little large. We need to crop it into the right shape and size. Click on the picture to jump to the Picture Tools tab. Click the Crop drop-down button, and we can see two options. Here we select Crop by Scale to adjust its scale. We select the 1:1 scale to crop the picture. No....

When editing WPS presentation files, we will inevitably need to enter some symbols that cannot be directly entered through the keyboard. So, how can we insert the special symbols as needed? Take the slides as an example. To facilitate statistics, we want to tick the box after the tourist attractions we have already visited. Click where we want to insert the symbol, click the Insert tab and the Symbol drop-down button. Here, we can see Recently Used Symbols and Custom Symbols. These are....

When a table is inserted in a word document, the text in the table may not display completely. Do you know how to fix it? l Case 1: Table exceeds page sizeWhen we copy the table in other platforms to insert it into the document, and the table exceeds the page width, the text on the right of the table will be incomplete.In most cases, we can use the mouse to slowly drag the box line to adjust to the appropriate position, which is too troublesome.Here is a practical trick helping you ad....

Many people don't know how to take screenshots when using WPS Writer. Let's take a look at how to use the WPS screenshot tool. First, click the Insert tab to find the Screenshot button. And in the Screenshot drop-down list, we can choose the screenshots of areas with different shapes. They are respectively: Rectangle screenshot, Oval screenshot, Rounded rectangle screenshot and Polygon screenshot. We can click Screenshot to take a screenshot within the WPS Writer interface. Its....