Solved

I would like to change the default "paste" option to "paste-text"...

Posted on 2009-04-02
4
297 Views
Last Modified: 2012-05-06
I would like to change the default "paste" option to "paste-text" so that the formatting in the document being pasted INTO is preserved, NOT the source document.  Any overriding solution?  I'm not afraid to get down and dirty in the registry if this is what it takes.

I guess a simple solution would be to create an icon in excel and word that would be "paste-text" but I'd rather just ctrl-v.  Maybe I've already solved my issue.  Anyone come up with something better?
0
Comment
Question by:hbradymfi
  • 2
4 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 24057028
You can use the below macro. Then in the Macros dialog (Alt+F8), select this macro and click "Options". Set the shortcut key to Ctrl+v.

To make it available to every workbook, save it to the Personal.xls file.

Wayne
Sub PasteText()

     On Error Resume Next

     Selection.PasteSpecial xlPasteValues

End Sub

Open in new window

0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 24057033
Ahh, that will only work with Excel. There's no way to globally set the default paste option.
0
 
LVL 23

Accepted Solution

by:
irudyk earned 500 total points
ID: 24059775
Since you are using Office 2007, try the following which should help you get what you're looking for:
In Word
Office Button | Word Options | Advanced | Cut, copy, and paste section
there are options you can set for:
-pasting within the same document
-pasting between documents
-pasting between documents when style definitions conflict
-pasting from other programs
In Excel
Office Button | Excel Options | Advanced | Cut, copy, and paste section
ensure that Show Paste Options buttons is checked off
then when you paste with Ctrl+V you will see as paste option icon to the bottom left of the cell that will allow you to pick from various options
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delete all words in cell more than 5 words 7 47
Sql server Transfering records getting error #NAME? 6 38
How to open a zip file 4 59
Excel Score Formula 5 46
Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now