I am working on several spreadsheets and have gotten the borders and colors situated the way I want but now I want to copy and edit formulas but it would be nice if there were a way to suppress the copying of the border formats. I know I can paste special with formula only, but that doesn't seem to work when you want to drag across several cells.

Is there a way to lock down the border format, but still allow cell editing?