After getting in touch with WPS, we know that Ctrl+Ccopy and Ctrl+Vpaste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+Esmart 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 characters
In this table, we want to extract all the names in the sentences. First, enter the name that appears in the content of A1 in cell B1, click the Hometab, then click the Filldrop-down button. In the pop-up drop-down menu, choose the Flash Filloption, the shortcut key is Ctrl+E.
·2. Replacement character
Use smart filling Ctrl+Eto replace some characters of the original string in batches. In this worksheet, we want to encrypt the phone number. Enter the encrypted mobile phone number format in cell C2.After inputting it, we can press the shortcut key Ctrl+Efor smart filling.
·3. Add characters
Using smart filling Ctrl+E, we can add extra characters in batches based on the original characters. In this worksheet, select cell C2, and in this cell, we add double quotation marks to the book's title.After inputting, we press the shortcut key Ctrl+Efor the smart filling to add double quotation marks to all book titles.
·4. Combining characters
Smart filling Ctrl+Ecan help us merge data scattered in different columns into the same column. Take this worksheet as an example. We will merge the characters from column A to D into column E. After inputting, press the shortcut key Ctrl+Eto merge the scattered data of each columnquickly.
·5. Recombinant character
Smart filling Ctrl+Ecan help us reorder the original characters. In this worksheet, we select cell B2 and change the order of the name and team number. After inputting, we can press the shortcut key Ctrl+Efor smart filling.
The above operation needs to be noted that when using Ctrl+E, the arrangement of the original data needs to be as regular as possible. If your data is irregular, Ctrl+Emay not achieve the effect you expect. What a powerful feature! Easy your work with WPS Spreadsheet like Microsoft Excel.Did you get it?
