Hello I wonder how is it possible Microsoft still gets away with this problem. I think it can cause big trouble to many people who just don't notice this behavior.

If you select a column of cells, but then exclude some of those with ctrl+click and you copy, paste it into notepad or MS Word, you WILL have also the cells you excluded if they were in the middle! If you are aware of this "feature" you will do a workaround by pasting the selection into new excel sheet and then copy it again from there. I think this is an unacceptable bug. Any ideas if there is some settings to make this behave properly or I just have to remember this?

I just tried how OpenOffice Calc behaves and unlike excel it only copies the selected cells until the one which was excluded. Still not right but better, because you will clearly see that it's not what you wanted so there is much smaller chance you will make a mistake.

  • As far as I can tell, it's not possible. But even if it were, I think it would cause empty rows to appear, especially if trying to copy from a Microsoft product to a non-MS product. One possible idea is this... create a macro that would copy your data and paste elsewhere in excel. Then either the same or another macro would copy that newly pasted data to your clipboard. Wonky, i know, and not sure if it saves time over just manually doing it. – Isolated Oct 30 '20 at 14:32
  • I don't get it. Imagine situations like some excel list of employees. Boss' assistant goes through a list and wants to copy and paste some names into email. If she selects most of them excluding just a few, how likely is it that she doesn't realize this and makes a mistake?? MS or non MS product don't matter. Word behaves the same. – Vitas Nov 1 '20 at 13:28

I did some tests, but I can't reproduce your problem.

After you copy (you have excluded some cells), will the unselected cells also show the status of being copied?

As long as these cells are not displayed as being copied, they will not be copied.

enter image description here

enter image description here

  • please read my post carefully. You are copying it from excel to excel! There is no problem with that – Vitas Oct 30 '20 at 11:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.