Hi Folks,
Brand new to the forum which I have joined as my job requires me to get deeper into Excel. Not quite a newb but I would appreciate if anyone can tell me if th efollowing is possible:
I create a Table in Excel 2010 using the Format as Table option.
I then Protect the WorkSheet as a couple of columns are used to Authorise work and only these need protection and are 'locked' - all other cells in the Table are unlocked but cells outside of the table are locked as well.

However when tabbing through the Table it will not create a new row. This sort of makes sense but is there any way to do this as I need to create a few more spreadsheets in this way and using the Table option helps others with inputting while I can also validate and protect areas on it.