How to record macro of formatting tables in Excel 2010?
- by GIS Man
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!