Share via

When I copy a column, a pop-up appears blocking my view, How can I prevent this?

Anonymous
2020-06-12T08:57:01+00:00

When I copy a column, a pop-up appears which blocks my view.  The pop-up has a drop down menu:

Keep Source formatting

Use Destination Theme

Match Destination formatting

Values only

Values and number formatting

Values and source formatting

Keep source column widths

Formatting only

Link cells

How do I prevent this from happening?

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
  1. Bob Jones AKA CyberTaz MVP 434.8K Reputation points
    2020-06-12T13:35:05+00:00

    I'm assuming you mean that the "pop-up" actually appears when you paste, not when you copy, correct? If so it is the Paste Options button as AaAa_08 mentioned, but you do not need to disable the feature. Just press the esc key when it appears.

    If something is popping up when you copy please provide a screen shot, the present Version of your Office software [as indicated in Excel> About Microsoft Excel] as well as additional descriptive details about the exact steps to reproduce.

    4 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-12T09:04:42+00:00

    Hi I am an independent advisor and hoping to help you today.

    From your description, I think this is a Paste Options since you copied,

    I am sharing a link below on how to disable it, please try the indicated methods:

    https://support.microsoft.com/en-us/office/hide...

    Hope this helps.

    Thank you.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-06-12T16:32:01+00:00

    I'm assuming you mean that the "pop-up" actually appears when you paste, not when you copy, correct? If so it is the Paste Options button as AaAa_08 mentioned, but you do not need to disable the feature. Just press the esc key when it appears.

    Thanks very much for your answer.  It solved the problem.

    You were correct when you said it was during the "Paste" process that the pop-up appeared, not the copying process.

    0 comments