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

Watch on YouTube

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