When you are trying to copy and paste some data by dragging and dropping in a cell in Excel 2003 workbook, then you may face this issue. You may not be able to delete the cell and Excel 2003 will notify you that the cells are password protected. The same issue will pop up when you are trying to edit multiple cells in a worksheet and this error message will pop up stating that “Some of the cells you are trying to change are password protected”.

Such error messages may occur in various scenarios such as when you are working with a worksheet which is password protected. This error message is also likely when you are trying to edit multiple cells simultaneously. If you are trying to edit a set of multiple cells in a worksheet which are protected with a password, then Excel 2003 will show this error message.

Are you looking for a quick DIY guide to fix the error message “Some of the cells you are trying to change are password protected” when you try to edit multiple cells in a protected worksheet by using a single password in Excel? Then follow these steps given below.

  1. Open Excel file
  2. Double-click one of the cells in the range of cells that you want to edit.
  3. Click ‘OK’ on the pop up window
  4. Click ‘Tools’ and go to ‘Protection
  5. Click ‘Unprotect Sheet
  6. When you are prompted, type the appropriate password, and then click ‘OK’.
  7. Perform the operation that caused the error message again.

Isn’t it easy to follow these steps to resolve the error “Some of the cells you are trying to change are password protected” while editing on Excel 2003?