[FIXED] 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 - Robin (PHPFixing Admin)