How to Copy the Same Value in Multiple Cells in Excel (4 Methods)

How to Copy the Same Value in Multiple Cells in Excel (4 Methods)

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.

Step-1:

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.

Dataset to Copy the Same Value in Multiple Cells

Step-2:

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 (+).

Following procedure to Copy the Same Value in Multiple Cells

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).

Using Fill handle to Copy the Same Value in Multiple Cells

Step-3:

Release the mouse and the selected cells are now filled with the same cell value.

Getting Result to Copy the Same Value in Multiple Cells

Step-4:

Now do the same for the Joseph Conrad Books and the Haruki Murakami Books.

Result for Copying the Same Value in Multiple Cells

Step-5:

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.

Applying fill handle to Copy the Same Value in Multiple Cells

Release the mouse and you will get the result.

Final result for Copying the Same Value in Multiple Cells

2. Using the Fill Feature to Copy the Same Value

Step-1:

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.

Creating table to Copy the Same Value in Multiple Cells

After clicking the Down option, the selected cells will be filled automatically.

Using Fill to Copy the Same Value in Multiple Cells

Step-2:

Now follow the same procedure for the two other author names. The final outlook of the Author column looks like this,

Getting result for Copying the Same Value in Multiple Cells

Step-3:

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

Applying Fill to Copy the Same Value in Multiple Cells

The cell value is copied to all the cells in the column.

final result Using fill to Copy the Same Value in Multiple Cells

3. Using the Keyboard Shortcuts in Multiple Cells

Step-1:

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.

creating table for keyboard shortcuts

Step-2:

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.

Keyboard shortcuts to Copy the Same Value in Multiple Cells

When the selection is over, write the writer’s name in any cell in the column.

Getting result to Copy the Same Value in Multiple Cells

Hold the CTRL key and press CTRL+ENTER. Our selected cells are now filled with the value.

Result for Copying the Same Value in Multiple Cells

Step-3:

Now do the same procedure for Haruki Murakami’s books.

Keyboard shortcuts to Copy the Same Value in Multiple Cells

So our result for the Author column is,

Getting result for Copying the Same Value in Multiple Cells

Step-4:

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.

Applying keyboard shortcuts to Copy the Same Value in Multiple Cells

And press CTRL+ENTER to get the result.

Final result using keyboard shortcuts to Copy the Same Value in Multiple Cells

4. Using Copy-Pasting Method in Multiple Cells

Step-1:

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.

Creating table for copy pasting to Copy the Same Value in Multiple Cells

Step-2:

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.

Copy-Pasting to Copy the Same Value in Multiple Cells

Step-3:

After the selection is done, press “CTRL+V” to paste the cell values to the selected cells.

Copy-Pasting to Copy the Same Value in Multiple Cells

Step-4:

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.

Getting result for Copying the Same Value in Multiple Cells

Now press “CTRL+V” to paste the cell values into those cells.

final result for Copying the Same Value in Multiple Cells

Step-5:

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”.

Using mouse to Copy the Same Value in Multiple Cells

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”.

Using mouse shortcuts to Copy the Same Value in Multiple Cells

We have got our final result.

Final result using mouse to Copy the Same Value in Multiple Cells

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

Activating auto fill to Copy the Same Value in Multiple Cells

Conclusion

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.

Similar Articles for You to Explore

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo