Inserting row containing same cells formula of other rows

**Khaldon** · 05-10-2011, 03:20 PM

I need please help in how to insert a new row that contains same cell formulas as of proceeding and subsequently row, the normal way will insert an empty row, and formulas has to be copied manually to the newly inserted row?

**ChemistB** · 05-10-2011, 03:36 PM

One way is to set your data up as a table. (Insert>Table). Is that feasible?

**Khaldon** · 05-10-2011, 03:54 PM

Unfortunately that is not feasible, I already have a work sheet established, and inserting a table as a row will create a table header even if my table has a header option was checked,

**ChemistB** · 05-10-2011, 05:01 PM

In Excel 2007, if you have selected a cell in your existing data and you click on Insert Table, it creates a table (in 2003, it was called a List) of your existing data. You can reformat the colors to emulate your previous setup. Then when you insert a row, all formulas and formats are automatically assigned to the new row.

**Khaldon** · 05-11-2011, 02:39 AM

My Excel is 2007, I have selected a cell in my existing data and clicked on Insert Table, it did created a table of my existing data. However two things happened a kind of drop down list were created adjacent to each column of my table header which I do not desire, and when I inserted a new row only formats were automatically assigned to the new row no formulas were assigned to the new row!

**ericequip** · 06-01-2011, 02:06 PM

I have the same problem. I have a series of rows and I insert just above the last one to copy the data validation and conditional formating to the inserted row. But in some columns, I have a series of formulas that do not copy to the newly inserted row. And as Khaldon, I did not set it up as a table, and already have all my formatting with headers, etc. Any ideas would be greatly appreciated. Thanks in advance.