Ctrl+E smart filling

After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

Fill handle: Use Ctrl+D to fill

We sometimes need to deal with tables containing various content. Then we may find it troublesome even to use the fill handle to pull down and fill. Here, we will introduce two convenient methods to you. The first method is to double-click the fill handle. After filling the first data in column A, double-click the fill handle, then the data will be automatically filled in sequence order. Now we can see the data has been filled automatically in the row range of column B. In the digital ....

How to find the specified text content in WPS Presentation

When using WPS Presentation, how can we quickly find the text in the slide? Take this presentation as an example. If we want to find the WPS in this file quickly, we simply click the Home tab and then click Find. Its shortcut key is Ctrl+F. In the pop-up dialog box, enter WPS in the edit box. We can also check the replacement conditions as needed, such as Match case and Find whole words only.Once we set it up, click Find next to quickly find the specified text content in the presentati....

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

How to insert an attachment into WPS Spreadsheet

When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....

Hyperlink in WPS Office Spreadsheet

When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

How to quickly locate and replace data

When processing data in a Spreadsheet, we somtimes quickly need to locate the data among various data, or modify incorrect data in bulk. It would be convenient to use the Find and replace fucntion in WPS Spreadsheet. This video could be used in Microsoft Office Excel and Openoffice. Take the following table as an example, which records students’ grades on various subjects. Supposed that we want to find the E grade from the sheet. 1. Select all those ranges of cells that we want to find....

Formatting time in WPS Spreadsheet

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....