Upload

Loading icon Loading...

This video is unavailable.

Allow Users to Change Cells in Protected Excel Worksheet

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like Contextures Inc.'s video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike Contextures Inc.'s video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add Contextures Inc.'s video to your playlist.

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 icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Advertisement
Loading...
Working...
Sign in to add this to Watch Later

Add to