Inserting New Rows

[pells]

I have a large worksheet with many records and calculated fields. I am trying to find a way of inserting a new row in my worksheet that will only copy the formulas and formats into a new row.

Using he normal insert new row inserts a blank row and copying and pasting into a new row copies everything from the copied row.

Does anyone know if its possible or a way of being able to insert a new row that just copies / inserts the formatting and formulas?

Many thanks for taking the time to read my post and any help/suggestions would be most appreciated.

 

[Marcol]

Have you considered making your data a List {pre-2007) or Table (2007 +)?
See this link
http://www.contextures.com/xlExcelTable01.html

 

[pells]

Have you considered making your data a List {pre-2007) or Table (2007 +)?
See this link
http://www.contextures.com/xlExcelTable01.html

Thanks for your suggestion but by converting into a table, how would this enable me to insert a new row that will just insert the formatting and formulas and no other data?

Many thanks.

 

[Marcol]

That is what "Tables" are designed to do, and more.

See this link, then select the specific task you need to perform.
http://office.microsoft.com/en-gb/excel-help/CH010102459.aspx