Format and Align Columns
TKM wrote:
I am exporting a Access report to Excel and the alignment and justify (some
are right and some are justified to the left) are not correct (need all to be
centered). How would I go about automating this when the export takes place?
Please help I am pretty new to Excel
Don't know about automating it but it's a simple process to select
the whole sheet and then hit the center icon.
Go to view toolbars and mark format. this will give you a toolbar
with the left, center, and right justify. Click on the small square
above row 1 and to the left of col A this selects the whole sheet
now just hit the appropriate icon on the format toolbar.
gls858
|