Why Excel Paste Special Shows Only Text Options
Question details
The user wants to restore the normal Excel Paste Special options when only text formats appear.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying data and opening Paste Special in Excel.
- Observed behavior
- Paste Special shows options such as Unicode Text or Text instead of the usual Excel paste options.
Identify whether the copied data comes from an Excel worksheet or another application. Keep the source workbook open while testing, and select actual cells rather than text inside a cell.
Clear the Office Clipboard and copy the Excel cells again
Use this method when a clipboard issue may be preventing Excel from recognizing the copied range.
In Excel, select Home, then click the small dialog box launcher in the Clipboard group.
In the Clipboard pane, select Clear All to remove its stored items.
Select the cells in the source worksheet and press Ctrl+C or choose Home > Copy.
Select a destination cell in a normal Excel worksheet, then choose Home > Paste > Paste Special and check for options such as Values or Formulas.

Test worksheet copying and restart Excel
Use a direct worksheet-to-worksheet test to distinguish an Excel or clipboard issue from a third-party source issue.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files and continue editing, although it does not fix Excel's clipboard behavior.

Frequently Asked Questions
Why does Paste Special show Unicode Text instead of Excel options?
Excel may be receiving the copied content as text rather than an Excel cell range. Clear the Office Clipboard from Home > Clipboard, copy the cells again, and test Paste Special in another worksheet.
Where is the Clipboard pane in Excel?
On the Home tab, click the small dialog box launcher in the Clipboard group. Use Clear All in the pane to remove its stored items.
Can data copied from another application limit the paste options?
Yes. If the source application places text rather than Excel-formatted data on the clipboard, Excel may offer only text-compatible formats. Compare it with a range copied directly from an Excel worksheet.
What should I try if clearing the Clipboard does not help?
Close and reopen Excel, then copy cells directly between normal worksheets and check Home > Paste > Paste Special. If the issue persists, restart the computer and test again.




