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 until 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)?

if you don't want to play around with edit | fill (which I have done and
which I don't like at all), here is an easy way.

autofill works with a double click as long as you have a column of data
immediately to the left (or right i think) of where you are trying to do the
autofill.

so what you can do is:

1) insert a new column A
2) write "xxx" or "chicken" or whatever in A1
3) copy A1
4) select A2
5) hold down ctrl and shift and the down arrow key. it should select up to
65536 (xl 2003)
6) paste. now you have "chicken" in all the cells in column A
7) your A1 has become cell B1 because we inserted a new column. Now you can
just double click the autofill handle on A1 and it should fill all the way
down
8) now you can delete the column A we created

--
Allllen


"Display Name" wrote:

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 until 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)?

An even easier way of filling all cells in column A with "xxx" is:
Select column A (by clicking its column header "A").
Type "xxx" (without the quotes).
Hold down CTRL whilst pressing ENTER.

"Allllen" wrote in message
...
if you don't want to play around with edit | fill (which I have done and
which I don't like at all), here is an easy way.

autofill works with a double click as long as you have a column of data
immediately to the left (or right i think) of where you are trying to do
the
autofill.

so what you can do is:

1) insert a new column A
2) write "xxx" or "chicken" or whatever in A1
3) copy A1
4) select A2
5) hold down ctrl and shift and the down arrow key. it should select up
to
65536 (xl 2003)
6) paste. now you have "chicken" in all the cells in column A
7) your A1 has become cell B1 because we inserted a new column. Now you
can
just double click the autofill handle on A1 and it should fill all the way
down
8) now you can delete the column A we created

--
Allllen


"Display Name" wrote:

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 until 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)?