How do I fix the Special Paste Functions on Excel

CJones 0 Reputation points
2026-09-18T02:09:14.9033333+00:00

Only the basic Paste works on my Excel Worksheet (MOS 365). How would I fix it so the Paste Options and Paste Special Functions and Categories are no longer grayed out or are seen when I click the Paste Menu?

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

2 answers

Sort by: Newest
Most helpful Newest Oldest
  1. TaoLi 112.8K Reputation points Independent Advisor
    2026-09-18T03:17:25.6566667+00:00

    Hi,

    Please first check this setting in Excel:

    Go to File > Options > Advanced > Cut, copy, and paste, then make sure Show Paste Options button when content is pasted is checked. Restart Excel afterward and test again.

    If Paste Special is still grayed out, please also try Ctrl + Alt + V in a new blank workbook and let me know if the same thing happens there.

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-09-18T02:09:31.1833333+00:00

    Try these fixes in order on Excel for Windows:

    1. Turn the Paste Options button back on
      • Go to File > Options > Advanced.
      • Under Cut, copy, and paste, make sure Show Paste Options button when content is pasted is checked.
      • This restores the Paste Options button that appears after pasting.
    2. Open Paste Special directly
      • Go to Home > Paste > Paste Special.
      • Or press Ctrl+Alt+V.
      • If some choices are still grayed out, that can depend on the type of content copied and the paste option selected.
    3. Check whether Excel events are clearing the clipboard
      • If a Worksheet_SelectionChange event is being used, it can clear the clipboard and disable Paste Special.
      • In that case, set Application.EnableEvents to False.
    4. Test for browser interference
      • Close all open web browser instances.
      • Then try Paste Special again.
      • Browser conflicts can prevent Paste Special from working.
    5. Test Excel in Safe Mode to rule out add-ins
      • Find the Excel shortcut.
      • Press and hold CTRL, then double-click Excel.
      • Click Yes to start in Safe Mode.
      • If Paste Special works there, an add-in is likely causing the problem.
      • Re-enable add-ins one at a time until the conflicting one is found, then leave it disabled or uninstall it.
    6. Make sure both workbooks are in the same Excel instance
      • If copying between two separate Excel instances, Excel may show the Windows Paste Special dialog instead of the Excel one.
      • Open both workbooks in the same Excel instance and try again.
    7. If normal paste is failing silently, use the current workaround
      • Go to Home > Paste > Paste Special.
      • Try Formula, Formula and number formats, Values, Values and number formats, or Paste Link.

    Common Paste Special options available when working normally include All, Formulas, Values, Formats, Comments and Notes, Validation, Column widths, Formulas and number formats, and Values and number formats.

    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.