Is there any shorthand syntax to express a range starting from a column down to the end of that column? In Google Sheets for example I could write A2:A, which would mean from cell A2 to the end of column A. I suppose I could write A2:A1048576 every time I want to sum to the end of a column (if I don’t know how many filled rows it will contain) but this seems quite inelegant.
Hello - No there is no such shorthand syntax.
Note The only special syntax is for referencing a whole column by e.g
A:A, but obviously this can’t be used within the same column without introducing a Cirular reference error.