Format and Align Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
TKM said:
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
Click to expand...

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
 
I went to Excel and to toolbars but I dont see anything marked format? It
shows a lot of toolbars like standard, formatting boarders etc but not MARKED
FORMAT?
 
TKM said:
I went to Excel and to toolbars but I dont see anything marked format? It
shows a lot of toolbars like standard, formatting boarders etc but not MARKED
FORMAT?
Click to expand...
Sorry. Formatting is the one you want. Just click on it and the
toolbar will be added. Then you want to look for three icons
with lines on them that show the different text alignments.

gls858
 
Back
Top