Copy and paste in a protected worksheet

When you protect a worksheet, Excel locks all cells by default, which means you won’t be able to paste anything you copy in that protected sheet. For anyone to be able to copy and paste in a protected worksheet, you need to remove the sheet protection, unlock all cells, lock only those you don’t want to be changed or removed, and then protect the worksheet again. Here’s how:

  1. If the worksheet you want to change is protected, click Review > Unprotect Sheet.

Type a password if prompted, and click OK.

Unprotect Sheet

  1. Click the Select All button to select the entire worksheet you want to protect.

Select All button on the worksheet

  1. Press Ctrl+Shift+F.

  2. On the Protection tab, uncheck the Locked box, and click OK.

  3. On the worksheet, select the cells you want to lock.

  4. Press Ctrl+Shift+F again.

  5. On the Protection tab, check the Locked box, and click OK.

  6. To protect the sheet, click Review > Protect Sheet.

Protect Sheet

  1. Enter a password if you want to prevent other people from unprotecting the sheet, repeat that password, and click OK.

You should be able to paste the cell contents you copy in any unlocked cell on your worksheet.

Tip:  If you don’t want to unlock all cells on your worksheet, or if you don’t have the password to unprotect the worksheet, you can try copying and pasting all of the data from the protected worksheet to a new worksheet.

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?