Usually when I use Excel if I type a number into a cell then select the cell and drag it down to copy, it will drag and copy the numbers, increasing each cell by 1.
www.ozgrid.com