Try this (source:
http://www.ehow.com/how_4494444_set-print-area-microsoft-excel.html)
Step1
Highlight the desired print area. Do this by left-clicking with the mouse
and holding the button as you drag the cursor over the cells that you wish to
highlight. Release the mouse button when you are finished and the area that
you selected will remain highlighted.
Step2
Access the print properties menu. Scroll to the “File†tab on the command
bar and select “Print Area.â€
Step3
Set the print area. A submenu will open. Scroll to “Set Print Area†and
left-click to set the print area. The print area will be outlined with a
dashed border inside of the spreadsheet.
Step4
Check the print area in the preview screen. Scroll to the “File†tab on the
command bar and select “Print Preview†to see how the file will look when it
is printed.
Step5
Adjust the print area. To make any changes, just hover the mouse over a
corner of the dashed border surrounding the print area. When the cursor turns
to a cross-sectioned arrow, left-click and hold. Drag the print area to the
desired size.