How do I set the default paste option?

F

Forester

I really don't want the extra step of the paste option box on a worksheet,
but when I eliminate the appearance of that box it always uses the "match
source formatting" option. I always want to use the "match destination
formatting" option on my worksheets. Isn't there any way to set the default
paste option to "match destination formatting" or am I forced to go through
the extra step every time I copy and paste?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste options button disappears 0
Remove title bar and phase bar by default on swimlane 0
Pasting from the clipboard 3
Options 4
New computer, how do i move outlook 365 ENTIRELY? 0
Paste Options Icon does not show 0
default options 0
VBA - (re-) Set a Table Style 2

Top