It takes the existing command that you currently have on your command line and opens it in your shell’s editor (which is defined by the $EDITOR environment variable). In this post, I’m going to show you an existing feature of your Linux/macOS shell, one that has existed for quite some time. However, in this post, I’m not going to show you something that’s super in-depth, ultra-detailed, or talk about an app that you have to install: ctrl+x+e. What a powerful feature! Easy your work with WPS Spreadsheet like Microsoft Excel.There are lots of tips, tricks, and ideas around for hacking your command-line productivity to make you more efficient. If your data is irregular, Ctrl+E may not achieve the effect you expect. 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. After inputting, we can press the shortcut key Ctrl+E for smart filling.

In this worksheet, we select cell B2 and change the order of the name and team number. Smart filling Ctrl+E can help us reorder the original characters. After inputting, press the shortcut key Ctrl+E to merge the scattered data of each column quickly. We will merge the characters from column A to D into column E. Smart filling Ctrl+E can help us merge data scattered in different columns into the same column. After inputting, we press the shortcut key Ctrl+E for the smart filling to add double quotation marks to all book titles. In this worksheet, select cell C2, and in this cell, we add double quotation marks to the book's title. Using smart filling Ctrl+E, we can add extra characters in batches based on the original characters. After inputting it, we can press the shortcut key Ctrl+E for smart filling. Enter the encrypted mobile phone number format in cell C2. In this worksheet, we want to encrypt the phone number.

Use smart filling Ctrl+E to replace some characters of the original string in batches. In the pop-up drop-down menu, choose the Flash Fill option, the shortcut key is Ctrl+E. First, enter the name that appears in the content of A1 in cell B1, click the Home tab, then click the Fill drop-down button. In this table, we want to extract all the names in the sentences. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters ’ relationship and quickly fill cells. 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.

Change ctrl a to ctrl e