How to remove the dotted line in WPS Spreadsheet
There are two reasons that users will see dotted lines in WPS Spreadsheet.· Reason 1: Page breaks1. Open the spreadsheet in WPS Office, then click Menu → Options in the upper left corner.2. Click View and uncheck Page Breaks in the Options popup window.· Reason 2: The dotted line generated after print preview1. Open the spreadsheet in WPS Office.2. Click Page Layout → Print Area. 3. And then select Set Print Area to remove the dotted lines.To be an office excel advancers, you could lea....
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 lock columns and rows in a table
1. Use WPS Office to open the table.2. Click the Review tab → and then click the Lock Cell button.3. Now click the Protect Sheet button, then the Protect Sheet box will pop up. Uncheck Insert Columns and Insert Rows.4. Now we will find it impossible to insert rows and columns in this table.This skill could be also used in Microsoft Office Excel and Openoffice.
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....
Clear and Avoid Duplicates Entries in WPS Spreadsheet
When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some two options to delete duplicates. · Option 1: 1. Select a range of cells. 2. Get into the Data tab → click the Highlight Duplicates dropdown button3. Pick the Set option from the drop-down list. Then, duplicated cells within the selected range will be highlighted.4. Right-click to select the fifth row → choose Delete in the popup menu· Option 2: 1. Se....
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 create a dropdown list in a worksheet
When using WPS Spreadsheets to process a spreadsheet with a large number of data to fill in, creating a dropdown list in the target cells is able to boost our working efficiency, since we can choose one of the options from the dropdown list to fill the target cells rather than typing the contents word by word. An example of cells with a dropdown list is shown below. How can we realize it? An example of cells with a dropdown list inserted · Option 1: 1. Select the cell range to insert d....
How to use the IF function
The IF formula, as one of the most commonly used functions, can determine whether a condition is TRUE or FALSE, so as to get one of the two values. In this article, you will see the explanation of IF function, several examples of IF formula, as well as a case demonstration. · Explanations of IF formula: IF(logical_test, value_if_true, [value_if_false])· logical_test (necessary): the condition to be compared· value_if_true (necessary): the value to be presented as the result when the “....