Share via

Losing Cells Data Validation Rules After Cut and Paste Action

Anonymous
2017-12-10T23:25:57+00:00

Hello Dears,

I have an excel table with data validation rule applied to some cells.

When I cut some of them and paste in another place, I lose the data validation rule of the original cell.

Is there any way to prevent losing data validation rule when I use the cut command?

I really appreciate any help. Tks

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. Anonymous
    2017-12-10T23:49:03+00:00

    Ciao,

    you can use a workaround:

    1. Open the clipboard (Home -> Clipboard)
    2. Copy the data (do not cut them). You will see the data just copied in the clipboard
    3. Delete the data
    4. Paste the data from the clipboard

    Please let me know if this works for you.

    Ciao

    Ugo

    2 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-12-11T05:57:55+00:00

    Ok. That's right Jason.

    But, I have other users of this worksheet and I can not prevent someone to use the cut method (directly) or by selecting some cells and move them. I was wondering if there is a way to avoid the automatic cell formatting after the cut and past event?

    Tks,

    Kennedy

    0 comments
  2. Anonymous
    2017-12-11T05:56:18+00:00

    There are a lot of other users of this worksheet and I can not prevent someone to use the cut method (directly) or by selecting some cells and move them. I was wondering if there is a way to avoid the automatic cell formatting after the cut and past event?

    Tks,

    Kennedy

    0 comments
  3. Anonymous
    2017-12-11T01:17:21+00:00

    If you cut a cell rather than copy, it will remove any formatting/etc from the original cell. Instead of cutting and pasting, you should copy and paste the cell.

    0 comments
  4. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2017-12-11T00:03:29+00:00

    I want to have a look at the data validation window of the cell which you are cutting. Please post a screen shot of data validation window.

    0 comments