Protected Table Won't Autoexpand

[washburncincy]

One of the features I love about Excel tables is that as you complete a row of data and tab through, it will automatically expand to start the next row. Further, that doing this carries forward formulas and formatting to the newly added row. However, I am finding that if the sheet with the table is protected, this feature no longer functions.

I have an Excel file with a sheet that has formulas and formatting that I don't want changed by the users who simply enter the data. As such, I'd like to protect the sheet, but I want to keep the autoexpand functionality as these end-users seem to struggle with copying formulas correctly.

Is there any way to allow autoexpand of a table on a protected sheet without requiring the employment of VBA?

 

[hockeycoach]

I am using Excel 2016 and am encountering the exact same problem. I was "hopeful" that allowing "insert rows" in the "protect sheet" menu would have worked. But that was just wishful thinking. I know that Microsoft engineers were aware of this in the earlier versions of Excel, but son't know if they've made allowance for it in the 2016 version. Does anyone have any additional information?