Insert row with a locked cell

R

Robert

I have a spreadsheet with multiple columns of data. Some of the columns
contain data that I want a user to be able to enter data in. There are other
columns that are formulas that derive a value based on the user entered data
in the other columns in that row. I want to protect the formula columns so I
have them locked. All other modifiable columns I've unlocked.

The problem is that once I set the protection accordingly I am unable to
insert a row even if I've checked the Insert Row allowable function when
setting the protection. Is it possible to insert a row that has a locked cell
in the row with protection set?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide columns based on row values 2
Multiple Numbers in a cell 3
Transpose to break up one long row to many? 2
Insert/ delete row in protected worksheet 7
Allowing row deletion in worksheet with locked cells 2
using the =page! feature to transpose a row to column 0

Top