Page Break Issues

[EYEMDABEST]

I am trying to adjust the page breaks for a spread sheet so I can print it out. When I go to Page Break view it shows my sheet to be 5 pages long and 3 pages wide. When I drag the page break to the right it turns each cell into its own page. Any Ideas?

 

[dbn]

I've been having this problem a lot too (Excel 2007). Best solution I've found is the old faithful "save it, close it, reopen it". Hardly very satisfying, but seems to work.

Any better advice..?