Every time I copy and paste a column is just shows up white with no data.

Phil Caldwell 0 Reputation points
2026-09-12T23:39:03.1233333+00:00

This issue of cells and columns not being able to be copied and pasted needs addressing and damned quick. I pay a member ship fee for Office 365 each month and after the latest updates it is basically broken. I am not paying for a product I cannot use, so Microsoft, pull your collective fingers out and get this matter corrected quickly.

Microsoft 365 and Office | Excel | For home | Windows

1 answer

Sort by: Most helpful
  1. AI answer

    2026-09-12T23:39:16.74+00:00

    If this started after a recent Office update, there is a reported Excel issue where normal copy and paste stops working after update KB5002914. In that case, these are the supported next steps:

    1. Test whether only standard paste is failing
      • If Paste Special → Values works, but normal Ctrl+C / Ctrl+V does not, that matches the reported post-update behavior.
    2. Run an Online Repair of Office
      • This is a supported repair step for copy/paste problems after an update.
    3. If the problem began immediately after the latest update, uninstall update KB5002914 and restart Windows
      • This was the accepted resolution in the reported case.
      • If uninstalling the update does not fix it, reinstall Office.
    4. If pasting a large amount of data into Excel, check the destination column format
      • Select the destination column.
      • Go to Home > Number Format.
      • Choose the format that matches the data being pasted.
      • Try pasting one column at a time.
    5. Make sure the paste area matches the copied data
      • Either select only the upper cell before pasting, or
      • Select a destination range with the same number of rows and columns as the copied data.
    6. If the pasted result appears blank because rows or columns are hidden, copy visible cells only
      • Go to Home > Find & Select > Go To Special.
      • Select Visible cells only > OK.
      • Copy again and paste into the upper-left destination cell.
    7. If the issue is with column appearance after paste, keep the source column widths
      • After copying, go to Home > Paste arrow > Keep Source Column Widths.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.