I have a few similar spreadsheets I use for general reference and coin shows and another one for the eBay deals thread when there are eBay bucks offers. You can do tables on this forum, but I have been unable to make them dynamic......

[TABLE="class: grid, width: 589"]

[TR]

[TD]Denomination[/TD]

[TD]Years Minted[/TD]

[TD]Gross Weight[/TD]

[TD]Fineness[/TD]

[TD]Net Gold[/TD]

[TD]Gold Weight[/TD]

[TD] $1,284.70[/TD]

[/TR]

[TR]

[TD]UNITED STATES[/TD]

[TD][/TD]

[TD]Grams[/TD]

[TD][/TD]

[TD]Weight Grams[/TD]

[TD]Troy Ounces[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]50 Dollars[/TD]

[TD]1915[/TD]

[TD]83.592[/TD]

[TD]0.9[/TD]

[TD]75.2328[/TD]

[TD]2.4188[/TD]

[TD] $3,107.43

[/TD]

[/TR]

[TR]

[TD]20 Dollars[/TD]

[TD]1850-1933[/TD]

[TD]33.437[/TD]

[TD]0.9[/TD]

[TD]30.0933[/TD]

[TD]0.9675[/TD]

[TD] $1,242.95[/TD]

[/TR]

[TR]

[TD]10 Dollars[/TD]

[TD]1795-1804[/TD]

[TD]17.4957[/TD]

[TD]0.9167[/TD]

[TD]16.0377[/TD]

[TD]0.5156[/TD]

[TD] $662.39[/TD]

[/TR]

[TR]

[TD]10 Dollars[/TD]

[TD]1838-1933[/TD]

[TD]16.7185[/TD]

[TD]0.9[/TD]

[TD]15.0467[/TD]

[TD]0.4838[/TD]

[TD] $621.54[/TD]

[/TR]

[TR]

[TD]5 Dollars[/TD]

[TD]1795-1833[/TD]

[TD]8.748[/TD]

[TD]0.9167[/TD]

[TD]8.019[/TD]

[TD]0.2578[/TD]

[TD] $331.20[/TD]

[/TR]

[TR]

[TD]5 Dollars[/TD]

[TD]1834-1836[/TD]

[TD]8.3592[/TD]

[TD]0.8993[/TD]

[TD]7.5174[/TD]

[TD]0.2417[/TD]

[TD] $310.51[/TD]

[/TR]

[TR]

[TD]5 Dollars[/TD]

[TD]1837-1929[/TD]

[TD]8.3592[/TD]

[TD]0.9[/TD]

[TD]7.5233[/TD]

[TD]0.2419[/TD]

[TD] $310.77[/TD]

[/TR]

[TR]

[TD]4 Dollars[/TD]

[TD]1879-1880[/TD]

[TD]6.6872[/TD]

[TD]0.9[/TD]

[TD]6.0185[/TD]

[TD]0.1935[/TD]

[TD] $248.59[/TD]

[/TR]

[TR]

[TD]3.0 Dollars[/TD]

[TD]1854-1889[/TD]

[TD]5.0154[/TD]

[TD]0.9[/TD]

[TD]4.5139[/TD]

[TD]0.1451[/TD]

[TD] $186.41[/TD]

[/TR]

[TR]

[TD]2.5 Dollars[/TD]

[TD]1796-1833[/TD]

[TD]4.374[/TD]

[TD]0.9167[/TD]

[TD]4.0095[/TD]

[TD]0.1289[/TD]

[TD] $165.60[/TD]

[/TR]

[TR]

[TD]2.5 Dollars[/TD]

[TD]1834-1836[/TD]

[TD]4.1796[/TD]

[TD]0.9[/TD]

[TD]3.7616[/TD]

[TD]0.1209[/TD]

[TD] $155.32[/TD]

[/TR]

[TR]

[TD]2.5 Dollars[/TD]

[TD]1837-1929[/TD]

[TD]4.1796[/TD]

[TD]0.9[/TD]

[TD]3.7616[/TD]

[TD]0.1209[/TD]

[TD] $155.32[/TD]

[/TR]

[TR]

[TD]1.0 Dollar[/TD]

[TD]1849-1889[/TD]

[TD]1.6718[/TD]

[TD]0.9[/TD]

[TD]1.5046[/TD]

[TD]0.0484[/TD]

[TD] $62.18[/TD]

[/TR]

[/TABLE]

Go advanced, copy and paste your data in from Excel. Highlight the data pasted, click Table Properties, choose full grid under table style if so desired. The alignment option seems to only move the entire table left, center or right, not the data in each field. Align your data in Excel before copying (still doesn't always carry over). You can insert working links as well, as I do in the eBay thread for a quick link to the deal on each coin......