There are 8 free training tutorials of how to use office suite for WPS
How to set the cell color to change as the data changes？
1. Open the table in WPS Office, select the cells that you want to set. 2. Click Home → Conditional Formatting → Highlight Cells Rules. 3. Select one of the rules as you need. Here we select Equal to for example. Fill a "5" in the text box, and select Light Red Fill with Dark Red Text. Then click OK. In the same way, we set "6" as Yellow Fill with Dark Yellow Text, and "7" as "Green Fill with Dark Green Text". 4. When the data in other cells is changed to 5, the changed cell will becom....
WPS Office, the best free office software in 2022
Welcome to WPS Offical Academy! Are you still looking for a free office software equipped with all basic and advanced features? Choose WPS Office and it will never let you down. Give us 5 minutes to convince you!l What is WPS OfficeWPS Office is a creditable and high performing free office software launched by the Kingsoft team of China. In the software market all over the world, it is considered as the best alternative to Microsoft office suite. With WPS Office, you're able to eas....
How to change the page orientation of PDF online
In WPS PDF, we can rotate an individual page or all pages of the whole PDF. · Rotate an individual pageTo change the orientation of a single page, use the mouse to select a page. Then, click the rotate clockwise or rotate counterclockwise icon in the Home Tab. Rotate an invividual page · Rotate all pages of PDFIf we want to change the orientation for all the pages, get into the Home tab, and click the Rotate button. Rotate all pages of PDFWith WPS PDF, you can read, take annotation, co....
How to select all in WPS Writer
1. Open the document with WPS Office.2. Click the Home tab → Select → Select All. Or you can use the shortcut key Ctrl+A to select all in the document. To be office word advanced, you could learn how to use WPS Office Writer online in WPS Academy.
How to type Ñ in WPS Writer
1. Type the letter N in the document, and click the left mouse button to select N.2. Click the Insert tab.3. Click the Symbol button, and choose More Symbols...4. In the pop-up dialog box, hold down the left mouse button, drag the right scroll bar downwards, and click the symbol Ñ.5. Click the Insert button, and then click the Close button. Now, we can type Ñ in the document. To be office word advanced, you could learn how to use WPS Office Writer online in WPS Academy
How to insert an Organization Chart in Word？
Organization Chart is used to show hierarchical information or reporting relationships in an organization. The assistant shape and the Organization Chart hanging layouts are available with this layout. Here are the steps to create an Organization Chart.1. Open your word document, and click Insert → WPSArt. In the pop-up dialog, there are multiple built-in charts and we can select any one of them. Here we select the first one for example. 2. Then we can customize the chart in the toolba....
How to select text color
Take this document in WPS Writer as an example. It is also the same in WPS Presentation and WPS Spreadsheet.1. Use WPS Office to open the document.2. Then select the text that we want to change color.3. Click the Home tab and then click the Text Color Bottom.Users can select the color they want here. But if users still can’t find the color they want, click More Font Colors.1. Also, first select the text that we want to change color.2. Select Advanced in the Colors popout box.3. Click a....
How to move pages in Word
Move pages in Word Luckily, there are ways to rearrange and move WPS Word pages. You can rearrange them online or offline using two easy methods.There are two ways to move pages in Word, Methods of Moving Pages in WPS Word Through navigation pane and Without navigation pane. You can use any method to move pages in WPS word. These methods can be applicable on WPS 2019/2016/2013 and on ma c or Windows. No worries either you are offline or online these methods works in anyway. How to move....