Select the worksheet range that you want to print, and click on
File | Print Area | Set Print Area.

Stuart wrote:

I have an Excel worksheet that when i print preivew indicates me printing the
whole lot. i have hidden formuli that run right to the bottom of the sheet,
but i only want to print up to the row that has any actual data in. how do i
do this?