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

Adjust row height and column width of tables in word

When making tables in word, we often need to set their accurate row height and column width. In this video, you'll learn how to adjust table row height and column width in word. · Row height:Select the table for settings. Next, get into the Table Tools tab and click Table Properties. Go to the Row tab of the pop-up dialog. Then, we can adjust the row height at Size. After checking the Specify height option, enter ’0.5’ in the input box. In the category of Row height is..., we can c....

How to draw a column chart in WPS Spreadsheet

A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....

Set input conditions and drop-down menus

The Data Validation feature of the WPS Spreadsheet can help us quickly complete the setting of input conditions and drop-down menus, thereby improving the accuracy of our input data.Take this form as an example. Now we need to enter a 9-digit US passport number in column C. We can use Data Validation to improve the accuracy of our input data.1. Select the cell range, then click the Data tab. 2. Click the Validation drop-down button.3. Now select the Validation option in the drop-down m....

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

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

Quickly locate the name of the row and column where the cell is located

We often deal with tables with vast amounts of data at work. When we move the page, we can locate the content we are focusing on, but we cannot quickly know the row and column names of the cells. But now, with the Reading Layout of WPS Spreadsheet, users can quickly locate the row and column names of the cells that they are concerned about. Take this table as an example. Click the View tab, and then the Reading Layout drop-down button. In this mode, once a cell is selected, we can fin....

Using Tab stop to make a slide catalog

When making a slide catalog, we need to typeset the text to make the page look neater. Beginners will use the space bar to align the text one by one, but this is more troublesome. Is there any other way to quickly align the pages? First we need to click the View tab above, and then check Ruler. The ruler above the slide helps us determine the length of the Tab stop. Click the Menu drop-down button, and click Format, finally click Paragraph. In the Paragraph dialog box, click the Tabs b....