3 ms·

Doesn't help. The point is Excel doesn't know what range I want when I extend my table, not whether I can give the range a name or not.

• ecommercematt 18y ago
  Am I missing something, or wouldn't =sum(C:C) work?
  • CatDancer 18y ago
    Would that sum the entire column in the spreadsheet? But what if I wanted to have a couple tables on a page (which I often do), or my sum below the numbers?
    • whatusername 18y ago
      see my post above. if you use insert row - then formulas respond and will go from C2:C10 to C2:C11 (tested in excel2003 at least)
      • sctb 18y ago
        This is probably useful in many cases, but one could imagine where the inserted row bisects other ranges in other columns unintentionally.