[Nailimixam]

完全唔識。。。。

[pigpig2000]

cell A1 = 1
cell A2 "=A1+1", highlight from A2 to A1000, press Ctrl D

or
Cell A1 = 1
Cell A2 = 2
Highlight both cells and drag down to cell A1000

There could be other special function to handle this task which i dont know ^_^

[pongyee]

好似豬豬咁講，click 住右下角，一直拉落去。

[Nailimixam]

>>>好似豬豬咁講，click 住右下角，一直拉落去。

this one works :D