There are a lot of really useful. Ctrl + E is the one of the most powerful keyboard . This can help us flash fill, split, merge and extract data. Lets’ stop here and see the examples.
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.
If you need to merge a lot of data, Ctrl + E is absolutely the best choice.
We first copy the telephone number in cell B2 and paste into cell C2, then type “-” between the numbers.
Select the area and press Ctrl and E to fill these cells.
If we just want part of a bunch of numbers, we can just copy and paste that part first like below.
Then highlight the cells and press Ctrl and E to fill them quickly.
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”.
Then we select the area and press Ctrl and E to quickly fill.
That’s all for today, hope this helps. Please feel free to leave your comments and suggestions too. See you next time.