Forum Discussion
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
- CLawrence2350Copper ContributorThank you!
- ShiffaCopper ContributorDoing pivot table summary then double clicking at the grand total gives the whole excel table with its banded rows.
- Darr330Copper ContributorThank you!!!! I have been banging my head on my desk for three days on this. Much appreciated.
- Haytham AmairahSilver 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
- shiffamoCopper Contributor
Yes it worked very well thank you Haytham Amairah
- ben1984Copper Contributor
- geoperkinsBrass Contributor
This is not working for me. Still no alternating row color.
- AmigoDeluxeCopper Contributor
geoperkinsTurns out yo need to have a field under "Values" in your Pivot Table to get banded rows...
I know... it is a feature 🙂