Well mixed results, worked both ways with one value but it is a series I want
to fill down. For instance Joe, Harry, Carol, Bill all the way to the end.
When I followed these I got "Joe" to the end of the column. Thanks though,
I'm getting there!

"Mary jane" wrote:

Hello,

If one needs to auto fill a series to the end of a large worksheet (1200
rows) how can you auto fill to the end of a column without dragging all the
way down? I have tried a number of things including the fill option in Edit
but can't seem to get it to work and the help screen is not helping.

Thanks