Question: how to copy formula from protected excel sheet?
Answer: Press Ctrl + C to copy the selected cells. Create a new sheet in the current workbook or in a different workbook (to create a new Excel file, simply press Ctrl + N). In the new blank worksheet, place the cursor in A1 and press Ctrl + V to paste the contents of the password-protected sheet.