I would like to fill data (of cell A1 - for example) into the entire column
below it (cell A2 until the end---in excel 2002 untill cell A65536; in excel
2007 until cell A1048576).

Is there any way I can do this (any way other than dragging the fill handle
downwards for a very very long time)?