Set print area in windows 7

An easy way to do it is to select the portion of the spreadsheet you want to print (click-drag highlights the selected cells). When you have the correct cells selected use "Print" - in the Print dialogue box find the "Print What" section and choose the "Selection" option.