Ask Your Question

Repeat pivot table line headers on page break [closed]

asked 2015-03-19 16:47:48 +0100

Rui gravatar image


I have a pivot table that occupies an uncertain number of pages and need to repeat the first row of the pivot table each time that the page changes.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Rui
close date 2015-03-26 11:51:43.345520

1 Answer

Sort by » oldest newest most voted

answered 2015-03-19 22:20:55 +0100

m.a.riosv gravatar image

If for see while working. Go to the first line of data under titles and Menu/Windows/Freeze.

If for print, go to Menu/Format/Print ranges/Edit - Rows to repeat, and select the title rows.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-03-19 16:47:48 +0100

Seen: 160 times

Last updated: Mar 19 '15