Printing a spreadsheet in Excel 2010

Here is an example of what I have in a a couple of hundred cells and this is a print preview which is the way it is printed. The spreadsheet looks fine but won't print right, Also instead of showing only half a line it can also show a full empy line and when that happens I have to manual pull it up. That will happen when you get close to the end of the cell so it thinks you need another row and you don't.Capture1.PNG