How to update table column properties?

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
2,485
Office Version
  1. 365
Platform
  1. Windows
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
BCDEFGHIJKL
2Closure 2.0"
3
4BrandPrice#Bags$/100HandleGalsWidLen1Len2in^3Gal
5Aneco$38.29100$38.290"2.616.30"16.50"16.50"5372.32
6Superbio$21.95100$21.955"2.616.30"22.00"17.00"5792.51
7Superbio$35.12200$17.565"2.616.30"22.00"17.00"5792.51
8Superbio$13.95100$13.950"2.616.30"16.50"16.50"5372.32
9Test$15.00100$15.0002.601.13"16.50"17123.43
MrExcel
Cell Formulas
RangeFormula
I5I5=16.5
K5:K8K5= ([@Wid]^2)/PI() * ([@Len2] - ([@Wid]/2) - Closure)
L5:L8L5=CONVERT([@[in^3]],"in^3","gal")
K9K9=(([@Wid]/2)^2)*PI()*[@Len1]
L9L9=CONVERT(K9,"ft^3","gal")
J5:J8J5=[@Len1]-[@Handle]
I8:I9I8=16.5-[@Handle]
E5:E9E5=[@Price]/[@['#Bags]]*100
H9H9=2*SQRT(1/PI())
Named Ranges
NameRefers ToCells
Closure=MrExcel!$C$2K5:K8
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
You have to play around with the autofill handle. Drag to top, pull to bottom, double click, things like that.
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top