June 25, 2016
July 16, 2010
I presume you mean you want to evenly distribute the data across all pages when printing data that exceeds one page worth. That's a good question. I don't think there is a way. Excel simply prints as much as it can on each page and whatever is left over goes on the last page.
Anyone else know a way?
February 24, 2015
I believe it wouldn't even be that hard to come up with a basic macro to count the visible cells / rows in the printing area and divide the number with the number or sheets needed and add page breaks to all the "right" places. Unfortunately this only works if data in each cell is roughly the same size and all the rows are about the same height.
If there's charts and other printable objects in the print range calculating the size of those objects and coming up with the solution how to handle those in case the sheet change should be placed in the middle of such object would be a nightmare though.
A much better solution would be if you added the page breaks yourself: The end result of distributing the data equally on all sheets would be quite different if you measure the data aesthetically rather than mathematically.
Most Users Ever Online: 57
Currently Online: Mark Lund, Max Neumann
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas