When I have a large number of cells in a column  like this, I usually use a
temporary formula:

put 1 in the first cell (call it E10)
put =E10+1 in E11
copy/paste E11 down to all the cells that need the values
select all the cells
copy, then paste special/values to the same place