Office Settings & Configuration

Why Excel Paste Special Shows Only Text Options

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 869 views

Question details

The user wants to restore the normal Excel Paste Special options when only text formats appear.

Why Excel Paste Special Shows Only Text Options
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Clipboard pane

In Excel, select Home, then click the small dialog box launcher in the Clipboard group.

2
Clear copied items

In the Clipboard pane, select Clear All to remove its stored items.

3
Copy the range again

Select the cells in the source worksheet and press Ctrl+C or choose Home > Copy.

4
Test Paste Special

Select a destination cell in a normal Excel worksheet, then choose Home > Paste > Paste Special and check for options such as Values or Formulas.

Clear the Office Clipboard and copy the Excel cells again
Check the copied item: An Excel icon in the Clipboard pane can indicate that Excel recognizes the copied item as an Excel object. A generic document icon may indicate that the data is being treated differently.
Free Microsoft Office alternative

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.

Copy and paste spreadsheet data in WPS SpreadsheetsOpen and edit Microsoft Excel formats such as XLSX and XLSUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

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.