How to use the filter feature in WPS Spreadsheet

1. After we open the spreadsheet in WPS Office, click the Home tab, and click the AutoFilter button in the upper menu bar.2. Now click the drop-down button to filter according to our needs.3. After we click OK, we can view the filter results below.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to insert a check mark in word

· Option 1:1. Open the Word document, and place the cursor where you want to insert a check mark.2. Click the Insert tab → the Symbol drop-dwon button → More Symbols. Then the Symbol dialog will pop up.3. We do not make changes to the Font. In the Subset box, select Mathematical Operators. Scroll up or down to find the check mark we want.4. Click the check mark, and click the Insert button to insert it where we want it to be. 5. Click the Close button to view the check mark. · Option 2....

How to crop a picture in irregular shapes

1. Click the picture for operation.2. Click Picture Tool from the toolbar → Crop dropdown button3. Choose a shape from the “Crop by Shape” menu4. Adjust the range to crop on the picture You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.

How to merge multiple documents in WPS Writer

1. First open a document and click the Insert tab → then click the inverted triangle drop-down button of Object → select Insert Text from File.2. Select the documents we want to merge in this Insert File pop-up window.3. Click the OK button.To be office word advancers, you could learn how to use WPS Office Writer online in WPS Academy.

How to cancel the file password

1. Use WPS Office to open the encrypted file.2. Input the password in the pop-up box to enter the file.3. Click Menu in the top left corner → Options → Security.4. In the Password protect box, delete all the passwords that have been set. 5. Click OK button. To be office word advanced, you could learn how to use WPS Office Writer online in WPS Academy.

How to change date format in a cell

We can present dates in different formats in the Format Cells settings. Follow these few steps.1. Select the cell range filled with date information for format changes.2. Right-click the cell range → choose Format Cells from the pop-up menu.3. Get into the Date tab → choose a date format in the category of Type.4. Click OK to complete the settings. · More details about the interface for date formats[Range A] SampleHave a review of the date here.[Range B] TypeA list of options for date....

How to download files in WPS Cloud

1. Open WPS Office.2. Click Open → My Cloud Files.3. Place the cursor on the file we want to download, right-click and select Export in the shortcut menu, then we can download files in WPS Cloud. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.

Adjust transparency of picture background in a slide

In the first slide, a picture has been set as the background of the first slide. Follow the steps to adjust the transparency of the picture background. 1. Click the Design tab → the Background drop-down button → Background…2. Drag the scroll bar with the mouse to adjust the background transparency. You can also input the exact number of percentages in this step. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.Thousands of fr....