when I add a row to my table the formulas above it don't auto-fill.. does anyone know why?

Is the worksheet protected?

Regards, TMS

I suggest that:

a) for each column with a formula, select the first cell in the column and drag the formula down to the last row in the Table
b) in Design mode, check the size of the Table and make sure it includes all the rows Design | Properties | Resize Table ... just make sure it selects the whole Table

Have you changed any entries in the column(s) with formulae? If you have put any text values in, replacing the formula, that might change the way it works ... but that's more of a guess than anything.

Also note that, if you select a row in the Table and press the Delete key, it will delete the contents of the cells but not the row. To delete rows in the Table, it is best to use the Delete icon on the Ribbon. This is especially true on the last row of the Table.

Just some ideas and thoughts ... I'm afraid no guarantee.

If the problem continues, you would be well advised to upload a sample workbook.

Regards, TMS

Yep. The core of any Table is the Header Row and the First row of data. And you should not have any blank rows in a Table, no matter how pretty it looks. From my understanding, the first row is where Excel keeps track of the formula and formatting for each column.

If some formulae are repeating, I suspect that's because Excel will do that anyway if it recognises a pattern, that is, repetition of data and formulae in preceding rows.

Regards, TMS