Hi,
I am having some trouble using the quick formatting options in excel 2007. Basically I have created a very simple table, and wanted to add the zebra stripped table layout with headings using the inbuilt features.

I select my range of the table, then do the following
Home > Format as Table > My table has headers

The result looks ok, but there are drop down menus (For a filter I believe) in my header row and excel takes it upon itself to rename my headers.

ie the first 3 columns for example:

Category Category Category

becomes

Category Category2 Category3


Is there anyway to use excel to just format the cells without adding any of this unnecessary functionality?


Thank You

Regards Elbarto