Forum Discussion
Emily Ross
May 18, 2018Copper Contributor
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?
- Hi Katyara, the first thing I would say is, it depends! So if this is purely SharePoint we are talking about rather than a Teams connected SharePoint site then I think the below applies. I'll add a bit at the end for the above scenario.
Another question I would ask is, do you need separate content types for those types you listed above? If any/ all of them share metadata, couldn't you just create a single content type with a "document type" choice or lookup column that adds the type in? You could then arrange your library views around that type.
I've personally tried it both ways, single library or dedicated library for the CT, generally I've found users don't like looking in multiple places for things so I tend to stick to as few libraries as I can and try to make them metadata rich to leverage better views.
With SharePoint on its own I do tend to still create new libraries and leave the default Documents, this is purely based on old habits dying hard though!
Finally, if we are throwing Teams into the mix then I think the conversation is much different. As Teams used the Documents library and folders for each channel as standard, that kind of sets your stall out from the get go in terms of structure. So in this scenario I would say use the Documents library and add the content types in to add the value to the files uploaded within the Team.
12 Replies
Sort By
- 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 🙂