Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
    
What version of Excel? Would everyone be using Excel with macros? –  Canadian Luke Apr 29 '13 at 23:30
add comment

1 Answer

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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