If you can do it manually, you can record the VBA code.

ToolsRecord New macro..make your changes. stop recording.
The generated code will probably not be the most efficient, but will show
you the requirements.

NickHK

"TKM" ...
I have several reports that I export from Access to Excel which look
terrible. I was wondering if there is a simple way to auto format the
columns
(align) by code via the menu item? Example the manual way. Select complete
workbook, format, columns, autoformat. can this be done via VBA?