Ripley2453
New Member
- Joined
- Nov 25, 2015
- Messages
- 12
Good afternoon all,
I'm using Excel 2013.
When I add in blank rows to a pivot table ('insert blank line after each item' in pivot table design options) and then try to format them in Pivot Table styling ('Blank Row' in the styling options), the formatting only applies to the first blank row in the pivot table. I'm thinking it's just an Excel glitch, because I see no reason why this would happen and frankly it's quite annoying!
Basically, I want the pivot table to have a bold black line after each 'Title' (my data is regarding magazine titles, showing supply, sales & revenue as row values for each corresponding title). Hence why I want to format the blank lines separating each title.
Let me know if any of you can help, and I'll reply to any further questions you may have.
Many thanks,
Brad.
I'm using Excel 2013.
When I add in blank rows to a pivot table ('insert blank line after each item' in pivot table design options) and then try to format them in Pivot Table styling ('Blank Row' in the styling options), the formatting only applies to the first blank row in the pivot table. I'm thinking it's just an Excel glitch, because I see no reason why this would happen and frankly it's quite annoying!
Basically, I want the pivot table to have a bold black line after each 'Title' (my data is regarding magazine titles, showing supply, sales & revenue as row values for each corresponding title). Hence why I want to format the blank lines separating each title.
Let me know if any of you can help, and I'll reply to any further questions you may have.
Many thanks,
Brad.
Last edited:
