Fill Number Record For Free

Fill a column with a series of numbers Select the first cell in the range that you want to fill. Type the starting value for the series. Type a value in the next cell to establish a pattern.Select the cells that contain the starting values.Drag the fill handle.

Click File > Options. Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.

Use the ROW function to number rows In the first cell of the range that you want to number, type =ROW(A1). The ROW function returns the number of the row that you reference. For example, =ROW(A1) returns the number 1. Drag the fill handle. across the range that you want to fill.

To select a larger range, it's easier to click the first cell and hold down the Shift key while you click the last cell in the range. You can scroll to make the last cell visible. To select an entire column or row, click the column or row header.

To do this, simply enter all your data except the record numbers. Then type in the first two or three record numbers, select them, and drag on the AutoFill handle (the black square at the bottom-right corner of the selection) to fill out the rest of the records.

Hold down Shift , then press End and then ? . Then (while still holding Shift ) press End again and then ? . This should select everything in a very small number of key strokes. However if there are gaps in your data you may have to press End then ? until you have everything.

Here are the steps: Enter 1 in cell A1. Go to Home ?> Editing ?> Fill ?> Series. In the Series dialogue box, make the following selections: Series in: Columns. Type: Linear. Step Value: 1. Stop Value: 1000. Click OK.