Forum Discussion

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 ...

excel

Haytham Amairah
May 18, 2018
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

Haytham Amairah

Silver Contributor

May 18, 2018

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

geoperkins

Brass Contributor

Sep 10, 2019

This is not working for me. Still no alternating row color.

AmigoDeluxe
Copper Contributor
Dec 09, 2020
geoperkinsTurns out yo need to have a field under "Values" in your Pivot Table to get banded rows...

I know... it is a feature 🙂
- JamesBalisciano
  Copper Contributor
  Jan 13, 2021
  AmigoDeluxe thank you! That was the piece I was missing.
  
  Unfortunate that I need to choose between adding a field I don't need and the formatting that I want.
  - AmigoDeluxe
    Copper Contributor
    Jan 14, 2021
    JamesBalisciano I agree with you. My first thought was to just hide that extra column but that caused the issue again so the workaround I found was to set the column's width to 1 pixel so not really hidden but "invisible" to the eye.