2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Why can’t Excel Pivot Tables repeat group headers on each printed page + reset serial numbers per group?

I’m working with a Pivot Table that has group headers with several item rows under each group.

Two issues came up while preparing it for printing:

1. Group headers in print pages
If a page break happens in the middle of a group, the next page starts with item rows but the group header is missing, which makes the report confusing.

Excel’s Print Titles only works for fixed rows, but in a Pivot Table the group headers appear in different rows, so they can’t repeat automatically.

It seems like a useful feature would be something like:
“Repeat group header at top of each printed page.”

2. Serial numbers inside each group
I also needed to number the item rows, but only for rows that contain items (not the group headers), and restart numbering for every new group.

Since Pivot Tables mix headers and items in the same column, creating a clean 1,2,3 numbering per group without including the headers becomes tricky, especially when filters are applied.

I’m curious about two things:

  • Why doesn’t Excel Pivot Table have an option to repeat group headers on each printed page?
  • Is there a clean way to generate serial numbers per group in a Pivot Table while ignoring the header rows?
submitted by /u/ElectricalDivide5336
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#Pivot Tables
#Excel
#group headers
#serial numbers
#printed pages
#group
#item rows
#Print Titles
#generate serial numbers
#page break
#ignore header rows
#restart numbering
#feature