Click on the cell in row 2 that you've done. In the bottom right-hand corner
there is a black square. Click on it and drag it down to autofill.

--
Andy.


wrote in message
ups.com...
thanks, that works for one row, row 2.... but how do I fill down for
all the other rows, i'm stupid. thanks