Copy Cell Values Without Formatting in Excel Using Paste Special or a Macro
Question details
Copy a cell's value to another cell without transferring its formatting, either manually or with a button or macro.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to transfer cell data while preserving the destination cell's existing formatting.
- Observed behavior
- The destination receives the source value without copying its formatting or formula.
Identify the source and destination cells and check that the destination has the formatting you want to keep. For a button or VBA macro, use the desktop version of Excel and save the workbook as a macro-enabled file.
Use Paste Special to Copy Values Only in Excel
Use this method for a quick, one-time copy without transferring the source cell's formatting or formula.
Select the source cell, right-click it, and choose Copy.
Right-click the destination cell and choose the Values paste option under Paste Options or Paste Special.

Assign a Value-Copying VBA Macro to an Excel Button
Use a button to repeat the same value transfer without copying the source cell's formatting.
Paste Cell Values Without Formatting in WPS Spreadsheets
Use Paste Special in WPS Spreadsheets to copy a cell's value while keeping the destination formatting.
- 1. Open the workbook: Open WPS Spreadsheets and select Open to load your spreadsheet.
- 2. Copy the source: Select the source cell, right-click it, and choose Copy.
- 3. Paste values only: Right-click the destination cell and choose Paste Special > Values.

Frequently Asked Questions
Does Paste Values copy a formula?
No. Select the source cell, copy it, and use Paste Special > Values at the destination to paste the formula's calculated result instead.
Why does a pasted date look different?
Paste Values keeps the destination's number format. Select the destination cell and use Home > Number Format to choose an appropriate date format.
How do I show the Developer tab in Excel?
In desktop Excel, open the ribbon customization settings and enable Developer. For example, in Excel for Windows, go to File > Options > Customize Ribbon and check Developer.
Can I run the VBA button in Excel for the web?
Excel for the web cannot run VBA macros. Open the macro-enabled workbook in desktop Excel and enable macros only if you trust the file.




