fill formulas and values
 

Not sure how to fill down formulas, with either dragging or CTRL-D,without
taking along formats, colours, borders (especially) etc with them.
A real pain having to re-format a sheet every time I auto-fill...surely
there is an easier way to do this.

Cheers!
M

Have you tried copying and using Edit Paste Special
Formulas?

HTH
Jason
Atlanta, GA

-----Original Message-----

Not sure how to fill down formulas, with either dragging
or CTRL-D,without
taking along formats, colours, borders (especially) etc
with them.
A real pain having to re-format a sheet every time I
auto-fill...surely
there is an easier way to do this.

Cheers!
M

.