Pages

Using Fill in Excel


The Fill command enables you to copy the same text or formula inas many cells as you want with just a few simple steps. 

For example, copy the number 10 in column A of the first 100 rows of aspreadsheet:

1) Begin by entering 10 in the cell at row 1, column A. 

2) Put your mouse pointer over the cell, hold down the left mouse button anddrag it down the column to row 100. Release the button and all 100 cells incolumn A are selected. 

3) Click Edit on the menu bar and select Fill from the drop-down menu. 

4) Select Down from the list that appears and 10 is copied into each selectedrow of column A. 

Note: Thisworks across columns too, except that you would select a row in step 2 andchoose the Right instead of Down from the list in step four.