The Data You Are Pasting Is Not the Same Size

How do I copy paste and keep cells the same size?

Copy and paste column width with data in Excel

• Select your data and press Ctrl + C or right click to select copy form the context menu to copy it.
• Then click a cell which you want to paste the data, and right click choose Paste Special > Keep Source Column Width icon, see screenshot:

How do you fix paste in Excel?

Part 3: Advanced Solutions to Fix Microsoft Excel Cannot Paste the Data

• Solution 1: Restart the Excel File. …
• Solution 2: Check the Merge Cell. …
• Solution 3: Disable the Macro Express Application. …
• Solution 4: Use Paste Special Option. …
• Solution 5: Ignore DDE. …
• Solution 6: Restart the PC in Clean Boot State.