Excel Gurus - I need you.
Pasting new data into a spreadsheet brings up the Paste Options icon to either Keep Source Formatting, or Match Destination Formatting.
How do I universally apply to the spreadsheet so that pasting new data automatically or always matches destination formatting?
Only need on a per worksheet basis (not for a default template).
Thanks!