2

Suppose I have an Excel file with columns A,B,C,D, and E. I need to copy and paste columns A,B, and E into a text editor. However whenever I paste the data, I end up getting columns C and D.

I ctrl+click on the column headers to select them and only A,B, and E are highlighted, but yet I end up with the data from C and D.

Here is a video of what happens when I try the copy/paste into a different workbook: http://youtu.be/rbtIrZOzaDs

1 Answer 1

2

Try copy-pasting the selected columns to a new sheet, then copying the just-pasted columns from the new sheet, and then copy-pasting into your text editor.

First copy the target columns by selecting them and pressing Ctrl+C:

enter image description here

Then open a new sheet and paste the columns by selecting cell A1 and pressing Ctrl+V:

enter image description here

Now press Ctrl+C again to copy those columns:

enter image description here

Now open your text editor and press Ctrl+V to paste:

enter image description here

5
  • This did not work for me.
    – Zared H
    Jul 20, 2015 at 17:17
  • I added some directions with screenshots. Jul 20, 2015 at 17:23
  • I'm getting all the data even when I paste into Excel.
    – Zared H
    Jul 20, 2015 at 17:40
  • I've posted a screen capture of what happens when I try this method.
    – Zared H
    Jul 20, 2015 at 18:15
  • This is likely because you are copying into a separate instance of Excel. Try copy-pasting to a different sheet in the same workbook. Jul 20, 2015 at 18:16

You must log in to answer this question.

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