How to Password protect the cells in range D4:D15 using cengage as the password. In excel
To password protect the cells in range D4:D15 in Excel, you can follow these steps:
1. Select the range of cells D4:D15 that you want to protect.
2. Right-click on the selected range and choose "Format Cells" from the menu.
3. In the Format Cells dialog box, go to the "Protection" tab.
4. Check the box next to "Locked" to lock the cells in the range D4:D15.
5. Click OK to close the Format Cells dialog box.
6. Next, go to the "Review" tab in the Excel ribbon.
7. Click on "Protect Sheet" to open the Protect Sheet dialog box.
8. In the Protect Sheet dialog box, enter the password "cengage" in the Password box.
9. You can also choose additional options for protecting the sheet, such as allowing or restricting certain actions.
10. Click OK to protect the sheet with the password.
Now, the cells in range D4:D15 are protected with the password "cengage". Users will need to enter this password to unlock and make changes to these cells.