Am I doing something wrong? In page setup, if I tick "Fit rows to 1 pages tall" it completely ignores my page breaks and just puts all 500 rows onto one page. How do I get this setting to work with my page breaks? I find that I'm constantly changing the heights of my rows if I need to add a row in order for my pages to stay as I've set them.

Thanks
Jean