|  

» Allowing Multiple Users to Edit Specified Ranges in Excel 2007

CATEGORY - Excel Editing VERSION - Microsoft Excel 2007
To allow users to edit only specific ranges when working in a shared workbook:

Select Review -> Allow Users to Edit Ranges (in Changes Group).

This advanced option allows multiple users (for example, when working on a network) to update data in a well defined and private area. Each workbook user is allotted a range in the sheet with a unique password.
Screenshot // Allowing Multiple Users to Edit Specified Ranges in Excel 2007
Allowing Multiple Users to Edit Specified Ranges in Excel 2007


Rate This Tip
12 34 5
Rating: 1.00     Views: 3819
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments