While working in Microsoft Excel, you will need to copy and paste multiple cells to various positions. But sometimes it becomes difficult while working with a large dataset due to blank cells, and multiple non-adjacent cells. But it won’t be a problem anymore. Today in this article, I am sharing how to copy and paste multiple cells in excel. Stay tuned!
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
8 Easy Methods to Copy and Paste Multiple Cells in Excel
In the following, I have shared 8 quick and easy tricks to copy and paste multiple cells in excel.
Suppose we have a dataset of some Employee Names, Employee IDs, and Total Sales. Now we will copy and paste multiple cells from the table.
1. Use Paste Options to Copy and Paste Multiple Cells
In order to copy multiple cells and paste them into a different location on the sheet, you can simply use the paste options. Follow the instructions below-
- First, select some cells (B4:D8) from the list.
- Now, click the right button on the mouse to get options. From the options choose “Copy”.
- Hence, select any cell where you want to paste and again press the right button of the mouse.
- From there choose “Paste” to get the output.
- Finally, we have successfully pasted multiple cells in excel.
2. Utilize Keyboard Shortcut to Copy and Paste Multiple Cells
You can do the same work by applying keyboard shortcuts.
- Simply, select cells (B4:D7) from the table and press Ctrl+C to copy.
- After that, choose a cell (F5) and hit Ctrl+V from the keyboard.
- All the selected output will be in your hands within a blink of an eye.
3. Apply Mouse Shortcut to Copy and Paste Multiple Cells
For working faster you can utilize the mouse shortcut to copy and paste multiple adjacent cells.
- Above all, choose cells (B10:D13) from the dataset.
- Now, holding the Ctrl button move your cursor over the selection border.
- Then, a plus sign (+) will appear. Drag the cells to any location.
- In summary, the selected cells will be copied and pasted to a new location. Simple isn’t it?
4. Copy and Paste Multiple Non-Adjacent Cells in Excel
While copying cells and pasting them to new rows or columns become difficult for non-adjacent cells. Well, I have a simple solution for this. Follow the steps below-
- To start with, hold the Ctrl button and select multiple cells of your choice.
- Next, click the right button of the mouse and press “Copy” from the appearing options.
- Hence, choosing a new location just press Ctrl+V to paste the chosen cells.
- In a moment, your precious selection will be pasted to a new position.
5. Copy and Paste Multiple Cells with Blank
Often we see multiple blank cells inside a dataset creating problems to copy and paste properly. In that situation, you can fill those blank cells and then copy and paste them to fill your target.
- First, select the whole table and hit F5 from the keyboard.
- Then, from the new appeared window click “Special” to continue.
- Hence, checkmark the “Blanks” and hit the OK button to continue.
- After that, just type your desired words to fill in all the blanks. Here I wrote “Nil” to fill the blanks.
- After finishing your writing press “Ctrl+Enter” to fill in all the blanks.
- As we have finished, filling in all the blanks now we can copy and paste without any hesitation.
- In the same fashion, choose cells (B4:D8) and hit Ctrl+C to copy.
- Finish the process by choosing your choice of cell and pressing Ctrl+V to paste.
- In conclusion, we have completed our task of copying and pasting multiple cells in excel worksheet.
6. Utilize Fill Handle Tool to Copy Multiple Cells
The most amazing feature of Microsoft Excel is the “Fill Handle”. Using the fill handle, you can copy and fill series within a short time.
Suppose we have a dataset of 2 Employee Names on the worksheet.
- Presently, choose cells (B5:D6) and move your cursor a the right end of the border.
- Next, the “Fill Handle” icon will appear. Without wasting time, just drag it downwards to fill the below rows.
- Finally, we successfully copied and paste our selected multiple cells into our workbook.
7. Copy and Paste a Single Value into Multiple Cells
Sometimes copying and pasting becomes boring and monotonous to do as we have to go through the same operation again and again. To solve it, I have come up with an amazing trick.
- First, holding the Ctrl button choose multiple cells in a worksheet.
- Hence, write any texts or numeric values using the keyboard.
- For the final touch, press Ctrl+Enter.
- Within seconds your types words will be pasted to multiple selected cells. Simple isn’t it?
8. Use Keyboard Shortcut to Copy and Paste Random Numbers
Just like the previous method, you may be wondering about putting random numbers into multiple cells with the same operation. I will show you this task in this method. Stay tuned!
- Start with holding the Ctrl button and choosing multiple cells from different columns inside the worksheet.
- Now, apply the following formula down to get the random numbers-
- The RANDBETWEEN function returns random integer numeric values between two given numbers.
- Finally, you will get those random numbers for all the chosen cells.
Copy and Paste Multiple Rows in Excel
In the previous methods, we selected cells to copy and paste to multiple locations. This time let’s learn pasting to multiple rows using the same trick from above.
- Select multiple rows by holding the Ctrl button.
- Next, press the right button of the mouse to get multiple choices.
- From there click the “Copy” option to continue.
- Therefore, choose your choice of rows and press Ctrl+V to paste.
- In summary, we have successfully copied and pasted multiple rows in excel.
Things to Remember
- If you are a Mac user then press the Command+C button to copy and Command+V to paste.
In this article, I have tried to cover all methods to copy and paste multiple cells in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.