Excel Cut and paste

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?
 
C

CurlyDave

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?
 
M

muddan madhu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Unable to insert cut rows into Excel online anymore? 0
Cut & Paste in Excel without erasing cell borders? 1
Automate Cut & Paste 2
Excel 2003-Insert Cut Cells 2
Cut last row and paste elsewhere 1
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Cut/Paste/Scrolling 1
My cut and paste to my web site, converts to text and not visual 3

Top