I'm having an issue with copying and pasting as well as draggin a formula
down a column. I have the rows set up to alternate colors for visual effect.
The issue I have is when copying and pasting it will undo a cells format
(changing to whatever color [and border etc] was in the copied cell.) I know
you can fix this by clicking the automatically inserted drop down box and
selecting "match destination formatting." The ammount of copying/pasting I
do with this spreadsheet would make that option take forever.
Is there a way to make the "match destination formatting" default?
Bookmarks