How to Add the Same Value to Multiple Cells in Excel

Easy methods to repeat a value in Excel on PC or mobile

This wikiHow teaches how to copy one value to an entire range of cells in Microsoft Excel. If the cells you want to copy to are in a single row or column, you can use Excel's Fill feature to fill the row or column with the same value. If you want the value to appear in a wider range of cells, such as multiple contiguous or non-connected (desktop-only) rows and columns, you can easily paste the value into a selected range.

Method 1
Method 1 of 4:

Copying and Pasting to One or More Ranges (Desktop)

  1. Image titled Add the Same Value to Multiple Cells in Excel Step 1
    1
    Type the value into an empty cell. For example, if you want the word "wikiHow" to appear in multiple cells, type wikiHow into any empty cell now. Use this method if you want the same value to appear in an entire range.
  2. Image titled Add the Same Value to Multiple Cells in Excel Step 2
    2
    Right-click the cell containing the value and select Copy. This copies the value to your clipboard.
    Advertisement
  3. Image titled Add the Same Value to Multiple Cells in Excel Step 3
    3
    Select the range of cells in which you want to paste the value. To do this, click and drag the mouse over every cell where the value should appear. This highlights the range.
    • The range you select doesn't have to be continuous. If you want to select cells and/or ranges that aren't connected, hold down the Control key (PC) or Command key (Mac) as you highlight each range.
  4. Image titled Add the Same Value to Multiple Cells in Excel Step 4
    4
    Right-click the highlighted range and click Paste. Every cell in the selected range now contains the same value.
    5. Advertisement
Method 2
Method 2 of 4:

Copying and Pasting to One or More Ranges (Mobile)

  1. Image titled Add the Same Value to Multiple Cells in Excel Step 5
    1
    Type the value into an empty cell. For example, if you want the word "wikiHow" to appear in multiple cells, type wikiHow into an empty cell above (if applying to a column) or beside (if applying to a row) the cells you want to fill.
  2. Image titled Add the Same Value to Multiple Cells in Excel Step 6
    2
    Tap the cell once to select it. This highlights the cell.
  3. Image titled Add the Same Value to Multiple Cells in Excel Step 7
    3
    Tap the highlighted cell once more. This opens the Edit menu.
  4. Image titled Add the Same Value to Multiple Cells in Excel Step 8
    4
    Tap Copy on the menu. Now that the value is copied to your clipboard, you'll be able to paste it into a series of other cells.
  5. Image titled Add the Same Value to Multiple Cells in Excel Step 9
    5
    Select the range of cells in which you want the selected value to appear. To do so, tap the first cell where you want the copied value to appear, and then drag the dot at its bottom-right corner to select the entire range.
    • There is no way to select multiple non-touching ranges at once. If you need to copy the value into another non-adjacent range, repeat this step and the next step for the next range after pasting into this one.
  6. Image titled Add the Same Value to Multiple Cells in Excel Step 10
    6
    Tap the selected range and tap Paste. This copies the selected value into every cell in the range.
    7. Advertisement
Method 3
Method 3 of 4:

Filling a Continuous Column or Row (Desktop)

  1. Image titled Add the Same Value to Multiple Cells in Excel Step 11
    1
    Type the value into an empty cell. For example, if you want the word "wikiHow" to appear in multiple cells, type wikiHow into an empty cell above (if applying to a column) or beside (if applying to a row) the cells you want to fill.
  2. Image titled Add the Same Value to Multiple Cells in Excel Step 12
    2
    Hover the mouse cursor over the bottom-right corner of the cell. The cursor will turn to crosshairs (+).
  3. Image titled Add the Same Value to Multiple Cells in Excel Step 13
    3
    Click and drag down the column or across the row to fill all cells. As long as Excel does not detect a pattern, all selected cells will be filled with the same value.
    • If the filled cells show up as a pattern, such as a series of increasing numbers, click the icon with a plus sign at the bottom of the selected cells, then select Copy cells.
    4. Advertisement
Method 4
Method 4 of 4:

Filling a Continuous Column or Row (Mobile)

  1. Image titled Add the Same Value to Multiple Cells in Excel Step 14
    1
    Type the value into an empty cell. For example, if you want the word "wikiHow" to appear in multiple cells, type wikiHow into an empty cell above (if applying to a column) or beside (if applying to a row) the cells you want to fill.
  2. Image titled Add the Same Value to Multiple Cells in Excel Step 15
    2
    Tap the cell once to select it. This highlights the cell.[1]
  3. Image titled Add the Same Value to Multiple Cells in Excel Step 16
    3
    Tap the highlighted cell once more. This opens the Edit menu.
  4. Image titled Add the Same Value to Multiple Cells in Excel Step 17
    4
    Tap Fill on the menu. You will then see some arrow icons.
  5. Image titled Add the Same Value to Multiple Cells in Excel Step 18
    5
    Tap and drag the Fill arrow across the cells you want to fill. If you want to fill a row, tap the arrow pointing to the right and drag it until you're finished filling all of the cells. If you're filling a column, tap the arrow pointing downward, and then drag it down to fill the desired amount of cells.
    6. Advertisement

You Might Also Like

Google Sheets How to Insert Time in Cell Automatically4 Easy Ways to Add the Time and Date Automatically in Sheets
How Do You Write an if then Formula in ExcelHow to Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
Use Google SpreadsheetsHow to Use Google Sheets: The Ultimate Guide for Getting Started
Add a Custom Field in Pivot TableHow to Add Custom Calculated Fields to Pivot Tables in Excel
Add Two Cells Containing the Sum of Other Formulas in Excel
How to
Add Two Cells Containing the Sum of Other Formulas in Excel
Create a Form in a Spreadsheet
How to
Create a Form in a Spreadsheet
Show the Max Value in an Excel Graph
How to
Show the Max Value in an Excel Graph
Add Rows to a Pivot Table
How to
Add Rows to a Pivot Table
Change X Axis Scale in ExcelHow to Change the X Axis Scale in an Excel Chart
Create a Formula to Increase a Date by 1 Month
How to
Create a Formula to Increase a Date by 1 Month
Change an Excel Sheet from Read Only
How to
Change an Excel Sheet from Read Only
Make a Shared Spreadsheet
How to
Make a Shared Spreadsheet
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Make a Google SpreadsheetHow to Make a Google Spreadsheet: Beginners Guide
Advertisement

References

  1. ↑ https://support.microsoft.com/en-us/office/fill-data-in-a-column-or-row-96d97653-95d7-4980-9db1-d84bf4ceb0c5

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 36,465 times.
How helpful is this?
Co-authors: 4
Updated: August 26, 2022
Views: 36,465
Categories: Spreadsheets
Article SummaryX

1. Enter the value into a blank cell.
2. Right-click the cell and click Copy.
3. Highlight the cells you want to paste into.
4. Right-click the highlighted area and select Paste.

Did this summary help you?
Advertisement