Making Your Worksheets Print Correctly
To print from Excel, you use the Print dialog box. But before you print, you need to tell Excel which part of the workbook to print. You may also want to check the page setup to make sure the page breaks fall where you want them to fall.
Telling Excel Which Part of the Worksheet to Print
Given that each worksheet contains billions of cells, you seldom need to print the whole of a worksheet—you want to print only the range of cells you've used, or perhaps only a small subset of that range. So when you're printing, the first thing to do is tell Excel which part of the worksheet you want to print. Excel calls this setting the print area. You can set a separate print area for each worksheet.
CAUTION: Until ...