Override Ctrl+V: How to Set Paste Values as Default in Excel

Learn how to make Paste Values the default Ctrl+V action in Excel using built-in shortcuts, Quick Access Toolbar tweaks, or a custom VBA macro.

Tired of messing up your spreadsheet's clean formatting every time you copy and paste data? You are not alone in finding Excel's default pasting behavior frustrating.

Problem Description: Unwanted Formatting When Pasting

By default, when you use the standard Ctrl+V command in Microsoft Excel, the software pastes everything: the data, the source font, background colors, and cell borders. This behavior often overwrites your carefully designed destination formatting. Unfortunately, Excel does not feature a simple built-in toggle switch within its Options menu to permanently change the default Ctrl+V behavior to "Paste Values Only."

Quick Answer for Defaulting to Paste Values

The fastest way to paste values only is to use the Ctrl+Shift+V shortcut (available in newer Microsoft 365 versions), or to add "Paste Values" to your Quick Access Toolbar. If you strictly want to force Ctrl+V to paste values only, you must create a short VBA macro to intercept the command.

Likely Causes Behind Excel's Pasting Behavior

• Legacy Software Design: Excel was originally programmed to prioritize exact data replication, assuming users want to keep source styling intact.
• Lack of Global UI Toggles: Microsoft has not implemented a universal radio button in settings to permanently alter the clipboard's default drop behavior.
• Shortcut Hardcoding: Ctrl+V is deeply embedded in the Windows and Office ecosystem as a universal "Paste All" command.

Recommended Solution: Remap Ctrl+V Using a VBA Macro

To truly override the Ctrl+V shortcut so it only pastes values, you can record and assign a simple VBA script. Warning: Running this macro will clear Excel's undo history for that specific action.

1. Open the Excel workbook where you want this applied (or save it to your Personal Macro Workbook to apply it globally).
2. Press Alt + F11 to open the VBA Editor.
3. Click Insert > Module from the top menu.
4. Copy and paste the following code into the blank window:
   Sub PasteValuesOnly()
  On Error Resume Next
  Selection.PasteSpecial Paste:=xlPasteValues
End Sub
5. Close the VBA Editor to return to your spreadsheet.
6. Press Alt + F8 to open the Macro dialog box. Select PasteValuesOnly and click Options.
7. In the "Ctrl +" shortcut box, type a lowercase v. Click OK.

Alternative Solutions for Stripping Formats on Paste

1. Use the New Native Shortcut: If you are using an updated version of Microsoft 365 or Excel for the Web, simply press Ctrl + Shift + V to paste plain text/values automatically.
2. Utilize the Quick Access Toolbar (QAT): Click the down arrow at the very top of your Excel window, select More Commands, and add Paste Values to your QAT. If it is the first icon in the list, you can now trigger it by pressing Alt + 1.
3. Use the Paste Options Menu: Press Ctrl + V normally, then immediately press the Ctrl key by itself, followed by the V key again. This navigates the floating paste menu to select values.

Working with WPS Office: Simpler Paste Formatting

If you find Excel's macro workarounds cumbersome, consider trying WPS Office. WPS Spreadsheets offers an incredibly intuitive interface with robust "Paste Special" capabilities right out of the box, cleanly handling unformatted text natively. As a highly compatible and free alternative to Microsoft Office, WPS allows you to seamlessly open, edit, and save your local `.xlsx` documents while providing simpler ways to manage data without destroying your spreadsheet's aesthetic.

Prevention Tips for Avoiding Clashing Spreadsheet Styles

• Match Destination Formatting: Get in the habit of right-clicking a cell and selecting the clipboard icon featuring "123" to drop values instantly.
• Use an Intermediary Buffer: When copying from the web or other heavily styled documents, paste the text into Notepad first to strip all formatting, then copy it into Excel.
• Format as Table: Converting your data ranges to official Excel Tables (Ctrl+T) can sometimes force pasted data to adopt the table's uniform design parameters automatically.

FAQs About Excel Paste Special Shortcuts

Why does the VBA macro method break the Undo (Ctrl+Z) feature?

By design, executing any VBA macro in Excel flushes the software's undo stack memory. This means you will not be able to undo the paste action or any actions performed prior to running the macro.

Does Ctrl+Shift+V work in older versions of Excel?

No, the Ctrl+Shift+V shortcut for pasting as plain text/values is a highly requested feature that Microsoft only recently added to Microsoft 365 and Excel for the Web. Older standalone versions like Excel 2016 or 2019 do not support it natively.

Can I undo the macro shortcut if I want regular Ctrl+V back?

Yes. Simply press Alt + F8 to open your Macros list, select "PasteValuesOnly", click Options, and delete the "v" from the shortcut key box. Ctrl+V will immediately revert to its default Windows behavior.