Allowing users to edit ranges in excel

You can allow users to only edit certain cells, or ranges of cell in an excel, keeping the rest protected (See Protecting a worksheet in excel if you want to protect the whole sheet).

1. Tools -> Protection -> Allow Users to Edit Ranges














2. Click on New















3. Give appropriate title for the range, and define the range

4. You can add several ranges using steps 2 & 3
5. Click OK

6. You'd come to the New-modify-delete form again, where you have the option of protecting the sheet. Click the button marked "Protect Sheet".
(remember, we have to protect the sheet so that only the defined ranges are editable)

7. You would be asked to provide a password, and confirm the same. Once you enter the passwords, you are all set !!