将区域与您的数据和公式一起使用表：

Make the area with your data and formulas a Table:

然后在下一行添加新信息将复制该表中该表中的所有公式。数据验证也将应用于新行，就像整列一样。这确实是Excel对您的数据更加智能。

Then adding new information in the next line will copy all formulas in that table for the new line. Data validation will also be applied for the new row as it was for the whole column. This is indeed Excel being smarter with your data.

不需要VBA ...

NO VBA required...