• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

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.
0
jazzIIIlove
Asked:
jazzIIIlove
  • 3
1 Solution
 
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
 
byundtCommented:
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now