Fill a Selection of Cells With the Same Value in Excel 2010


It is very common when working with spreadsheets in Microsoft Excel to have one value that repeats among a high number of cells. Whether it is a price that is common to a high number of products, or simply putting the number “0” into a lot of cells that do not have a value, you may find yourself typing the same value repeatedly.

This can often be avoided, however, by taking advantage of one of several methods for quickly filling multiple cells with the same value. So check out our guide below to learn about a few ways that you can type a value once, then have excel automatically fill a group of cells with that same value.

 

Insert the Same Value Into Multiple Cells in Excel 2010

This article will assume that you want to enter the same value into multiple cells, and that you want to do it as quickly as possible. The methods described below will have you enter that value into a cell one time, then you can use one of several options in order to put that same value into a group of other cells.

 

Method 1 (Fill a Row or Column with the Same Value)

  • Step 1: Open your Excel worksheet, then type the value into one of the cells.
  • enter the value

     

     

  • Step 2: Position your mouse cursor on the bottom-right corner of the cell so that the cursor becomes a + symbol, as in the image below.
  • position your mouse at the bottom-right corner

     

     

  • Step 3: Click and drag your mouse up or down to fill multiple cells in a column with that value, or click and drag right or left to fill multiple cells in a row with that value. Release your mouse button when the correct cells are selected.

drag to fill a column or row

 

 

Method 2 (Fill Any Group of Selected Cells with the Same Value – Keyboard Shortcut)

 

  • Step 1: Select the group of cells into which you wish to insert a value.
  • select the group of cells to fill

     

     

  • tep 2: Type a value into the first cell, but do not press Enter on your keyboard or exit that cell yet.
  • type the value

     

     

  • Step 3: Press Ctrl + Enter on your keyboard to fill the rest of the selection with that value.

press Ctrl + Enter

 

 

Method 3 (Copy and Paste)

 

  • Step 1: Type your value into a cell, then right-click the cell and select the Copy option. Alternatively, you can press Ctrl + C on your keyboard to copy the cell value.
  • right-click the cell, then click copy

     

     

  • Step 2: Select the group of cells into which you want to paste the copied value, then right-click inside the selection, then click the Paste button under Paste Options. Alternatively, you could press Ctrl + V on your keyboard to paste the cell value after selecting the group of cells.

select the group of cells, then click paste

 

 

Do you need to print some data from Excel, but you only want to print some of the data in a worksheet? Click here and learn how to print a selection in Excel 2010.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.