I don't know whether or not this thread was meant for suggestions, but I have a few ideas I'd incorporate in a better gear list spreadsheet than my own.
Using the ability to hide columns, or exploiting a wide monitor, allow several columns for: short name; longer description; comments in wrapping text; ability to add extra columns for size, price, volume (cc and in^3), place purchased, URL, etc. My memory isn't what it was.
Three columns for weight: grams, ounces, pounds#ounces. Entering a value in any field fills in the others.
At least one level of grouped consolidation (outlining). This would allow keeping clothing separate from cooking gear, but would also allow something like "first aid kid" to have a detailed list of contents but be closed up and selectable as a whole. A hierarchy of levels would allow "first aid kit" to be included within the group "ten essentials", along with other related items and groups.
A "default" quantity column. For example, (2) butterfly bandages in the first aid kit.
Multiple columns on the far right, easily extended, for making favorite packing lists, lists used for specific hikes, etc. Perhaps the column would simply be the quantity of items desired or taken (which is multiplied by the 'default' quantity when calculating weight). There should be a commentary entry somewhere for that list beyond the short column title for details of the hike, neccessity (or not) of gear taken, etc.
Reporting: ability to print a packing list without extraneous details (price, other packing list columns) and non-selected items.
Totals, of course, for weights of selected gear. Maybe total the price and volume columns, too.
Ability to sort on various columns without losing the original preferred ordering.