title: Google Spreadsheet range names
body: <p>In Google Docs Spreadsheets, one can use <a href="http://docs.google.com/support/bin/answer.py?answer=63175&amp;cbid=-1586dzdl3v9vb&amp;src=cb&amp;lev=answer" rel="noreferrer">Range Names</a> to put labels on ranges of cells to make formulas more legible.  In most formulas, one can use the range C:C to denote the entire C column, and C2:C to denote the entire C column after and including C2.</p>
  
  <p>Is there a way to create range names of the same nature?  When I try C:C or C2:C or Sheet!C:C or 'Sheet'!C:C I always get the error "The range you specified is not in a valid range format."  I would like the range name to expand as my form adds rows to my spreadsheet.  Thanks.</p>