How to Paste Values or Unformatted Text by Default in Excel
Question details
The user wants to know if there is a way to configure Excel to paste values or unformatted text by default when using the standard paste command.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying data from external sources or other formatted cells and pasting it into an Excel worksheet without bringing over the original fonts, colors, or borders.
- Observed behavior
- Excel preserves the source formatting by default when using the Ctrl+V shortcut, and there is no built-in global toggle to change this standard behavior to unformatted text.
Ensure that your source data is successfully copied to your clipboard. Since Excel does not offer a native setting to permanently change the default Ctrl+V action to paste values, you will need to utilize the Paste Special feature or the Paste Options menu.
Use Paste Special to Paste Values or Text
Since there is no global setting to alter the default Ctrl+V behavior, using the Paste Special menu is the most reliable built-in method to strip unwanted formatting.
The Paste Special dialog allows you to choose exactly which attributes of the copied data you want to keep. Selecting 'Values' ensures only the raw data is inserted.
Highlight the text or cells you want to copy and press Ctrl+C.
Right-click the destination cell in your Excel spreadsheet where you want the data to appear, and select 'Paste Special' from the context menu.
In the Paste Special dialog box, select the radio button next to 'Values' (if copying from within Excel) or choose 'Text'/'Unformatted Text' (if copying from an external application).
Click 'OK' to paste your data cleanly without importing the original formatting.
Use the Paste Options Floating Button
If you already pressed Ctrl+V, you can quickly adjust the format of your pasted data immediately after the fact.
Effortlessly Manage Data and Formatting in WPS Spreadsheet
WPS Office provides a highly compatible, free alternative to Microsoft Office. With WPS Spreadsheet, you can seamlessly handle data entry, utilize quick Paste Special shortcuts, and manage your cell formatting without any hassle.
- 1. Open your workbook: Launch WPS Spreadsheet and open the file you wish to edit.
- 2. Copy source data: Highlight your source text or cell and press Ctrl+C.
- 3. Open Paste Special: Select the destination cell, right-click, and choose 'Paste Special', or simply press Ctrl+Alt+V.
- 4. Paste as values: Select 'Values' or 'Unformatted text' and click 'OK' to insert the clean data.
Frequently Asked Questions
Is there any way to make Ctrl+V paste values only in Excel?
Excel does not have a built-in toggle to redefine the standard Ctrl+V shortcut. However, advanced users can create a custom VBA macro to paste as values and assign the Ctrl+V keyboard shortcut specifically to that macro.
What is the fastest keyboard shortcut for pasting values in Excel?
The fastest built-in method without a mouse is to press Ctrl+Alt+V to open the Paste Special dialog, press 'V' to select Values, and then press Enter. Another popular sequence is Alt, E, S, V, Enter.
Why does my copied data keep its original font and color?
By default, Excel preserves the source formatting (such as fonts, background colors, and borders) to keep data context intact. You must explicitly choose Paste Special > Values to override this behavior and strip the formatting.
Can I use 'Match Destination Formatting' instead of pasting values?
Yes. When you copy data from external sources like a web page or Word document, you can right-click the destination cell and select 'Match Destination Formatting'. This removes the source style and adopts the font and style currently applied to your Excel cell.
