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 have a protected sheet that I've created that has tables which has some columns that I would like protected. However, I need the end user to retain the ability to insert rows into the table. How do I do this?

share|improve this question

When you protect the sheet if you check the option "Insert rows" does that not allow them to do what you want?

share|improve this answer
nope I have all of the options enabled and still no solution :( – Samuel Nov 15 '10 at 17:54

Lock or unlock specific areas of a protected worksheet:

When you protect a worksheet, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the worksheet. You can also enable specific users to edit specific ranges in a protected worksheet.

share|improve this answer

You must log in to answer this question.

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