Hello there.
I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:
The trick to paste the data in the multiple cells in a single paste.
Tip Quiz
What is the formula to move the unwanted spaces in the cell(s)?
Do you know how to paste data to multiple cells in your Excel worksheet?
Therefore, whether you know or you don't; it does not matter at all. Because I am going to tell you the trick to paste the data into cells as much as you want in an Excel worksheet with an easy way.
Look at and follow the method below:
- Select the data in the cell and copy it.
- Use the mouse to select any cells being pasted.
- Press “Ctrl” and “V” buttons. (The data will be pasted immediately.).
Figure no.1 Show the cell to be copied. |
Figure no.2 Show how to select all the cells to be pasted. |
Figure no. 3 Show all the cells be pasted with the data entered. |
Tip Answer
Link recommendedπ : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'
Link recommendedπ : English Numbers In Words 1 to 1000000
Before I am about to say goodbye to you, I hope that what I have posted and shared with you today. They will be beneficial for you, your company, and any relevant.
If you love it, I will be happy. If you share this with your friends, I will be shiny.
I hope to receive any feedback from you guys. Because they will be such treasures--any error in this blog--for future improvement.
Thanks for reading.
Bye,
Posted by: Michael Leng
I've known, then I've grown.
See more articles:
Comments
Post a Comment