When on the cell in the last column of my table, I can press tab and it creates a new row with formulas intact. I want to protect the formulas in the last 3 columns of the table and have users input data in the first 3 columns. When I protect the cells containing the formulas and tab from cell C1, it skip to cell A2 but does not create a new row within the table.

A1 B1 C1 D1 E1 F1
Input Input Input Formula Formula Formula

Is there a way to tab from cell C1 and have a new row automatically generate with formulas intact while also having the formulas protected?

Thanks in advance for any help!

BD