Excel Performance Problems

Fix Excel Paste Special Column Widths Deleting Pasted Data

Phi Hung VoPhi Hung Vo Nov 10, 2026 868 views

Question details

The user experiences data loss when using Paste Special to adjust column widths after pasting filtered table data as values.

Fix Excel Paste Special Column Widths Deleting Pasted Data
Product
Microsoft Excel
Device & OS
not provided
Scenario
Copying filtered table data and pasting it into another sheet or workbook as values, followed by pasting column widths.
Observed behavior
The previously pasted data disappears completely when the Paste Special > Column Widths action is applied.
Before you start

Check your current Microsoft Office version, as this specific Paste Special issue is a known bug associated with certain Excel builds. Updating the software to the latest release may resolve the problem automatically.

Solution 1Recommended

Workaround: Paste Column Widths Before Pasting Values

By changing the sequence of your paste operations, you can safely apply column formatting without triggering the bug that deletes cell contents.

Since the issue occurs when column widths are pasted directly over recently pasted values, reversing the order bypasses the glitch entirely.

1
Copy the Target Data

Select the filtered table data you want to copy and press Ctrl + C on your keyboard.

2
Apply Column Widths First

Right-click the destination cell in your new sheet, select 'Paste Special', check the 'Column widths' option, and click OK. The columns will resize, but no data will be pasted yet.

3
Paste Values Second

Right-click the same destination cell again, select 'Paste Special', choose 'Values', and click OK. Your data will now appear securely within the resized columns.

Workaround: Paste Column Widths Before Pasting Values
Data Preserved: This method ensures your data formatting matches the source without exposing your values to the data deletion bug.
Free Microsoft Office alternative

Avoid Excel Bugs with WPS Office Spreadsheet

If specific Excel build bugs are disrupting your workflow, try switching to WPS Office. It provides a highly stable, free alternative to Microsoft Excel, ensuring your data pasting and formatting tasks work seamlessly without sudden data loss.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel (.xlsx) files directly.
  3. 3. Format Freely: Use Paste Special to seamlessly handle values, formats, and column widths without risking data loss.
Free and lightweight office suite with exceptional stability.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Reliable Paste Special functions without the data deletion bug.Familiar user interface so you can start working immediately.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my pasted data disappear when adjusting column widths?

This is a known software bug in specific builds of Microsoft Excel. When applying Paste Special > Column Widths over recently pasted values, the software mistakenly clears the cell contents instead of just updating the formatting.

How do I check my current Excel build number?

Open Excel, click on 'File', then select 'Account' (or 'Help' in older versions). You will find the exact version and build number listed under the 'About Excel' section.

Will updating Excel fix the Paste Special bug?

If Microsoft has released a patch for the specific build containing this bug, updating will resolve it. Go to File > Account > Update Options > Update Now to check for the latest bug fixes.

Can I paste values and column widths at the same time in Excel?

Standard Excel does not offer a single-click option to paste both 'Values' and 'Column Widths' simultaneously. You must perform the Paste Special action twice to achieve this result.