Format and Align Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TKM - 18 Oct 2006 21:05 GMT

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

Reply to this Message

gls858 - 19 Oct 2006 15:16 GMT

> 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

Reply to this Message

TKM - 19 Oct 2006 16:12 GMT

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?

> > 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
[quoted text clipped - 11 lines]
>
> gls858

Reply to this Message

gls858 - 19 Oct 2006 18:06 GMT

> 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
[quoted text clipped - 14 lines]
>>
>> gls858

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

Reply to this Message