title: In Google Sheets how to reference infinite rows in column?
body: <p>If I want to reference a span of rows I can do something like <code>A1:A100</code>. If I want to lock the column/row I can use <code>$</code>; <code>$A1:$A100</code>.</p>
  
  <p>Is there notation or a symbol that represents an <em>infinite</em> range, or every row that could possibly be in a column?</p>
  
  <p>Something like <code>$A!</code> or whatever?</p>