Fill Numbers License For Free

Quickly Fill Numbers in Cells without Dragging 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.

Quickly enter a series of numbers or text-and-number combinations Select the cell that contains the starting number or text-and-number combination. Drag the fill handle. over the cells that you want to fill.Click the Auto Fill Options smart button , and then do one of the following: To.

Click File > Options. Click Advanced. Under Editing Options, check the Enable fill handle and cell drag-and-drop box.

Use autofill to complete a series Highlight the cells. You'll see a small blue box in the lower right corner. Drag the blue box any number of cells down or across. If the cells form a series of dates or numbers, the series will continue across the selected cells.

Turn automatic completion of cell entries on or off 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.

Just fill in your first cell with =COLUMN(A1) , select the cell, then expand the selection to the rest of the cells you want your numbers to be in. Note: if you add or delete rows, you will need to set the auto-numbering again by selecting the first cell and dragging or double-clicking again to restore the pattern.

Put the mouse pointer over the bottom right-hand corner of the cell until it's a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.