Is there a way to define a range with infinite row or column number in a spreadsheet program?

When defining a named range in a spreadsheet program, is there a way to define a range that covers for example A1:A[*infinity*], so I will be sure that the range will always include all rows, whether new rows are added to the sheet later?

For now I use A1:A999999 but maybe there's a better and more future proof way (I mean, who know's what'll happen to this sheet in a couple of hundred years?! ;) )

1

3 Answers

you should simply be able to use A:A if you are always starting from the first row

You might consider using a table, as they can auto-expand.

1

Here is an example of how a table addresses your question.

The range B3:C9 is a table created using "Insert Table" command. I left the default name "Table1." Cells E3 and E4 contain two versions of a formula that addresses the table by name, and a column by name. No cell references are used. If I added a new row to the bottom of the table simply by typing or copying, the definition of the table boundary would expand, and the formulas would recalculate.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy