Allowing Multiple Users to Edit Ranges in Microsoft Excel

 

In this article, we will learn how we can allow multiple users to edit the ranges in Microsoft Excel.

From the Tools menu, select Protection, and then Allow Users to Edit Ranges.
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.

Let’s understand with an example to understand how we can follow the procedure.

  • Open the workbook.
  • Click on Protection tab.
  • Click on Allow Users to Edit Ranges under changes group.
  • “Allow users to Edit Ranges” dialog box will appear.

img1

  • Click on New.
  • You can write the title as per your need, and in the next tab, select the cell.
  • And then click on Permissions.

img2

img3

  • Where you can add the users whom you want to edit in data.
  • Click on Add.
  • Enter the object name and then click on OK.

img4

  • Repeat the last 2 steps to add the multiple users.

This is the way we can allow the multiple users to edit ranges in Microsoft Excel.



One thought on “Allowing Multiple Users to Edit Ranges in Microsoft Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>