Fill Adjacent Cells
Filling is a method used to enter data into rows and columns of a spreadsheet. You can either copy the contents of one cell into adjacent cells, or fill adjacent cells with a series of data.
Copying Cell Content
Filling in a Series
Select the first cell, and then drag to the last cell you want filled.
Right-click (Control-click for Macintosh) on your selection, select Fill, and then select one of Down, Right, Up, or Left. For example, if you select Left, the value in the rightmost selected cell is used to fill all selected cells through to the leftmost selected cell.
Use the Stop At value to specify the integer at which the fill stops. Once an entry has reached the stop value, no additional cells in the column or row are filled.
Right-click (Control-click for Macintosh) on your selection, select Fill, and then select Detailed. The Fill dialog opens.
Select the direction to be used for filling. For example, if you select Left, the value in the rightmost selected cell is used to fill all selected cells through to the leftmost selected cell.
(Optional) Enter a Step Size. The Step Size is the amount by which you want to increase or decrease the cell values in the series.
(Optional) Enter a Stop At value. The Stop At value is the value at which the fill stops. Once an entry has reached the stop value, no additional cells in the column or row are filled, even if more cells were selected.
Click OK.
See Also
Change Cell Content
Enter Data in Cells
Evaluate Selection
Evaluate Spreadsheet
Reference Cells
Download Help Document
