Populate cells with numbers

[cj720m]

Hi, I want to populate cells to have Flat No.s obviously if the flats are No.s 1-100, I can just type 1 in the first cell and then drag to self populate the remaining 99 cells, however, what if the flats go up in odd numbers i.e. 1,3,5,7,9 and so on. Can this be done. also do they have to start at No 1. Thanks in advance

 

[Norie]

Put 1 in A1, 3 in A2 select both and drag down.

 

[hnsd24_CN]

=ROW(A1)*2-1

 

[Fluff]

You can also use fill series on the home tab.