I need to lock certain cells in a chart however I also need to be able to insert rows into this same chart. Is this possible.
Example:
<tbody>
</tbody>
Take this chart as an example. I have locked the price cell as it contains a formula I do not want changed. I need to be able to copy the row (formulas included) and insert additional lines. It seems I cannot this when I lock the price cell. I hope this makes sense. Help please!
Example:
Item | Qty | Price |
Stapler | 2 | $50 |
<tbody>
</tbody>
Take this chart as an example. I have locked the price cell as it contains a formula I do not want changed. I need to be able to copy the row (formulas included) and insert additional lines. It seems I cannot this when I lock the price cell. I hope this makes sense. Help please!