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