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 ...

Get Learn Excel 2011 for Mac now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.