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.



 

 

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



 

 

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

 

 

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.



 

 

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



 

 

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

 

 

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.



 

 

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

 

 

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.