Upload

Loading...

Allow Users to Change Cells in Protected Excel Worksheet

14,477

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Aug 14, 2010

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.

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up Next


to add this to Watch Later

Add to

Loading playlists...