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...
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?! ;) )
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.
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.
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
