When you paste the data as values only, you need to click the little square at the corner of your selection and choose Values option each time after pasting the data. The following VBA code can help you to change the default paste to paste values. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window. Click Insert > Module, and paste the following code in the Module Window.
In the Word options window click the “Advanced” settings option of the left-side and then scroll down to “Cut, copy, and paste” section. Here you will find all settings related to pasting something within or between word documents, pasting from other programs and past picture as options.
VBA code: Set paste values as default paste when using Ctrl + V Sub PasteasValue() Selection.PasteSpecial Paste:=xlPasteValues End Sub 3. Then save and close the code, and press Alt + F8 keys to open the Macro dialog box. In the Macro dialog, choose the used macro name PasteasValue and then click Options button, see screenshot: 5. Then in the Macro Options dialog box, under the Shortcut key section, please enter v, see screenshot: 6. And then click OK to close the Macro Options dialog, and go on closing the Macro dialog.
![How To Change Default Settings In Word For Copying And Pasting Mac How To Change Default Settings In Word For Copying And Pasting Mac](https://i.stack.imgur.com/GtXFk.png)
And now, when you paste the data with Ctrl + V, the data will be pasted as values by default. Related article: Demo: Set paste values as default paste when using Ctrl + V in Excel. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful: • Merge Cell/Rows/Columns without Losing Data.
![How To Change Default Settings In Word For Copying And Pasting Mac How To Change Default Settings In Word For Copying And Pasting Mac](https://www.digitalunite.com/sites/default/files/images/LZ0027-1-ibeam_0.jpg)
• Combine and Consolidate Multiple Sheets and Workbooks. • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter, • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.
If you spend a lot of time removing the formatting from text that you copy into Office documents (say, text from emails or web pages into Microsoft Word), you should adjust your default paste options. The quickest way to do this in Office 2007 or Office 2010 is just to paste some text into your document and look for the smart tag icon: Click the smart tag to open your Paste Options (note that smart tags in Office 2007 do not use the icons): You could click the Keep Text Only icon (on the far right) but if you want to adjust your defaults, select Set Default Paste to open the Office application's options: Set the defaults you want (I chose Keep Text Only for all) and click OK. Repeat for all of the Office applications you use regularly (Excel, PowerPoint and Word). If you decide that you want to maintain the original formatting for a specific paste, you can easily override it on a paste-by-paste basis. Hi, There is not such option to 'Set Default Paste' in Excel 2010. There are no 'Cut, copy and paste' options as pictured in Excel 2010.