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


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.


there are several ways one of wich is:




Answered By – player0

Answer Checked By – Mildred Charles (AngularFixing Admin)

Leave a Reply

Your email address will not be published.