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

Improve this question
3
  • You may want to try copying it a few times in a row. Sometimes it doesn't copy it correctly
    – LPChip
    Commented Jun 7, 2018 at 13:55
  • Thanks, just tried that and it didn't work unfortunately.
    – RShome
    Commented Jun 7, 2018 at 14:15
  • Can you add a couple of screenshots showing what happens in Excel 2010 and in Excel 2016?
    – robinCTS
    Commented Jun 11, 2018 at 8:13

2 Answers 2

Reset to default
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

Improve this answer
7
  • Thanks, however when I do this, I am still only presented with two paste options still - Keep Source Formatting and Match Destination Formatting.
    – RShome
    Commented Jun 11, 2018 at 7:32
  • @RShome Even after doing a Paste Special As Text? That's weird! Does Data > Data Tools > Text to Columns work?
    – robinCTS
    Commented Jun 11, 2018 at 7:44
  • @RShome Ah! In Excel 365 2016, the Text Import Wizard has been disabled. It can be re-enabled via File > Options > Data > Show legacy data import wizards and ticking the From Text (Legacy) checkbox. Not sure if that's applicable as I don't have Excel 2016..
    – robinCTS
    Commented Jun 11, 2018 at 8:08
  • Thanks @robinCTS. I can't see those options but I think it's because I am on a client site and everything is very locked down for Excel.
    – RShome
    Commented Jun 11, 2018 at 12:27
  • @RShome Well, the legacy data import options should only be available for Office 365. The Text to Columns tool should be available even in a locked down Excel. It's not an option. You access it from the Data tab in the Data Tools section. Since you're on a client computer, maybe you can take a couple of photos of the screen and upload them so it's clear what the issue is?
    – robinCTS
    Commented Jun 11, 2018 at 13:00
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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .