https://communities.sas.com/t5/SAS-Programming/Excel-Export-report-formatting-aspects-of-the-report/m-p/878927#M347262 Were you able to resolve the alignment issue? Have you seen this: <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsadvug/n0otdo2g12obp3n0zmnghcn7p4vu.htm#p0ufsau8jixddzn1byxh1u14hval" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsadvug/n0otdo2g12obp3n0zmnghcn7p4vu.htm#p0ufsau8jixddzn1byxh1u14hval</A> Fri, 02 Jun 2023 09:47:11 GMT JosvanderVelden 2023-06-02T09:47:11Z https://communities.sas.com/t5/SAS-Programming/Excel-Export-report-formatting-aspects-of-the-report/m-p/876549#M346292 <P>Hi All, I've created a report and I've exported the report. One of my fields is a grouping on the main column. Upon exporting the name of the grouped column is on the bottom. how can i adjust this so that it is centered in the box? <BR />I've tried everything Ive been able to find online. In the style section I've tried verticalalign=center and top. THe excel still has it like th eattached image on the bottom.</P> <P><BR />Thanks in Advance!</P> <P>&nbsp;</P> <P>style(column)=[font=(Arial, 8pt) foreground=black background=CXFFFFFF <STRONG>verticalalign=top</STRONG> VJUST=C bordertopwidth=0 borderrightwidth=0 borderleftwidth=0 bordercolor=white ];</P> <P>&nbsp;</P> <P>Define CATEGORY / CENTER group order=data "CATEGORY";</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Jyuen204_0-1684437395136.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/84109i3B4C3402D2867453/image-size/medium?v=v2&amp;px=400" role="button" title="Jyuen204_0-1684437395136.png" alt="Jyuen204_0-1684437395136.png" /></span></P> <P>&nbsp;</P> Thu, 18 May 2023 19:55:49 GMT https://communities.sas.com/t5/SAS-Programming/Excel-Export-report-formatting-aspects-of-the-report/m-p/876549#M346292 Jyuen204 2023-05-18T19:55:49Z https://communities.sas.com/t5/SAS-Programming/Excel-Export-report-formatting-aspects-of-the-report/m-p/878927#M347262 Were you able to resolve the alignment issue? Have you seen this: <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsadvug/n0otdo2g12obp3n0zmnghcn7p4vu.htm#p0ufsau8jixddzn1byxh1u14hval" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsadvug/n0otdo2g12obp3n0zmnghcn7p4vu.htm#p0ufsau8jixddzn1byxh1u14hval</A> Fri, 02 Jun 2023 09:47:11 GMT https://communities.sas.com/t5/SAS-Programming/Excel-Export-report-formatting-aspects-of-the-report/m-p/878927#M347262 JosvanderVelden 2023-06-02T09:47:11Z