Share via

Copy-Paste includes unselected cells

Anonymous
2010-10-14T08:20:03+00:00

If you have a colum of data that you want to copy and paste to another program i.e a list of email adresses to outlook or to word and you select cell using shift and ctrl. In that list you have a cell with information that you dont want included into the paste so you skip that cell by using ctrl, when you than paste the copy into another program the skipped cell is included into your paste but if you post the same copy into excel then the paste in as you would expect. If you look into the clipboard manager you will se all cells included in the copy but somehow excel manages to sort that out when pasting internally but not externally.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-10-14T08:31:31+00:00

Hi,

so you have to copy & paste in two steps (manually or programmatically):

  1. Copy & paste your data from one Excel sheet to another Excel sheet (the blank cells are skipped)
  2. Copy & paste that cleanded data into the other program.

Regards,

Frank

If this post answers your question, please mark it for all readers as the Answer.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-10-14T08:39:52+00:00

    Hi,

    yes, it is!

    Regards,

    Frank

    If this post answers your question, please mark it for all readers as the Answer.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2010-10-14T08:32:59+00:00

    Hi,

    Thank you Frank for you reply,

    So is this behavior by design?

    Regards

    Uno

    Was this answer helpful?

    0 comments