Thank you for your response.

I created this spreadsheet in 2003 - and just today opened it for the first
time in 2007 - so all the lists / tables were created in Excel 2003.

I do see where any formula in a previous row is auto-inserted into my new
row. That does work.

However, I have formulas outside of my list/table which refer to all the
rows in my list/table. And in 2003, those formulas would change to include
my new row. In 2007, I do not see those formulas adjusting to the presence
of my new row.

That's my main issue.

As for the little "corner arrow" - that doesn't meet my needs because I do
have data below my list/table that I do not want to include in my list/table.
If I use the "corner arrow", the table will now include that data. I want
the data below my table to stay below my table - to be moved down one row
when I insert a new row. Putting the cursor in the last column and hitting
TAB will move the data below down one, so does Right-Click and hitting
Insert-- Below.

"NBVC" wrote:

If you created the table properly through Insert|Table in 2007, then it
works similar to List in 2003

When you enter anything in a "text field" in the next row, the formulas
will auto-insert into the appropriate spots..

The only thing you don't see the * in the next row like you did in
2003, but you see the little "corner arrow" icon in the bottom right
corner of the table indicating that you can expand the table...