Unlike in Microsoft Word where a page is page, Excel 2010 (and, in fact, all previous versions) don’t really understand the concept of a “page”. Thus, in order to print using Excel, it’s up to the user to let Excel know what data you want on a page. In Excel, the area of a spreadsheet (worksheet) to be printed is called the Print Area.
Excel will generally automatically set the print area, but if you print your worksheet and find that it isn’t printing correctly, you should consider adjusting the print area.
To adjust the print area:
1. First select the area you want to print (hold down the left mouse button and drag to select the area)
2. Making sure the area is still selected, in the Excel 2010 menu bar, select the Page Layout tab and the Print Area button (the area should still remain selected).
3. In the drop-down menu that appears, click “Set Print Area”.
Now when you print you will be only printing your selected print area.