How to Copy and Paste Multiple Cells in Excel

Copy and paste are one of, if not the most used keyboard shortcuts used by people all around the world. It’s simple, easy to learn, and highly efficient. No one wants to write the same text over and over again and copying and pasting help save time and energy. I will show you 5 methods of how to copy and paste multiple cells in Excel. You will learn how to copy series, how to drag the handle to copy and paste as well as a few clever shortcuts.

Copy and paste using just the mouse

The simplest method how to copy and paste multiple cells in Excel, and the one that is most widely used is to just use the mouse to copy and paste. You select the cells you want to copy, right-click in the selected area and click the ‘Copy’ button.

how to copy multiple cells in excel using the mouse

Next, select the cells you want to paste that information in. Right-click in the selected area and press ‘Paste’.

how to paste multiple cells in excel using the mouse

The values have been duplicated and you can do everything you could do with the original cell in the new cell.

Using the fill handle

If you want Excel to copy the same value again and again down a column, you can use the green dot (fill handle) on the bottom right of a cell through as many cells as you want to and fill them with that value. This technique can be handy when you need the same value throughout multiple cells. It makes your life easier and saves time rather than manually copying and pasting it for each cell.

how to copy and paste in excel using the fill handle

To use the drag handle, you need to select the cell (or multiple cells) with the left mouse button and move your mouse to the bottom right corner of the range of cells until your mouse pointer turns into a cross. Draw this cross down and it will fill all the newly selected cells with the first values you selected.

Be careful though, dragging through already filled cells will replace their content.

learning how to copy and paste in excel using the fill handle - showing the result

Dragging the fill handle to fill series

You can use the same function to fill out a list. For example, you can make a list of months by typing January in the first cell and then drag down to fill out the remainder.

copy and paste in excel -dragging the fill handle to fill series

This can work with numbers, dates, months, etc. It can be super useful to save time from manually typing out every single one.

filling in a list of months - using fill handle to copy and paste in excel

Here is the list of months I filled quickly using this option.

Shortcuts for Copying and Pasting Columns and Rows

Two less known shortcuts for copying and pasting either rows or columns quickly are Ctrl+D and Ctrl+R. The first shortcut Ctrl+D is used to automatically fill the values down (D => down), and the second shortcut Ctrl+R fills them to the right (R => right)

Using Ctrl+D to have a value spread down through a whole column

How to copy a column in Excel? When you need to fill down a column with a value, you can use the Ctrl+D keyboard shortcut. It instantly fills the selected cells with the first value selected which can again save you time compared to the old-fashioned copy and paste functions.

how to copy a columns in excel - dragging down the value
how to copy a columns in excel

Using Ctrl+R to have a value spread through the whole row

You can use Ctrl+R the same way as Ctrl+D but instead of filling the column, you fill the selected row of cells with the wanted value. You can combine the two shortcuts to fill rows and columns at the same time.

Using Ctrl+Enter to have a value spread through the whole row

To copy a singular value through all selected cells, regardless of their location, you can use the Ctrl+Enter keyboard shortcut. It will copy and paste the only value in these cells thorugh all of them, regardless which one it is.

Conclusion

Here you have them – all five methods of how to copy and paste multiple values in Excel. Which one do you prefer and why? Do you know a copy and paste method we haven’t mentioned? If so, drop it in the comments down below and let me know what it is.

Similar Posts

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.