Share via

Prevent Copy-Paste from Excel Sheet without Macro

Anonymous
2020-08-05T11:46:30+00:00

Hi all,

Is there any way to disable Copy-Paste in excel sheet without macros keeping the cells editable?

For example:

I have a sheet with 5 Rows and 5 Columns where user can not copy-paste anything to the cells, he can enter values manually only.

Thanks.

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-05T11:53:54+00:00

    Go to Excel Options by clicking on File->Options and try by removing the circled checkboxes and let me know if it works.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-08-05T12:05:06+00:00

    Hi Nirmalendu78, I removed these check-boxes but still I am able to Copy-Paste into the file.

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-09-08T05:52:17+00:00

    Hi ArzooSingh，

    I'm writing to follow up on in this thread.

    And I’m sorry to convey that it is not available to prevent copy and paste from Excel Sheet.

    Moreover, I’d like to invite you to create a new idea in Excel UserVoice about preventing Copy-Paste from Excel Sheet without Macro. As it is actively monitored by related teams and many new features have been implemented from our customer's suggestions.

    Hope you understand and have a nice day!

    Best regards,

    May

    0 comments