Hi All
I have a table from columns A to Q are for users' manual input. There are formulas from columns R to AC. I need to protect the formulas from columns R to AC starting from row 5 to row 28. I learnt I can use protect sheet and to allow insert row, however once a row is inserted the formulas from R to AC do not add in automatically. I wonder is there a way that formulas can be protected but users can insert rows and the formulas will automatically updated in the new rows? Thanks.
I have a table from columns A to Q are for users' manual input. There are formulas from columns R to AC. I need to protect the formulas from columns R to AC starting from row 5 to row 28. I learnt I can use protect sheet and to allow insert row, however once a row is inserted the formulas from R to AC do not add in automatically. I wonder is there a way that formulas can be protected but users can insert rows and the formulas will automatically updated in the new rows? Thanks.
