Copying cell values in multiple cells and pasting them is one of the easiest jobs in Microsoft Excel. You can copy single or multiple cells and then select the target range of cells to paste. You can do this either manually or you can use some built-in features available in Excel. Today in this article, we will discuss some of the methods to copy the same value in multiple cells in Excel.
Download Practice Workbook
Download this practice sheet to practice while you are reading this article.
Copy the Same Value in Multiple Cells in Excel (4 Methods)
1. Using the FILL HANDLE to Copy the Same Value
One of the most common ways to copy the same value in Excel is to use the FILL HANDLE feature.
Consider an example where we have a dataset containing the names of some books in the column “Book Name”, authors of these books are in the “Author” column and their available stock is given in the “In Stock” column. Some cells in the Author column and Stock columns are blank. We need to fill those blank cells using the Fill Handle feature.
Books from B4 to B9 are written by Agatha Christie. So we will copy cell C4 and put the value of C4 from C5 to C9. To do this, select cell C4. Hover your mouse cursor to the bottom right corner of the cell until you see the Fill handle Icon (+).
When you get the Fill Handle Icon, click the icon and drag it down to highlight all of the cells you want to fill (C9).
Release the mouse and the selected cells are now filled with the same cell value.
Now do the same for the Joseph Conrad Books and the Haruki Murakami Books.
For the In the Stock column, let’s say for each book, we have the same number of books in stock (20). Input 20 in the first cell of the In-Stock column. Now we will copy the value to all the cells. To do it, click on the valued cell, get the Fill Handle icon and drag down to the last cell of the column.
Release the mouse and you will get the result.
2. Using the Fill Feature to Copy the Same Value
We will use the same dataset for this example. Now we want to copy the value in cell C4 to C9 using the Fill feature. To do it, go to Home, in the Editing Ribbon, select Fill, and click on Down as we want to fill our cell in the downward direction.
After clicking the Down option, the selected cells will be filled automatically.
Now follow the same procedure for the two other author names. The final outlook of the Author column looks like this,
Now we will fill the other column. Our first value is given and we will copy this value for all the cells in the column. Select the entire column and select Fill and then click on Down
The cell value is copied to all the cells in the column.
- How to Copy and Paste Multiple Cells in Excel (7 Quick Ways)
- Paste Options in Excel: A Complete Guideline
- How to Copy and Paste in Excel Without Changing the Format
3. Using the Keyboard Shortcuts in Multiple Cells
Now consider a new situation where we have to copy cell values from some scattered cells. To do this we can use some keyboard shortcuts. Let’s see the data table first. Here the name of the books is not inserted serially with respect to their authors.
First, we want to fill the cells for Joseph Conrad’s books. Select the cells beside his books. Press CTRL and left-click on the mouse to select all the cells at a time.
When the selection is over, write the writer’s name in any cell in the column.
Hold the CTRL key and press CTRL+ENTER. Our selected cells are now filled with the value.
Now do the same procedure for Haruki Murakami’s books.
So our result for the Author column is,
Now for the In-Stock column, let’s say for Joseph Conrad and Haruki Murakami’s books, we have 15 of them each. To fill this value in the rest of the cells, follow the same steps.
And press CTRL+ENTER to get the result.
4. Using Copy-Pasting Method in Multiple Cells
Now in the given situation, we have to fill the cells for Agatha Christie’s books. We can use the Copy-Paste method to complete this task.
Copy cell C13 by pressing “CTRL+C” where the name of the author is given. Now press CTRL and Left-Click on the mouse to select those blank cells.
After the selection is done, press “CTRL+V” to paste the cell values to the selected cells.
For the other column, input the value in the first column. Now copy this cell by pressing “CTRL+C”. Select the rest of the cells by clicking and dragging the mouse cursor.
Now press “CTRL+V” to paste the cell values into those cells.
You can also use the mouse to Copy-Paste. To do that select the valued cell. Right-Click on the mouse to open options. From the options, select “Copy”.
Now select all the cells where you want to paste this value. Again right-click on the mouse and from the appeared options, select “Paste”.
We have got our final result.
Things to Remember
⏩ There may be a situation when you need to activate the FILL HANDLE feature. To do this, Go to “Files” and then select “Options”. A new window appears. Click on Advanced and in the Editing Options, Check on “Enable Fill Handle and Cell Drag-and-Drop”. Click Ok to apply
Today we discussed four methods to copy the same value in multiple cells in Excel. If you have any kind of confusion or thoughts, we will be happy to see your comment in the comment section.