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 insert pictures in a cell of the table

1. Use WPS Office to open the table. Select the cell where the picture needs to be embedded.2. Click the Insert tab → and then click the inverted triangle button below the Picture button → now select Embed to Cell. 3. Then we can choose the picture we want to insert in the popup window, and click OK.This skill could be also used in Microsoft Office Excel and Openoffice.

How to cancel filter in WPS Spreadsheet

1. First, use WPS Office to open the table. 2. Click the small icon at the lower right corner of the manipulated cell.3. Place the mouse cursor at the Select All label. Then a green Clear Filter button will appear.4. Click the Clear Filter button. Now we have successfully cancelled the filter.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

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

How to change the background in WPS Spreadsheet

· Add Background Picture:1. Use WPS Office to open the table.2. Click the Page Layout tab → and then click the Background button.3. Now we can select the picture we want to insert in this popup window, then click OK.· Delete Background Picture:1. Click the Page Layout tab → and then click the Delete Background button.This skill could be also used in Microsoft Office Excel and Openoffice.

How to use the SUM function

· Option 1:1. Select the cell range with data to sum up. 2. Click Formula → AutoSum You can also use the SUM function for multiple rows at the same time. · Option 2: 1. Choose the cell for sum up result.2. Input =SUM(B2:E2) .3. Press Enter on the keyboard.* If you want to get the rest of the results quickly, place the cursor at the down-right corner of F2 until symbol “+” present. Then, change the selected range with the mouse. To be office excel advanced, you could learn how to use W....