Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Use Ctrl + E In Microsoft Excel?

Date:2021-6-28 Author:Sandra

There are a lot of really useful shortcut keys in Excel. Ctrl + E is the one of the most powerful keyboard shortcuts. This can help us flash fill, split, merge and extract data. Lets’ stop here and see the examples.

Merging Data

We first copy and paste the name “Marry” and number “001” into the cell C2. And select the area, then press Ctrl + E to flash fill these cells.

How To Use Ctrl + E In Microsoft Excel?
How To Use Ctrl + E In Microsoft Excel?

If you need to merge a lot of data, Ctrl + E is absolutely the best choice.

How To Use Ctrl + E In Microsoft Excel?

Data Segment

How To Use Ctrl + E In Microsoft Excel?

We first copy the telephone number in cell B2 and paste into cell C2, then type “-” between the numbers.

How To Use Ctrl + E In Microsoft Excel?

Select the area and press Ctrl and E to fill these cells.

How To Use Ctrl + E In Microsoft Excel?

Extraction Data

If we just want part of a bunch of numbers, we can just copy and paste that part first like below.

How To Use Ctrl + E In Microsoft Excel?

Then highlight the cells and press Ctrl and E to fill them quickly.

How To Use Ctrl + E In Microsoft Excel?

Data Reconstitution

You can recombine the two sets of data or even text in the order you want. For example, I want  to combine name and the part of the number into a new cell, such as “Marry264”.

How To Use Ctrl + E In Microsoft Excel?

Then we select the area and press Ctrl and E to quickly fill.

How To Use Ctrl + E In Microsoft Excel?

That’s all for today, hope this helps. Please feel free to leave your comments and suggestions too. See you next time.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *