How to insert a check box in WPS Spreadsheet

After we use WPS Office to open the spreadsheet, click the Insert tab, then click the Check Box button. Now place the mouse where we want to add a check box and click.This skill could be also used in Microsoft Office Excel and Openoffice.

How to split columns in a sheet

1. Select the target range in WPS Spreadsheet. 2. Click Data → Text to Columns3. Choose Delimited in the interface of Convert Text to Columns Wizard - Step 1 of 3”4. In the interface of “Convert Text to Columns Wizard - Step 2 of 3”, select the delimiters in terms of your demands. 5. Click Finish in the interface of “Convert Text to Columns Wizard - Step 2 of 3”. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to unmerge cells in WPS Spreadsheet

1. Use WPS Office to open the table, select the merged cells, and click the Home tab. 2. Then click the drop-down button of Merge and Center.3. We can see two ways to split cells in WPS Spreadsheets: Unmerge Cells and Unmerge and Fill.We can choose one of them according to our needs.This skill could be also used in Microsoft Office Excel and Openoffice.

How to import external data in WPS Spreadsheet

1. Use WPS Office to open the spreadsheet, and click the drop-down button of Menu in the upper left corner.2. Choose Data → Import External Data → Import Data, and click OK in the popup window.3. In the Step 1: Select data source interface, click Open data file directly, and Select Data Source..., then we can choose the file as needed. 4. In the File Conversion interface, we can select the encoding that makes our document readable. There are two options of Text encoding, one is Windows....

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

How to enter text vertically in cells

In most situations, when entering text context into a cell WPS Spreadsheet, the characters are arranged from left to right. How can we type vertically in WPS Spreadsheet?1. Right-click the cell → choose Format Cells in the dropdown list 2. Get into the Alignment tab in the Format Cells dialog, and check the Vertical text box. Then, the characters would present vertically.WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot ta....

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

How to use the data validation feature

We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Since this feature is quite complicated, we only briefly introduce some basic usages here. If you want to learn more, you may feel free to watch more related videos in our WPS Academy.First, select the cell range where we want to fill data, and click the Data tab → the Validation button in the upper menu bar. At this time, the data validation box will pop up. We can s....