How to Restore Paste Special Text in Excel 2016
Question details
The user needs to restore the Paste Special Text option in Excel 2016 after it disappeared, likely because of an incompatible or damaged add-in.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- A workbook depends on text-only paste behavior, but the Paste Special Text option is missing.
- Observed behavior
- The Paste Special Text option disappears, and Paste Special Values does not preserve the required text-only format.
Before you change add-ins, save any open workbooks and note which Excel add-ins are currently enabled. You will need permission to restart Excel in Safe Mode.
Start Excel 2016 in Safe Mode to Test Paste Special Text
Use this first to confirm whether an add-in is responsible for the missing Paste Special Text command.
Safe Mode loads Excel without add-ins, startup files, or customized toolbars. If Paste Special Text returns in Safe Mode, the issue is likely an incompatible or damaged add-in rather than the Excel 2016 installation itself.
Close all Excel 2016 windows. Press Windows logo key + R to open the Run dialog.
Type excel /safe in the Run box and press Enter. Confirm that Excel opens with Safe Mode in the title bar.
Open the affected workbook, select the target cells, and go to Home > Paste > Paste Special to check whether Paste Special Text is available and works as expected.
If Paste Special Text returns, exit Safe Mode and proceed to disable add-ins one by one.

Identify and Disable the Conflicting Excel Add-in
Use this after Safe Mode confirms an add-in conflict so you can isolate the add-in that removes Paste Special Text.
Use WPS Office Spreadsheets for Reliable Paste Special Text
If Excel 2016 add-in conflicts keep breaking the Paste Special Text command, WPS Office Spreadsheets is a free, lightweight alternative with built-in paste options, familiar ribbon tools, and XLSX compatibility for a smooth move from Microsoft Office.
- 1. Download WPS Office: Click Download WPS Office Free and install WPS Office on your Windows PC.
- 2. Open the workbook in WPS Spreadsheets: Launch WPS Spreadsheets and open the existing Excel 2016 .xlsx workbook.
- 3. Use Paste Special Text: Select the destination cells, click Home > Paste > Paste Special, and choose Text to paste values as text without Excel add-in interference.

Frequently Asked Questions
Why did Paste Special Text disappear in Excel 2016?
It is usually caused by an incompatible or damaged third-party add-in. Start Excel in Safe Mode; if the option returns, disable add-ins one at a time to find the conflict.
How do I start Excel 2016 in Safe Mode?
Press Windows logo key + R, type excel /safe, and press Enter. Then open your workbook and test whether Paste Special Text is available.
How do I disable add-ins in Excel 2016?
Go to File > Options > Add-Ins, select Excel Add-ins or COM Add-ins from the Manage drop-down, click Go, clear an add-in checkbox, and click OK.
What should I do if Paste Special Text is still missing after disabling add-ins?
Run a repair of Microsoft Office from Control Panel > Programs > Microsoft Office > Change > Quick Repair, then restart the computer and test the paste option again.
Can WPS Office handle Paste Special Text workbooks from Excel 2016?
Yes. WPS Spreadsheets supports Paste Special Text and opens, edits, and saves .xlsx files, so you can continue the same text-only paste workflow without Excel add-in conflicts.




