Fix Excel Paste Special Column Widths Deleting Pasted Data
Question details
The user experiences data loss when using Paste Special to adjust column widths after pasting filtered table data as values.

- 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.
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.
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.
Select the filtered table data you want to copy and press Ctrl + C on your keyboard.
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.
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.

Report the Bug to Microsoft
Since this is a reproducible bug in specific Excel builds, reporting it to the developers helps expedite an official patch.
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. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel (.xlsx) files directly.
- 3. Format Freely: Use Paste Special to seamlessly handle values, formats, and column widths without risking data loss.

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.




