Excel 2007 : Reusing Custom Table Styles

[kcmills]

I'm interning with a company and have to update 50 workbooks of data. I created some custom table styles to speed the process up, but I can only use them in the workbook I created them in. How can I transfer the custom styles to another workbook?

Also, when creating custom tables I am unable to format fonts beyond color, underlining, and bold/italic/etc. Is there a way to format the font style and size within a custom table?

I'm using Excel 2007.

Thanks in advance.

[codywohlers]

Yeah I would also like to know how to change the font for a new table style as well. It's all grey-ed out in the format dialog box...

[codywohlers]

Found a workaround / cause. The cell font size and type is dictated by the cell style (not the table style). Just change your "Normal" cell style font and the table will respect it. (Home -> Styles)