In Microsoft Excel, you can copy cell values in multiple cells, and paste them easily. You can copy single or multiple cells and then select the target range of cells to paste. You can do this either manually or can use some built-in features available in Excel. Today in this article, we will discuss 4 simple methods to copy the same value in multiple cells in Excel.
Here, we will discuss 4 simple methods to copy same value in multiple cells in Excel. For demonstration, we have used a dataset having Book Name, Author, and In Stock columns which are for a book collection. We will copy and paste data in Author and In Stock columns.
1. Using Fill Handle to Copy Same Value in Multiple Cells in Excel
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. Follow the given steps.
- Let’s copy the Author’s name Agatha Christie from Cell C5 up to C10. first, select Cell C5 and take the mouse cursor to the lower right corner of the cell. The cursor will change to a (+) icon.
- Simultaneously, click on the icon and drag it up to Cell C10.
- As a result, we will see the name copied up to Cell C10.
- Further, we can do the same trick for Author joseph Conrad and Haruki Murakami.
- Again, let’s copy In Stock value from Cell C5 up to Cell C17. For that, select Cell C5 and drag the (+) icon up to Cell C17.
- Finally, we will see all cells in the selected range gets the copied value 20.
2. Applying Fill Feature to Copy Same Value in Excel
Now, we will do the same task using the Fill feature of Excel. Let’s copy the value of Cell C5 up to Cell C10. Follow the steps given below.
- First, select cell range C5:C10.
- Afterward, go to the Home tab and select Fill > Down. we are selecting Down as we are copying the values to cells below.
- Consecutively, we will see the name Agatha Christie is copied up to C10.
- In a similar fashion, we can copy the other Author’s name to the cells below.
- Afterward, let’s copy In Stock value from Cell D5 up to D17.
- For that, select cell range C5:C17.
- Further, go to the Home tab and select Fill > Down.
- Finally, we will see the value of Cell D5 copied up to Cell D17.
3. Copying Same Value in Different Cells Using Keyboard Shortcut
In this section, we will use some keyboard shortcuts to copy the same value to multiple cells. This time, our blank cells are a bit discrete.
Let’s walk through the procedures.
- First, select cells where we want to copy the same value. You can select multiple cells by pressing and holding Ctrl then select multiple cells.
- Afterward, write the desired name (in our case Joseph Conrad).
- Later on, press Ctrl + Enter. And we will see all the selected cells having same value Joseph Conrad.
- After that, we can copy the Author’s Name Haruki Murakami in the same way.
- Now, It’s time to copy the empty cells of In Stock column with 15.
- For that, select the cells by holding Ctrl first.
- Then, write 15 and press Ctrl + Enter.
- Finally, we will see 15 is copied to all the empty cells.
4. Copying Same Value Through Copy Paste Options in Excel
We can also use the Copy and Paste options of Excel to copy the same value in multiple cells. In this section, we will discuss the procedure.
4.1 Using Keyboard Shortcut
First, let’s see the keyboard shortcut technique to copy and paste the values. The steps are given below.
- First, select a cell and press Ctrl + C to copy its value. In our case, we selected Cell C14.
- Now, holding the Ctrl key select the empty cells where we want to copy the value.
- Afterward, press Ctrl + V and we will see the value Agatha Christie copied to all the selected cells.
- In a similar way, we can copy the numerical value of a cell to multiple cells. Here, we copied value of Cell D5 up to Cell D17.
4.2 Using Context Menu
Copy and Paste options are also available in the context menu. Let’s use that following the procedures below.
- First, select and right-click on the cell to copy its value. We selected Cell D5 (value 20).
- Then, from the context menu select Copy.
- Afterward, select the range of cells where the copied value should be pasted.
- Further, right-click and choose the option Paste.
- Finally, we will see the same value 20 copied to cell range D6:D17.
Things to Remember
For using the Fill Handle, we need to enable it first if not enabled earlier.
- First, go to the File tab and select Options.
- Then, In the Excel Options window, select Advanced and put a tick on Enable Fill Handle and cell drag-and-drop, Alert before overwriting cells.
- Finally, we will be able to use the Fill Handle.
Download Practice Workbook
You can download the practice workbook from here.
Conclusion
Copy the same value to multiple cells comes tremendously helpful. Here, we have shown 4 simple methods to copy the same value in multiple cells in Excel. Hopefully, it will be helpful to you. Furthermore, I have added the practice workbook at the beginning of the article. So, you can practice it if you want. If you have any queries or suggestions, let us know in the comment section.