Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .