FIX COPY AND PASTE ON EXCEL

Blessing Bende 0 Reputation points
2026-10-07T08:48:22.9266667+00:00

How can i fix my copy and paste on excel because i can not copy and paste automatically?

Microsoft 365 and Office | Excel | For home | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SD - IA 180.9K Reputation points Independent Advisor
    2026-10-07T09:45:00.4233333+00:00

    Hi,
    I think an update earlier this month resolved this bug

    https://www.reddit.com/r/excel/comments/1wljgkn/microsoft_has_released_a_fix_for_the_copy_and/.

    May I know if Excel is provided by the company you work for, and is it indeed 365?

    Also ref:

    https://support.microsoft.com/en-us/support/known-issues/paste-not-work-excel

    I look forward to hearing from you to get the results of the troubleshooting.

    Standard 3rd party link disclaimer:

    There may be links to non-Microsoft websites that provide accurate and safe information. Watch out for ads on websites frequently classified as PUP (Potentially Unwanted Products). There is no need to buy paid products to fix your computers, as they sometimes do more harm than good.

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-10-07T08:48:46.1+00:00

    Try these fixes in order:

    1. Install the latest Office updates A known Excel issue can cause paste to fail silently. Microsoft fixed it in later updates. After updating Office, restart Excel and test copy/paste again.
    2. Use Paste Special as a workaround Go to Home > Paste ▼ > Paste Special and choose Values, Formulas, or another needed option. This is the documented workaround when normal paste fails.
    3. Make sure the paste area matches the copied area If the copied range and destination range are not the same size and shape, paste can fail.
      • Either select only the top-left destination cell and paste
      • Or select a destination range with the same number of rows and columns as the copied data
    4. Check whether the destination columns have the right format If pasting a large amount of data, set the destination column format first:
      • Select the column letter
      • Go to Home > Number Format
      • Choose the format that matches the data Then paste again, one column at a time if needed.
    5. Make sure there is enough room to paste If needed, insert more columns:
      • Select the column to the right of where the new column should go
      • Go to Home > Insert
      • Repeat until enough columns exist
    6. If formulas break after pasting, paste values instead To avoid formula reference problems, copy the cells, then use Home > Paste > Paste Values.
    7. If Paste Special is missing or not working
      • Go to File > Options > Advanced
      • Under Cut, copy and paste, make sure Show Paste Options button when content is pasted is checked
      • Close all web browser windows and test again
      • Start Excel in Safe Mode by holding Ctrl while opening Excel. If paste works there, an add-in is likely causing the problem. Re-enable add-ins one at a time to find the conflicting one.
    8. If two Excel windows are open in separate instances Paste attributes with Paste Special may not work between different Excel instances. Open both workbooks in the same Excel instance.

    If the problem started recently and normal paste does nothing with no error, updating Office is the most important fix.

    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.