Data Validation auto expand in tables

Gerry1995

If I create a table in my spreadsheet, say range a1:d10 using Insert Table and then I add data the row 11 the table auto expands, which is great. However if I put data validation on one of the columns, say column C, can I get the data validation to also be included in the auto added row ?

Gerry1995

I should have mentioned this is excel 2007

Gerry1995

Anyone any clues on how I can do this. Tks

tommycahir

Hi Gerry

From my experience and according to MS (Link) the additional row should include the formatting

Autoexpansion If you add a row directly below the last row of a table or add a column directly to the right of a table, the table expands to incorporate the new row or column. All table styles, conditional formatting, calculations, and data validation rules extend to the new row or column. Charts based on data from the table also are similarly updated. Likewise, if you add a new column adjacent to the table, the new column is automatically incorporated into the table definition.

Maybe if you paste a sample xlsx file then I could have a look at it for you.