Solved

auto setting for copy-paste in MSOffice 2013 products

Posted on 2013-06-20
5
236 Views
Last Modified: 2013-07-05
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
Comment
Question by:jazzIIIlove
  • 3
5 Comments
 
LVL 20

Expert Comment

by:Daniel Van Der Werken
ID: 39262297
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
 
LVL 81

Expert Comment

by:byundt
ID: 39262364
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
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39262941
Hi

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

Regards.
0
 
LVL 81

Expert Comment

by:byundt
ID: 39263010
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
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 39263239
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
Find out what you should include to make the best professional email signature for your organization.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question