I'm working with Excel 2010 and made over 20 tables in one sheet. I just want to work more efficiently by making a simple macro for auto formatting table. This is the style I want to apply with the macro:
- Font: 10, Bold, Arial
- Borders: All borders
- Text: Center
- Table: 3*5 (row * column)
- Cell tile for header table only (any colors)
- I've uploaded a sample table with that style, if my question is not clear enough.
Thanks for any help!