O'Reilly logo

Office 2010 Made Simple 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

Printing Your Excel Worksheets and Workbooks

To print from Excel, you use the Print pane in Backstage, as with the other programs. 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 that your printout looks the way you intend it to.

Telling Excel Which Part of the Worksheet to Print

Usually, you want to print only the range of cells you've used on a worksheet, 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.

CAUTIONL Until you set the print area, Excel assumes ...

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