Autofill Format

[Fozzie Bear]

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.

 

[Fozzie Bear]

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

 

[Dave Peterson]

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]

Sigh...

Sometimes the easiest solution is the most overlooked.

Thanks, Dave.

Fozzie