Fill Data in Excel 2002 and 2007

  • Thread starter Thread starter Display Name
  • Start date Start date
D

Display Name

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
 
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.
 
Back
Top