O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required