Home ---- ------ Contact

Microsoft-Excel 2007 Study Material Day-Thirty Six

Review Tab : 

Changes Group :

Protect Sheet : 
Prevent unwanted changes to the data in a sheet by specifying what information can be changed. For example, you can prevent people from editing locked cells or changing the formatting of the document. You can specify a password that can be entered to unprotect the sheet and allow these changes.

 Protect Workbook :
 Prevent unwanted changes to the structure of the workbook, such as moving, deleting, or adding sheets. You can specify a password that can be entered to unprotected the workbook and allow these changes.

Share Workbook :
 Allow multiple people to work in a workbook at the same time. The workbook should be saved to a network location where multiple people can open it. Workbooks containing tables cannot be shared.

Protect and Share Workbook :
Share the workbook and protect it with a password at the same time. The password will prevent others from turning off change tracking.

Allow Users to Edit Ranges :
Allows specific people to edit ranges of cells in a protected workbook or sheet. Before using this feature, first set security on the sheet by using the Protect Sheet command. To use this feature, your computer must be joined to a Microsoft Windows domain.

Track Changes :
 Track all changes made to the document, including insertions, deletions, and formatting changes.