I have a excel 2007 worksheet where one page only shows 5 rows of data (a very short page!) but when printed this page has 5 data rows at top and rest of the normal page is blank. The other pages are all normal

How can I fix this page so that it uses all the space in a page?

Switch to Page Break Preview (there's a button for it to the left of the zoom percentage in the status bar). Is there a page break below row 5? If so, right-click in a cell directly below it (i.e. in row 6), and select Remove Page Break from the context menu.

Thanks! This fixed the problem!