Copy in Excel

CA. Sandeep Kumawat (CA) (341 Points)

06 June 2008  

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