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
Bookmarks