Excel VBA Macro #10 – Instantly Apply Table Formatting with One Click
This macro automatically formats raw Excel data (borders, font styles, colors, and alignments) to create a clean and professional layout.
It’s designed to save time when preparing reports or aligning large data tables for presentation.
| File | Description |
|---|---|
1.Auto_Format.bas |
VBA module that applies consistent formatting (borders, fonts, alignment, and color scheme) |
2.Auto_Format_Demo.xlsm |
Demo workbook to test and preview the macro |
3.Auto_Format_Readme.md |
Detailed explanation and usage guide |
4.Auto_Format_Screenshot.png |
Screenshot showing before/after formatting results |
- Select a range of unformatted data.
- Run the macro from the Developer tab or shortcut key.
- The macro applies:
- Bold headers
- Alternating row colors
- Centered alignment for titles
- Border outlines and gridlines
- The result is a professionally formatted dataset ready for export or presentation.
- Automatically beautify imported CSV or raw database data
- Create uniform table layouts for reporting
- Save time preparing datasets for dashboards or presentations
- Microsoft Excel 2013 or newer
- VBA enabled
(See included screenshot for before/after table comparison.)
📂 Path:
Excel-VBA-Macros/Auto_Format/
You are free to use, modify, and distribute this code with attribution. © 2025 Data Solutions Lab. by Osman Uluhan – All rights reserved.