Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Column Headings in Excel Report Layouts

Posted on by 3,482

Hi:

If you use Excel's "FILTER" function, when designing reports using the new Excel Report Layouts feature, the "ugly" column headers (titles) are used.

Is there an easy workaround allowing for typing your own column headers?

Thanks!

John

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,296 Super User 2024 Season 2 on at
    RE: Column Headings in Excel Report Layouts

    Hi, if you mean column header in your report, you can use structured references with Excel tables.

    More details:

    https://yzhums.com/23873/

    pastedimage1682640201280v1.png

    pastedimage1682640215097v2.png

    And if you are not satisfied with the column names in Data, insert a sheet and enter '=Data', so that the values in Data, except the header, will be automatically saved to the new sheet, and then you can insert another row and add a new header.

    pastedimage1682640462767v3.png

    pastedimage1682640500345v4.png

    Hope this can give you some hints.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Column Headings in Excel Report Layouts

    The idea is that you should keep the data sheet unchanged and build your layout by referring to the data in the presentation sheet.

    In the presentation sheet you can name the columns as you like.

    pastedimage1682621733130v1.png

    Working with Excel Layouts - Business Central | Microsoft Learn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans