I have a spreadsheet with several columns that use array formulas, specifically referencing other columns of data. I started off using the A$1:A$100 syntax (if 100 was the last row of data in the spreadsheet), but found that this was rather time consuming if I ended up adding more rows of data since I have several columns like this. I have also used the column A:A syntax, but it seems to be cumbersome (i.e. it takes a while to calculate), since it's referencing the entire column of data.
Is this the cleanest approach to avoid having to change the formulas whenever I add new rows of data?