Allow Users to Change Cells in Protected Excel Worksheet

http://www.contextures.com/xlfaqApp.h... When you protect a worksheet, by default, all the cells on that sheet are locked, and users can't make any changes.

In some worksheets, you might want to allow users to make changes in specific cells, while keeping the rest of the worksheet locked.

For example, in a data entry sheet, you could allow users to enter a date, select a product from a drop down list, and enter a quantity sold. However, you can block them from changing any of the heading cells, or cells that contain a formula.

Watch this short video to see the steps for allowing some cells to be changed on a protected Excel sheet.

• Category

  Science & Technology

[Tiffany Tan]

Awesome. I'm looking for this so long. This video teach the best way~

[w33dp0w3r]

awsome ! i was looking for this for a long time ... it was too simple to get it .:D

[Stefffanos]

thanks! very helpful