Others

How to Restore Paste Special Text in Excel 2016

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 869 views

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.

How to Restore Paste Special Text in Excel 2016
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 start

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.

Solution 1Recommended

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.

1
Close Excel and open the Run dialog

Close all Excel 2016 windows. Press Windows logo key + R to open the Run dialog.

2
Launch Excel in Safe Mode

Type excel /safe in the Run box and press Enter. Confirm that Excel opens with Safe Mode in the title bar.

3
Test Paste Special Text

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.

4
Interpret the result

If Paste Special Text returns, exit Safe Mode and proceed to disable add-ins one by one.

Start Excel 2016 in Safe Mode to Test Paste Special Text
What this result means: If Paste Special Text is available only in Safe Mode, an add-in conflict is the most likely cause.
Free Microsoft Office alternative

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. 1. Download WPS Office: Click Download WPS Office Free and install WPS Office on your Windows PC.
  2. 2. Open the workbook in WPS Spreadsheets: Launch WPS Spreadsheets and open the existing Excel 2016 .xlsx workbook.
  3. 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.
Paste Special Text remains available without relying on Excel add-ins.Opens, edits, and saves Excel 2016 .xlsx files with format compatibility.Free, lightweight office suite with a familiar Microsoft Office-style interface.Seamless migration for existing workbooks and text-only paste workflows.
microsoft office alternative - wps office

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.