Copy in Excel

Excel 1272 views 1 replies

I read the query on protecting copying in excel

 

here is the solution

 

do like this

1 select whole sheet right click & uncheck locked cells under protection tab

2 now select the text which u dont want to get copied and right click and check locked cells as above

3 now do this "Tools ---> Protection -----> Protect Sheet" and uncheck all exception and click ok

if u want to protect copying whole sheet u can acoid step 1 & 2 & follow step 3

for details write to vinayak2208 @ gmail.com

Sandeep K

Replies (1)

Thanks..Sandeep..It is really a fruit ful info...Thanks Again.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register