VBA & Macro Problems

Copy Cell Values Without Formatting in Excel Using Paste Special or a Macro

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

Copy a cell's value to another cell without transferring its formatting, either manually or with a button or macro.

Copy Cell Values Without Formatting in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the source cell

Select the source cell, right-click it, and choose Copy.

2
Paste the value

Right-click the destination cell and choose the Values paste option under Paste Options or Paste Special.

Use Paste Special to Copy Values Only in Excel
Destination formatting stays in place: If the source contains a formula, Excel pastes its calculated result, not the formula. Dates and numbers may look different if the destination uses a different number format.
Copy values in WPS Spreadsheets

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. 1. Open the workbook: Open WPS Spreadsheets and select Open to load your spreadsheet.
  2. 2. Copy the source: Select the source cell, right-click it, and choose Copy.
  3. 3. Paste values only: Right-click the destination cell and choose Paste Special > Values.
Paste calculated values without copying source formattingOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with spreadsheets using the free WPS Office suite
microsoft office alternative - wps office

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.