Forum Discussion

Emily Ross's avatar
Emily Ross
Copper Contributor
May 18, 2018
Solved

Banded Rows in Excel not working

Under the Design tab, I selected the "Banded Rows" option. When I did, the Table Styles preview then showed banded rows.

Then when I tried to apply a style that had banded rows, the banded rows did not apply to the table. What went wrong?

  • Emily,

     

    I guess that the table already has its own format.

     

    Please select the table, then go to Home >> Font >> Fill Color.

    And select No Fill as shown in the below screenshot:

     

     

    Hope that helps

    Haytham

12 Replies

  • Shiffa's avatar
    Shiffa
    Copper Contributor
    Doing pivot table summary then double clicking at the grand total gives the whole excel table with its banded rows.
  • Darr330's avatar
    Darr330
    Copper Contributor
    Thank you!!!! I have been banging my head on my desk for three days on this. Much appreciated.
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Emily,

     

    I guess that the table already has its own format.

     

    Please select the table, then go to Home >> Font >> Fill Color.

    And select No Fill as shown in the below screenshot:

     

     

    Hope that helps

    Haytham

Resources