The number won’t increase automatically if we hold down the Ctrl key while dragging the AutoFill handle in Excel.

In our case, please select the Cell A2; hold down the Ctrl key which will change the cursor to a double-cross; and then drag the AutoFill handle down to the cells as you need.

And now below cells are filled with the content of the first cell exactly without number incrementing automatically. See below screenshot:

Easily Fill Blank Cells with Values above/below/right/left in Excel

Kutools for Excel’s Fill Blank Cells utility can help Excel users easily fill all blank cells with values above/below/right/left in a specified range. This utility also supports filling blank cells with a fixed text string or number.

You can also apply Excel’s Fill feature to fill below blank cells with the first cell’s content without number incrementing automatically in Excel. Please do as follows:

Select the cell with content and below blank cells, and click Home > Fill > Down. See screenshot:

And now below blank cells are filled with the first cell’s content exactly without number incrementing automatically. See screenshot:

If you have Kutools for Excel installed, you can apply its Fill Blank Cells utility to easily prevent number from incrementing in Excel. Please do as follows:

1. Select the cell with content and below blank cells, and click Kutools > Insert > Fill Blank Cells.

2. In the opening Fill Blank Cells dialog box, please check the Based on values option in the Fill with section, check the Down option in the Options section, and click the Ok button.

And now below blank cells are filled with the first cell’s content exactly without number incrementing automatically. See screenshot:

Note: This Fill Blank Cells utility also supports to fill the cell content to the left blank cells or above blank cells. See below screenshot:

Quickly apply formula to an entire column or row in Excel