Question: how to copy and paste from a protected excel sheet?
Answer: Press Ctrl+Shift+F. On the Protection tab, uncheck the Locked box, and click OK. On the worksheet, select the cells you want to lock. Press Ctrl+Shift+F again. On the Protection tab, check the Locked box, and click OK. To protect the sheet, click Review > Protect Sheet.