How to reference all cells from a cell to the very bottom and right in Google Sheets?

Issue

I know you can reference cells in these ways:

Address Explanation
A1 The cell at A1
A2:A All rows in column A starting from row 2
B1:1 All columns in row 1 starting from column B

What I can’t find it how to reference all rows and columns starting at B2. Is that possible?

I am not opposed to using a formula but would prefer not to.

Solution

there are several ways one of wich is:

=INDIRECT("B2:"&ADDRESS(ROWS(A:A), COLUMNS(1:1))) 

or:

=OFFSET(B2,,,9^9,9^9)

Answered By – player0

Answer Checked By – Mildred Charles (AngularFixing Admin)

Leave a Reply

Your email address will not be published.