How to paste multiple cells into one single cell in Excel

In this video we will see a simple technique to copy and paste multiple cells into one single cell in Excel

[alfiedj]

Thank you again Madam. Short and concise. Keep it up 👍

[Dannievomg]

That Double Click explanation in the comments below helped me finally get it! Thank you Thank you!

[mujahidbk]

"Fantastic tutorial! I was struggling with this problem (How to merge cells into vertically), and your explanation was incredibly clear and easy to follow. Thanks to your video, Keep up the excellent work!"

[aarti_chavan]

Copy, clipboard, Double click on cell and paste

[amrhasan]

I liked your video before opening.

Exactly what I wanted. Thank you

[obaidullahamini]

What if it is the opposite situation, like from one to many rows

[eliazebedayo]

My mistake I singly clicked the cell instead of double🙏🙏! It works clear My friends I'm witness of this!! Keep working madame😊!!

[onkarshinde]

How can we automate this for a particular column or row?

[rajatsharma]

Thanks a lot mam u got one more subscriber🙏

[ganeshms]

First I though its not working. The key is to double-click on the cel and later paste it. Thanks for sharing.

[swaroop]

I have to copy and follow the same pattern to another cell here is an example

A+B = 123 I'll copy 123 to another cell

Next B+ C = 456 I'll copy 456 to another cell under 123

Now same C+ D has a value E+F has value. I want to copy only the numerical value to the separate cell instead of manually copying the single element. How do I do that?

[umangpanchal]

How to reverse it? From one cell to multiple cells for data like you entered?

[satheeshbabur]

text ok, in numbers how to combine madam?

[eliazebedayo]

I watched many times with practice but not yet! So curious...!!! Plz alternative!!!?

[alagarMani]

this not working again pasting like multiple cells

[RaviKumar-uyss]

Mam jaisa ki ak line me name h Aakash and wo 2-4 line chodkar fir aa rha h and aise hi chal rha h or bich m sare name b ase mix h to kya hume un sabko aksath kr sakte h? jaise Aakash ki jitni row h wo sari ak sath. plz help