Can individual columns be password protected for separate people, so that others can view information but only change data in their column?

  • What version of Excel? Would everyone be using Excel with macros? – Canadian Luke Apr 29 '13 at 23:30

Yes. You need to be connected to an Active Directory domain. Then you can select a range and go Review > Allow Users to Edit Ranges.

enter image description here

Click the New button and set a password

enter image description here

Click the Permissions button and then add users or groups from your domain address book

enter image description here

As with all other cell protection, this only applies after the sheet is protected.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.