Adding additional rows for data entry

[Tom]

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

 

[Biff]

Put the formulas at the top of the columns. You can even use a Freeze Pane
just below the formula row so that the results of the formulas will always
be visible when you scroll down the page.

Biff