Microsoft Office Tutorials and References
In Depth Information
In this chapter, you will learn how to
✔ Add headers and footers to printed pages.
✔ Prepare worksheets for printing.
✔ Print worksheets.
✔ Print parts of worksheets.
✔ Print charts.
Microsoft Excel 2010 gives you a wide range of tools with which to create and
manipulate your data. By using filters, by sorting, and by creating PivotTables and charts, you can
change your worksheets so that they convey the greatest possible amount of information.
After you configure your worksheet so that it shows your data to best advantage, you can
print your Excel documents to use in a presentation or include in a report. You can choose
to print all or part of any of your worksheets, change how your data and charts appear
on the printed page, and even suppress any error messages that might appear in your
In this chapter, you’ll learn how to prepare your worksheets for printing, print all or part
of a worksheet, print charts, and add headers and footers to your worksheets.
Practice Files Before you can complete the exercises in this chapter, you need to copy
the book’s practice files to your computer. The practice files you’ll use to complete the
exercises in this chapter are in the Chapter11 practice file folder. A complete list of
practice files is provided in “Using the Practice Files” at the beginning of this topic.