title: How to insert or delete rows in individually locked cells in excel 2016?
body: <p>In my excel list I locked some cells. And want to able insert or delete rows.
  <a href="https://i.stack.imgur.com/LH2Jl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LH2Jl.jpg" alt="lock with this options" /></a>
  Rows and column by name &quot;Total&quot;  contain formulas. when I insert a row and add values into cells, cells in &quot;Total&quot; row work well, but  cells in &quot;Total&quot; column don't calculate and could not delete newly inserted row.
  <a href="https://i.stack.imgur.com/eTOig.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eTOig.jpg" alt="could not delete row and H4 cell is not calculated" /></a></p>
  <p>Please help me
  I want to protect colored cells, able to add or remove rows, that formulas works correctly.
  Thanks in advance</p>