Excel - Make Ctrl+V be Paste Special - Episode 1828
2,009 views · Published 13 November 2013 · 2:15 · Indexed 22 October 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: How to Prevent Ctrl+V from Pasting and Make it a Paste Special Command in Excel. Welcome back to the MrExcel podcast. In this episode, we will be discussing how to prevent Ctrl+V from pasting and instead make it a Paste Special command. This question was sent in by Seckin via YouTube, who was having trouble with a co-worker accidentally overwriting conditional formatting and data validation by using the regular paste command. To solve this problem, we can assign Ctrl+V to a macro that will automatically paste values instead of the regular paste command. To do this, go to the View tab and select Macros. Record a new macro and name it "AlwaysPasteValues". Then, assign it to Ctrl+V and store it in the workbook. Now, whenever you or your co-worker use Ctrl+V, it will automatically paste values instead of overwriting any formatting or validation. This solution will only work if your co-worker is used to using Ctrl+V to paste. If they use any other shortcut or method, it will not override it. However, this is a great way to prevent accidental overwriting of important formatting and validation. Some people even create "dictator applications" where they assign multiple macros to all the shortcut keys to prevent anyone from using them. Thank you for tuning in to this episode of the MrExcel podcast. We hope this tip will help you save time and avoid frustration in your Excel work. Don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time for another netcast from MrExcel. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Change Ctrl+V to Paste Values! (00:15) Problem with Regular Paste (00:25) Solution: Assigning Ctrl+V to a Macro (01:00) Recording the Macro (01:21) Macro Shortcut Key Overwrites Equivalent Shortcut Key (01:49) Creating a "Dictator Application" (02:05) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial Seckin set up a worksheet for his co-workers with great conditional formatting. Unfortunately, the co-worker uses Ctrl+V instead of Paste Special Values, which destroys the conditional formatting and/or data validation. In this episode, record a simple macro that changes Ctrl+V to Paste Special Values. Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153652/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920