How to style Excel sheet in sharepoint online

Preethi R 21 Reputation points
2021-11-03T05:22:10.533+00:00

I am trying to export the list using export to excel option .
I want to style the excel sheet (Bold the header, Apply background color) while download itself.
How to apply styling to the file downloaded using "Export to excel".?

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Yi Lu_MSFT 17,701 Reputation points
    2021-11-03T08:03:40.33+00:00

    Hi @Preethi R
    Currently there is no OOB method to achieve your requirement.

    You could use SPFX to change the listview, for more information, youc could refer to:
    https://learn.microsoft.com/en-us/sharepoint/dev/spfx/extensions/get-started/building-simple-cmdset-with-dialog-api


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.