# Use format info in Excel Writer **URL:** \ **Category:** Self-Help & Learn\ **Tags:** rpa\ **Created:** [January 13, 2020, 2:42am UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598 "2020-01-13T02:42:24Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![wllmdjngh](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/wllmdjngh/32/952_2.png) [@wllmdjngh](https://community.automationedge.com/u/wllmdjngh)\ **Post date:** [January 13, 2020, 2:42am UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/1 "2020-01-13T02:42:24Z")
The “Style for Cell” has the following explenation: “A cell (i.e. A1, B3 etc.) to copy the styling from for this column (usually some pre-styled cell in a template)” If I use a template of formats in an excel sheet, how can I reference this format info to be used when writng my data into excel? For example: (Filename(Sheet1(A3)). What is the most complex form of generating this reference? Thanks. ---
**Author:** ![priyanka.gupta](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@priyanka.gupta](https://community.automationedge.com/u/priyanka.gupta)\ **Post date:** [January 23, 2020, 11:10am UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/2 "2020-01-23T11:10:25Z")
![1. ExcelTemplateFile](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/6ae8fcc328a3cad66d252fdbf666d286268ee9d4.png) ![2. MicrosoftExcelStep](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/0d566c353a37c707b47774b27600126e149512b0.png) ![3. MicrosoftexcelWriterStep](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/627e218fd67d298c2b74896f1e0e417028d85263.png) ---
**Author:** ![wllmdjngh](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/wllmdjngh/32/952_2.png) [@wllmdjngh](https://community.automationedge.com/u/wllmdjngh)\ **Post date:** [February 24, 2020, 4:21pm UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/3 "2020-02-24T16:21:23Z")
Thanks Priyanca. That is the most simplest form to manage formats in a spreadsheet. In our case we have to create multiple sheets with multiple formats in different locations and what we have done is, generate a format sheet lets say named “Formats”, hide it and reference the Style like “Formats!A1” and leaving this format sheet hidden. This worked for us. Nice would be to have a centrilized workbook with all format so it could reference directly " “[workbook]Formats!A1” but think this is out of scope of AET. Do not expect to copy Conditional Formats. This is more complex and could be done in a Macro. Regards. ---
**Author:** ![Bhivraj](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@Bhivraj](https://community.automationedge.com/u/Bhivraj)\ **Post date:** [May 20, 2020, 12:49pm UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/4 "2020-05-20T12:49:29Z")
How to calculate average/total of each column and store the result at the end of each column? ---
**Author:** ![priyanka.gupta](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@priyanka.gupta](https://community.automationedge.com/u/priyanka.gupta)\ **Post date:** [May 20, 2020, 1:32pm UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/5 "2020-05-20T13:32:16Z")
Hi Bhivraj, You can use Group by step to calculate average of each column. ---
**Author:** ![Bhivraj](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@Bhivraj](https://community.automationedge.com/u/Bhivraj)\ **Post date:** [May 20, 2020, 1:53pm UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/6 "2020-05-20T13:53:12Z")
Yes Priyanka I tried using group by but it’s not working properly. ---
**Author:** ![Bhivraj](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@Bhivraj](https://community.automationedge.com/u/Bhivraj)\ **Post date:** [May 21, 2020, 4:57am UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/7 "2020-05-21T04:57:14Z")
Hi Priyanka, I am also tried using average in formula but not working. ---
**Author:** ![priyanka.gupta](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@priyanka.gupta](https://community.automationedge.com/u/priyanka.gupta)\ **Post date:** [May 21, 2020, 5:33am UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/8 "2020-05-21T05:33:38Z")
Hi Bhivaj, Try to use group by for calculating average of columns. Refer attached small workflow for your help.[WF\_GroupBy.psw](https://community.automationedge.com/uploads/short-url/vxe6U4AymqM2FxUv7P1lgi4IHSE.psw) (17.4 KB) [ip\_StudentMarks.xlsx](https://community.automationedge.com/uploads/short-url/nujwWBPiIoSif0Uo62zjiBTXb2S.xlsx) (9.7 KB) ---
**Author:** ![Bhivraj](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@Bhivraj](https://community.automationedge.com/u/Bhivraj)\ **Post date:** [May 21, 2020, 6:15am UTC](https://community.automationedge.com/t/use-format-info-in-excel-writer/1598/9 "2020-05-21T06:15:06Z")
Thank you Priyanka.