does anybody know if there's a way to lock the cell formatting so when I drag formulas across the worksheet the existing formating (colors, border width, etc) isnt affected?