auto setting for copy-paste in MSOffice 2013 products

Hi;

I am tired of MSOffice copy-paste feature. When I copy from another document or another file/website content, it brings the font type, size and color etc. to my document. I can fix that easily rightclicking on it but I am really sick of that.

I want an absolute solution that enables me to change the copied text font etc. to match my documents font. etc. with no clicks or so. Just assign that as a default copy-paste. How to do? What to do?

I am using Office 2013.

Regards.
LVL 12
jazzIIIloveAsked:
Who is Participating?
 
byundtConnect With a Mentor Commented:
To assign the PasteTextOnly menu item to CTRL + V keyboard shortcut:

1. Right-click a blank spot on the ribbon, and choose Customize Ribbon... from the resulting popup
2. Click the button to customize the keyboard
Customize Keyboard3. Navigate to the PasteTextOnly item, then enter your keyboard shortcut
Create the keyboard shortcut
0
 
Daniel Van Der WerkenIndependent ConsultantCommented:
I found this link:
http://appscout.pcmag.com/business-financial/272436-always-match-destination-formatting

I think it should solve the problem for Word. Looks like there isn't a similar solution for Excel.
0
 
byundtCommented:
You might consider adding a Paste Special...Text button to the QAT in your ribbon. You would then hit that button rather than the one for Paste.
0
 
jazzIIIloveAuthor Commented:
Hi

I just want to paste as usual with CTRL v but adapt the copied text directly to my document.

Regards.
0
 
byundtCommented:
Be careful what you wish for. If you move formatted text from one place in your document to another, are you willing to reformat it?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.