Now you should have all 4 ranges listed in the Allow Users to Edit Ranges dialog box and you’re ready to protect the sheet.

This will insert a comma between each range. Tip: You can set non-contiguous ranges, just select the first range > hold down CTRL and select the next range and so on.

Rinse & Repeat for regions South, East and West using different passwords for each (assuming a different user will input each region).

Click on ‘New’ to set up your first range for North, which will be cells C3:C14 and enter your password:.

Go to the Review tab in the Changes group > Click on Allow Users to Edit Ranges button.

I’ll demonstrate using these 4 regions where each region will have a different user enter the data: Or, if you work on a network drive you can simply grant users permission to a specific range so they don’t have to enter the password. Let’s say you have several different users of a workbook and you want to restrict each user’s editing rights to a specific range (knowing this would have been handy when I used to collate budget and forecast data from department managers), you can give them their own password which only unprotects the section they’re allowed to work on. It’s called Allow Users to Edit Ranges and you’ll find it on the Review tab in the Changes group:

Excel for Decision Making Under Uncertainty Courseĭid you know you can set different passwords to protect specific ranges of your Excel worksheets?.Excel for Customer Service Professionals.

How to put password in excel sheet