Choose File-->Page Setup
Then, choose Fit to: 1 page(s) wide by BLANK tall. When you leave the # number of pages tall BLANK, Excel figures out the best formatting to print your entire spreadsheet.
Use this tip, and you will never have to choose page break preview again.
Congratulations.
