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

Oh my how easy! Thanks a lot!

"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

Hi,

Then instead of Ctrl+Enter goto Edit/Fill/Series and select Autofill under
"Type" and hit Enter.

Cheers!
Jean-Guy

"Mary jane" wrote:

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

Glad to help!.....thanks for the feedback!

Regards!
Jean-Guy

"Mary jane" wrote:

Oh my how easy! Thanks a lot!

"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