3

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

MarianD
  • 2,726
RShome
  • 131

2 Answers2

0

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

robinCTS
  • 4,407
0

If any of the above solutions are not working then just do below;

Whenever you copy text/table etc. from any source just press Ctrl+C two times frequently and go to wherever you want to paste, and right-click there, you will get the special paste option.

Ramhound
  • 44,080
ADAM
  • 1