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.