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
  • I need to create an Excel file where the first column of every row should be a fixed text string.
  • This column should not be editable.

The reason for this requirement is that the user can save this file as a csv file, which can then be used as input for a software. That software requires the first column to be set to a constant text string.

share|improve this question

It's a while since I locked a s/sheet for real, but I believe the secret is that all cells are by default locked. This has no effect until the sheet is locked. So first unlock all cells, then select and lock your first column cells and finally lock the sheet. The users can now add data to the unlocked cells.

Not sure exactly what you are expecting the users to do, but you should be able to just allow them access to a few columns, and lock the rest.

Search for "password protect excel cells" and there are tutorials around if you need more detailed instructions.

share|improve this answer
    
After locking the sheet will the users will be able to add more rows? – AppleGrew May 29 '12 at 16:29

You must log in to answer this question.

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