Excel – Missing Paste (P) option in Excel 2016

copy/pastecut-and-pastemicrosoft excelmicrosoft-excel-2016

I'm copying some data from a webpage which is tabulated. When I click Ctrl+C in Excel 2010 and Ctrl+V to paste, it pastes correctly.

However, in Excel 2016, the Paste (P) option is not there.

Only – Keep Source Formatting (K) – Match Destination Formatting (M).

I have repaired office, disabled add-ins in Excel safe mode, removed Skype to Call on browser, tried modifying registry keys.

None of these work. It works fine on Excel 2010. I just want to see the Paste (P) option but can't.

Any help would be appreciated.

Regards.

Adding some images — 1st one shows no Paste(P) option but second one does. Why isn't the Paste(P) option always available???

enter image description hereenter image description here

Best Answer

Go to the Advanced Options panel (Office Button → Excel Options → Advanced), scroll down to the Cut, copy and paste section and make sure the Show Paste Options buttons checkbox is ticked:

Screenshot of Options Pane


After copying, do a Paste Special as Text (Home → Clipboard → Paste → Paste Special… → Text → OK):

Screenshot of Paste Special dialog box


Finally, click the Paste Options button and select Use Text Import Wizard:

Screenshot showing selecting the Text Import Wizard

Related Question