Depending on the version of excel, you may find that:
tools|options|Edit tab|Check Extend data range formats and formulas

Or you could use a macro to insert rows.

David McRitchie has one:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

cjupiter wrote:

I am relatively new to excel.

Im developing a quoting tool using excel that consists of a number of drop
down lists. What i want to do is when i select something from a drop down
list, a new row will automatically be inserted underneath my selection. This
feature will give me the option to continue adding entries without having to
insert rows manually.

Also, when a new row is inserted, i would like all the formulas associated
with the previous row to be preserved in the new row.

Any help is greatly appreciated.

--

Dave Peterson