Table doesn't propagate formulas or formatting

[JenniferMurphy]

In this table, the cell formulas and formats are not applied to all of the cells in a new row.

Eggs, boiled, log (MrExcel).xlsx
	B	C	D	E	F	G	H	I
8	Stop	Start	Days	#	Wt	Ea	Temp	Time
9	12/20/21	12/09/21	11	4	277	69	67°	7:57
10	12/20/21	12/09/21	11	4	285	71	69°	8:36
11	12/27/21	12/22/21	5	4	284	71	60°	10:44
12	12/27/21	12/27/21	1/00/00	6	325	54.17	55°	0°
MrExcel

Cell Formulas
Range	Formula
D9:D11	D9	=[@Stop]-[@Start]
D12	D12	=[@Start]-[@Stop]
G9:G12	G9	=[@Wt]/[@['#]]

I added the 4th row by tabbing out of the last Time cell (I11).

1. The new Days cell (D12) has the wrong formula and formatting.
2. The new Wt cell (F12) has the wrong justification.
3. The new Ea cell (G12) has the correct formula, but wrong formatting.
4. The new Time cell (I12) has the wrong formatting. If I copy the formatting from the cell above, it goves the correct result.
5. The other new cells are correct.

Can anyone explain why some of the new cells acquire the correct formulas and formatting, but others don't?

I did change some of the formulas and formats, but I copied the new settings to the entire columns.

 

[Alex Blakenburg]

When you copied the new setting to the "entire column" did you copy it to just the table column as opposed to the sheet column ?
Its effectively a table property and it will only be treated as such if you only select the Table Column as opposed to the whole sheet column.

This is an excellent reference by Jon Acampora it says formatting but applies to formulas as well:
Why Excel Table Number Formatting Doesn't Copy Down and How to Fix It

 

[JenniferMurphy]

When you copied the new setting to the "entire column" did you copy it to just the table column as opposed to the sheet column ?
Its effectively a table property and it will only be treated as such if you only select the Table Column as opposed to the whole sheet column.

This is an excellent reference by Jon Acampora it says formatting but applies to formulas as well:
Why Excel Table Number Formatting Doesn't Copy Down and How to Fix It

That fixed the problem. I thought I did that, but obviously not.

Thanks

 

[Alex Blakenburg]

Thanks for letting me know. Glad it was a straightforward fix.