How to record macro of formatting tables in Excel 2010?

Posted by GIS Man on Super User See other posts from Super User or by GIS Man
Published on 2013-07-02T10:03:28Z Indexed on 2013/07/02 11:08 UTC
Read the original article Hit count: 245

Filed under:
|

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!

© Super User or respective owner

Related posts about microsoft-excel

Related posts about macros