There are 8 free training skills of how to use office suite for WPS

How to highlight every other row in Excel?

When dealing with an Excel document with huge amounts of data, we may find it difficult to differentiate one row from another.At this point, highlighting alternate rows has been proven to make your data more readable and easier on the eyes. Here are the steps. 1. Select the desired cell range. Click the Home tab > Conditional formatting > New Rule to pop up a dialog. 2. In the Select a Rule Type area, select Use a formula to determine which cells to format. 3. Input the formula "=MOD(....

How to search file history in WPS Office

1. Open the WPS Office.2. Enter the content in the search box on the home page, then we can view the file history. For all, easy your work with WPS office suite. Free download WPS office for PC, Mobile, Windows, Mac, Android, iOS online.

How can we print files in WPS

Print is relatively complicated. So we are only going to introduce some basic features here. If you want to learn more about Print, you can watch our videos on Print in WPS Academy.Take this document in WPS Writer as an example. It is also the same in WPS Presentation and WPS Spreadsheet.After using WPS Writer to open the document, click the Print button in the upper left corner. Or we can also use the shortcut key: Ctrl+P. Then we can see the Print popup window. Now we are going to in....

How to use flash fill to quickly fill in data

Use WPS Office to open the table and select the cell need to be operated.Place the mouse cursor at the lower right corner of the cell, when the cursor turn into a cross, click and drag down to select all the cells that we want to fill data.Then click the icon appeared in the lower right corner, then select Flash Fill in the drop-down menu (or use shortcut key Ctrl+E).Note: Flash Fill can provide a filling rule that best meets the users' needs by comparing the relationship between s....

Numbering items in a worksheet

· Option 1: 1. Open the spreadsheet with WPS Office. 2. Enter the beginning number in the first cell where we want to start the numbering. In the example below, the numbering will start from the number “1”.3. Select the cell range to be filled. 4. Click the Fill button again → choose series → change the settings as demonstrated below a. Series in: choose “Columns” b. Type: choose “Linear” c. Step value: enter “1” (from which to start the numbering)d. Stop value: enter “14” (where the ....

Remove background music or audio inserted in slides

· Option 1: 1. Right-click the audio icon.2. Click Delete Object.3. Choose Yes in the popup prompt box. · Option 2: 1. Left-click the audio icon.2. Press Backspace or Delete on the keyboard.3. Choose Yes in the popup prompt box.WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.

Clear Formatting for Text Contents in Word Documents

1. Select the text contents that we need to clear formatting. 2. Click Home → the eraser icon (which stands for Clear Formatting in WPS Writer)No matter you are students, teachers or business professionals, can create and edit documents efficiently by WPS Writer as text editors. Easy to use as Microsoft Word.

WPS AI Slides: Complete 2026 Guide

2026 guide to WPS AI Slides. Create pro PPTs fast with AI generation, custom templates, and edits. Save hours on slides.