Discover 4 amazing functions of Ctrl E shortcut in Excel that you might not know

Ctrl E is a shortcut key that quickly merges, separates, and combines data in Excel, making working with data much simpler. Specifically, what are the functions of Ctrl + E in Excel? Let's find out in the article below!

0
156

Microsoft Excel software has a lot of built-in shortcuts to help users work with data more conveniently. Among them, Ctrl E is a familiar shortcut that makes merging, splitting data, and more easier. In this article, FPT Shop will guide you in detail on how to use this shortcut, so let’s follow along!

What does Ctrl E do in Excel?

The shortcut Ctrl E is used in many different applications and software. Depending on the definition and usage in each application, it has its own purpose. In the Excel software, you can use this shortcut in the following 4 ways:

Using Ctrl E to merge data in Excel

When you want to merge data from 2 or 3 different columns in a spreadsheet into a single complete data in one column, you can use the Ctrl E shortcut to do it quickly. For example, you have a spreadsheet with information columns including: Name, Class, Symbol as shown in the figure:

To merge these 3 information fields, you can follow these steps:

Step 1: In cell E2, enter a sample information that includes the information fields you want to merge, such as Name<> or Name<->Class<->Symbol.

Step 2: Then, select the data range including the sample cell (E2) and press Ctrl + E to get the desired consolidated data.

Using Ctrl E to split data in Excel

Not only does the Ctrl E shortcut merge data, but it also helps you split data. Instead of having data connected together like in the E2 information column obtained in the above example, you can use Ctrl + E to separate data with a hyphen symbol, which makes searching and splitting data easier.

Step 1: In cell F2, enter the sample information for separation as desired.

Step 2: Next, select the data range including the sample cell F2 and press the shortcut Ctrl + E to see clearly separated data.

Splitting data in Excel using Ctrl E shortcut

In addition to using the Mid, Right, Left functions, you can also split data in Excel using the Ctrl + E shortcut. For example, if you want to extract a number or a specific content from a data table, you can use Ctrl E according to the following instructions:

Step 1: In cell F2, enter the sample number or characters you want to extract from the character string.

Step 2: Then, select the range that includes cell F2 and the cells below and press the shortcut key Ctrl + E, the system will automatically split the data for you.

Combining data in Excel with Ctrl E

In addition to the applications above, the Ctrl + E shortcut can help you separate data from one column and merge data from another column.

Step 1: In cell F2, enter the pattern of data you want to combine. For example, combining data in the Name column with the first character of the Symbol column.

Step 2: Then, select the range that includes cell F2 and the cells below and press the shortcut key Ctrl + E to get the result as shown in the figure.

Notes when using the Ctrl E shortcut in Excel

During the process of using the Ctrl + E shortcut in Excel, you need to pay attention to the following points:

  • All cells in the spreadsheet must have a common rule in order to get the correct result.
  • All cells used to retrieve data must have complete content.
  • The selected range to apply the Ctrl E shortcut in Excel must include the sample cell as the basis.

Conclusion

So through this article, FPT Shop has shared with you the functions of the Ctrl E shortcut in Excel. Hopefully, with this shortcut, you can split, merge, and divide data in Excel in the simplest and fastest way.

You may also like

5 Essential Excel Functions for Beginners

Master the fundamentals of Excel with these 5 basic functions! Learn how to use SUM, AVERAGE, COUNT, MIN, and MAX in order to make calculating and analyzing data easier and more efficient.

A Simple Method for Adding Watermark to Excel for All Spreadsheets in No Time

Watermarking in Excel is a great way to mark your ownership and protect the content on your Excel spreadsheets. If you’re unsure how to do it, you can follow the steps outlined in this article.

How to recover unsaved or overwritten Excel files effectively: a sure-fire method

Knowing how to recover unsaved Excel files can be extremely helpful in cases when your computer unexpectedly shuts down or you accidentally click on “Don’t save” when Excel asks if you want to save your changes before closing. Follow this article to learn the step-by-step process of how to accomplish it.

5+ Effective Ways to Convert PDF to Excel Quickly, Useful Office Tricks

Knowing the ways to convert PDF files to Excel below will enable you to easily edit and add content inside. Office workers and students definitely must know this trick if they want to simplify their tasks.