A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Try these checks in order:
- In Excel, go to File > Options > Advanced. Under Cut, copy and paste, make sure Show Paste Options button when content is pasted is checked.
- Test whether Paste Special is working. If Paste Special is missing or not working, close all web browsers and try again.
- Start Excel in Safe Mode to check for an add-in conflict:
- Find the Excel icon.
- Press and hold Ctrl and double-click Excel.
- Select Yes when asked to start in Safe Mode.
- If copy/paste works in Safe Mode, enable add-ins one at a time until the conflicting add-in is found, then leave it disabled or uninstall it.
- If the problem happens when copying between two separate Excel windows, open both worksheets in the same Excel instance. Excel cannot use its full internal Paste Special functionality across multiple Excel instances.
- If paste still does nothing and the copied range stays selected with no error, this matches a known Excel issue where paste can fail silently in Excel 2024, 2021, 2019, and 2016. Microsoft is investigating.
- If the goal is to copy an entire worksheet to another workbook in Excel for the web, right-click Move or Copy is not available there. Use this workaround instead:
- Select all data in the worksheet.
- Press Ctrl+C.
- Open the other workbook and add a blank worksheet with +.
- Select the first cell and press Ctrl+V.
- Note: conditional formatting is lost with this method.
If hidden or filtered rows or columns are involved, use Home > Find & Select > Go To Special > Visible cells only before copying.