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

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

WPS Spreadsheet basic editing

This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....

How to add gridlines and guides in WPS Presentation

When we make a slideshow, in order to achieve a good typographic effect, we generally add guides and gridlines to the page. Take this slide as an example. It is difficult for us to center the title without smart assisted alignment. At this point, we only need to click the View tab above, then click the Grid and Guides button, finally check Display smart guides on screen. With the help of smart guides, centering the title becomes simple. Learn to use guides, and we can achieve more type....

How to set the header row across pages

When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

Quickly fill cells with multiple methods

As for beginners, they usually enter data manually when they first use Spreadsheet. It is time-consuming and also easy to cause mistakes. So today we are going to learn a few tips to help you quickly fill in the data in the worksheet.· Fill contents down into the tableTake this table as an example, select the area that needs to be filled, first click the Home tab, then click the Fill button-and then select Fill down. (Notes: The shortcut key is Ctrl+D.) · Fill contents right into the t....

Look up data quickly with LOOKUP function

Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....

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