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.

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

2 Answers 2

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

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.