Search code examples
excelexcel-formularange

Specifying range from A2 till infinity (NO VBA)

Without VBA, I am trying to refer a range that starts at A2 and never ends. For example, if I want row 2 till row 5 i'd do

$A$2:$A$5

But what if I want the end to be open? 

$A$2:??

Is this possible?

Solution

  • Depending on what's in A1 and what formula you're putting the reference into, you could simply use A:A. For example, if you wanted to sum all of the values in column A, but A1 contained a column title rather than a number, you could still write =SUM(A:A) and the title in A1 would just be ignored.