Home  >  Article  >  What is the shortcut key for ctrl+e?

What is the shortcut key for ctrl+e?

清浅
清浅Original
2019-03-09 11:00:45234984browse

ctrl e is an important shortcut key in Excel. Text splitting, information extraction, information merging, formatting adjustment and number extraction from text can all be achieved through this shortcut key.

The most magical shortcut key in Excel2013 and Excel2016 is Ctrl E. With this shortcut key, text splitting, information extraction, and data merging are all a breeze, and you no longer need to write anything annoying and complicated. It’s a formula, you only need one click to do it, and your work efficiency will be doubled. It’s really a magical shortcut key that makes people applaud!

What is the shortcut key for ctrl+e?

【Recommended course: javascript tutorial

(1) Extraction of information

Extract name, phone number, city, and age information from the combined information

Operation points: Enter the first name first, Select it and the blank line below, press ctrl E, the name will be filled in 1 second, the same operation is done for the phone number, city and age

What is the shortcut key for ctrl+e?

( 2) Information merging

Combining names and phone numbers

Operation points: Enter the first combined information first, tell Excel how to combine it, and then select the first information and the remaining information. In the cell range below, press the ctrl E shortcut key

What is the shortcut key for ctrl+e?

(3) Adjust the format

Display the phone format in segments

Operation points: First enter the first segmented number, then select this number and the area below, press Ctrl E

What is the shortcut key for ctrl+e?

(4 ) Extract numbers from text

Operation points: Enter the first number first, then select this number and the area below, press Ctrl E

What is the shortcut key for ctrl+e?

Of course, Ctrl E cannot handle all needs 100% perfectly. After all, with more complex data processing, the software may also have deviations when judging our real needs. Therefore, for more complex data, sometimes you may need to fill in 2 or The values ​​of more than 2 cells are provided to CtrL E for judgment. The results should be checked after the data processing.

Summary: The above is the entire content of this article, I hope it will be helpful to everyone.

The above is the detailed content of What is the shortcut key for ctrl+e?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn