Is there a way to use the fill handle to autofill, but do so without changing
the formatting of the cells--adding data only?

I'm trying to avoid having the fill colors, width of gridlines, and
everything else change when I autofill?

Thanks.

Oh. And I'm using Excel for Office 2000.

If you rightclick and drag that autofill button, you'll see a bunch of options.
Maybe one of them will be what you want.



Fozzie Bear wrote:

Is there a way to use the fill handle to autofill, but do so without changing
the formatting of the cells--adding data only?

I'm trying to avoid having the fill colors, width of gridlines, and
everything else change when I autofill?

Thanks.

--

Dave Peterson

Sigh...

Sometimes the easiest solution is the most overlooked.

Thanks, Dave.

Fozzie


"Dave Peterson" wrote:

If you rightclick and drag that autofill button, you'll see a bunch of options.
Maybe one of them will be what you want.



Fozzie Bear wrote:

Is there a way to use the fill handle to autofill, but do so without changing
the formatting of the cells--adding data only?

I'm trying to avoid having the fill colors, width of gridlines, and
everything else change when I autofill?

Thanks.

--

Dave Peterson