Shulou(Shulou.com)11/24 Report--

The original title: "Excel's strongest shortcut keys, colleagues and leaders are stunned!" "

Today, I would like to share with you a super-useful shortcut "Ctrl + E", which can be said to be the strongest shortcut in Excel, which can accomplish a lot of work efficiently. Let's take a look at it.

1. Merge date if you want to merge the contents of the previous cells, we can first enter the results we want to merge into the cell, then position the cursor to the lower cell, and use the shortcut key "Ctrl+E" to generate it in accordance with the style we merged for the first time.

2, segment display number segment display telephone or bank number, it is convenient for us to inquire, how to segment quickly? Use the "Ctrl + E" shortcut key to help you get it done quickly.

3. Are you still using the function to extract the ID card extraction date? How troublesome, direct shortcut key to do it!

4. How to add units to data in batches by adding prefixes or suffixes? I believe that many students are done in function or number format, you might as well try the "Ctrl + E" shortcut key, which can help us finish it more efficiently.

5, order adjustment with regular brackets, it can help you to intelligently identify and fix it.

6. Split data you have data and text, which can be easily split out instead of the sorting function.

7, mixed complex data split OK, sometimes for convenience, the table may be like this, it doesn't matter, "Ctrl + E" in hand, I have the world!

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.