I have a spreadsheet with five columns that I enter data to. I then
have a blank row at the bottom of these columns.  Below the blank row I
have several formulas pertaining to each row.  How do I add more data
to the columns and have the formulas adjust for these new rows without
highlighting rows and using the insert rows command to make room (empty
rows) where I can then add the additional data to the columns.  Is
there a formula that would always leave one empty row even when new
data is entered in the columns?

Thanks