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!