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

Get FREE Advanced Excel Exercises with Solutions!

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.

how to copy same value in multiple cells in excel


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.

Use Fill Handle to Copy Same Value in Multiple Cells

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

Apply Fill Feature to Copy Same Value in Excel

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

how to copy same value in multiple cells in excel result


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.

Copy Same Value in Different Cells Utilizing Keyboard Shortcut

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.

how to copy same value in multiple cells in excel result


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.

Copy Same Value Using Copy Paste Options in Excel

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

how to copy same value in multiple cells in excel result


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.

Use of Context Menu to Copy Same Value in Different Cells

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

how to copy same value in multiple cells in excel result


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.

Things to Remember


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.


Similar Articles for You to Explore

Asikul Himel
Asikul Himel

Hi! I am Asikul Islam Himel. Glad you are here. I am a Team Leader of ExcelDemy, running an excellent team of five efficient Excel & VBA Content Developers. Here at ExcelDemy, we give the best sustainable solutions by posting articles related to MS Excel-related problems. I have completed my under graduation degree from Bangladesh University of Engineering and Technology and my program was Naval Architecture and Marine Engineering. I have found passion in data analysis and research-based fields. I am currently working to grow my leadership quality. I have a great interest in project management and critical thinking. In my free time, I love to travel and read books.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo