How to update table column properties?

[JenniferMurphy]

Thanks to several suggestions here, I am a total convert to tables. Except for one thing. I cannot figure out to change the "properties" of a column. The table below does some calculations on compostable trash bags. As usually happens, after I initially created the table, I learned things that caused me to change the formulas or formatting of some of the columns. But these changes are not adopted by the table. I cannot seem to change either the formatting or the formulas so that new rows will assume those properties. Do I need to delete the old columns and create new ones?

The M$FT website says to right-click the table and select Table Properties. If I do that, I do not see a Table Properties option.

In this table, I just added row 9 as a test. As you can see from the Formulas section, several cells in row 9 have completely different formulas from rows 5:8. They also have different formatting. I have repeatedly selected the first row and copied the formatting to the entire table. Doesn't help. I have done the same with the formulas, to no avail.

What do I need to do to get new rows to assume all of the "properties" (formulas and formatting) of the other rows?

Kitchen Scrap Bins.xlsx
	B	C	D	E	F	G	H	I	J	K	L
2	Closure	2.0"
3
4	Brand	Price	#Bags	$/100	Handle	Gals	Wid	Len1	Len2	in^3	Gal
5	Aneco	$38.29	100	$38.29	0"	2.6	16.30"	16.50"	16.50"	537	2.32
6	Superbio	$21.95	100	$21.95	5"	2.6	16.30"	22.00"	17.00"	579	2.51
7	Superbio	$35.12	200	$17.56	5"	2.6	16.30"	22.00"	17.00"	579	2.51
8	Superbio	$13.95	100	$13.95	0"	2.6	16.30"	16.50"	16.50"	537	2.32
9	Test	$15.00	100	$15.00	0	2.60	1.13"	16.50"		17	123.43
MrExcel

Cell Formulas
Range	Formula
I5	I5	=16.5
K5:K8	K5	= ([@Wid]^2)/PI() * ([@Len2] - ([@Wid]/2) - Closure)
L5:L8	L5	=CONVERT([@[in^3]],"in^3","gal")
K9	K9	=(([@Wid]/2)^2)*PI()*[@Len1]
L9	L9	=CONVERT(K9,"ft^3","gal")
J5:J8	J5	=[@Len1]-[@Handle]
I8:I9	I8	=16.5-[@Handle]
E5:E9	E5	=[@Price]/[@['#Bags]]*100
H9	H9	=2*SQRT(1/PI())

Named Ranges
Name	Refers To	Cells
Closure	=MrExcel!$C$2	K5:K8

 

[jaeiow]

You have to play around with the autofill handle. Drag to top, pull to bottom, double click, things like that.