Use data check method to quickly find difference items

Are you still checking table data one by one? Here are two practical methods that can help us find data difference items quickly. Take this table as an example. How can we do it, if we want to quickly find out the data difference items in the rows from Database1 to Database4? First, we select the cell range, then click the Home tab, and click the Find and Replace drop-down button. Select the Go To option under the drop-down menu, or we can also use the shortcut key Ctrl+G to open the d....

How to use the Excel MID function

When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

Wrap text in a cell

When we edit a document, we only need to press the Enter key on the keyboard to wrap text. When we edit spreadsheets, we press the Enter key to edit the cells in the next line, then how can wen wrap text in a cell? This video could help to solve the problem of Wrap text in a cell and could be also used in Microsoft Office Excel and Openoffice. The first method is to use the shortcut key Alt + Enter ; we can wrap text in a cell as we need. The second method is to click the Home tab and ....

How to change the page orientation

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....

Refresh pivotTable and change data source

If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....

How to enter a number starting with 0 in the Spreadsheet

The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

Quickly adjust the row height and column width

Adjusting the row height and column width is a necessary skill for the layout of the table content. So, how can we adjust the row height and column width? The easiest way to adjust the row height and column width is to position the mouse on the dividing line of the row number and column label and drag the dividing line to adjust the row height and column width. We will find that using this method is difficult to completely unify the row height and column width in the table, and the ope....

How to adjust the size and position of pictures accurately

WPS Presentation includes advanced animation, slide transitions, and support for video, images, audio, and even Flash. We usually drag the mouse to adjust the size and position of the inserted picture in the presentation.This is a convenient yet inaccurate method. Today we will learn a method to adjust the size and position of the picture accurately. Right-click the picture to be adjusted, then click Format Object.In the task pane that pops up on the right side of the screen, click SIZ....