Excel equivalent of Google Sheets Range A2:A

Question

Is there an Excel equivalent for Google's A2:A other than A2:A1048576, i.e. without specifying the last row number explicitly and keeping the formula as concise as possible?

Answer 1

in excel you can use:

A2:INDEX(A:A, MATCH("ZZZ", A:A))