Excel Cut and paste

  • Thread starter Thread starter RD
  • Start date Start date
R

RD

I have a excel file that I need to block the user from using the cut option
while in adding data to this file....Any ideas on how to do this?
 
I have a excel file that I need to block the user from using the cut option
while in adding data to this file....Any ideas on how to do this?
Click to expand...

Tell the user not to use the cut function, why would the user need to
use it?
 
Assumed data in range A1:A10 ( extend according to your need )

Ctrl + A | Ctrl + 1 | protection tab | uncheck locked & hidden option
| Ok

select the range A1:A10 | Ctrl + 1 | protection tab | check locked
option | Ok

Now go to tools | protection | protect sheet | password (optional) |
ok

Now only copy function will be available.
 
Back
Top