Chapter 9. Printing Worksheets

In this section:

After you have created your worksheet, you can print a copy for reference, backup, or to distribute to your colleagues. Although you might be tempted to print your worksheet as soon as you have completed it, it’s usually a good idea to check your work first. All you need to see how your worksheet will look when printed is to display the worksheet in Print Preview mode. If you want to change how your worksheet will appear on the printed page, you can do anything from changing the orientation of the printout (that is, printing in a vertical format, called portrait mode or a horizontal format, called landscape mode) to scaling the worksheet to fit within a specific number of pages. It’s easy to fine-tune margins, adjust headers and footers, and customize a variety of other print options as well.

Previewing Worksheets Before Printing

Before you print a worksheet, it’s helpful to take a step back and look at how your data will appear on the printed page. To do that in Excel, you display your worksheet in Print Preview mode. While you have your workbook open in Print Preview, you can zoom in to see cell contents clearly without altering printing size. You can also adjust the widths of any columns in Print Preview, saving you the trouble of switching between Print Preview and the standard Excel window. Excel 2007 also enables you to view your workbook in Page Layout View, which displays your workbook as it will be printed while still enabling you to edit the workbook’s contents easily.

Display a Worksheet in Page Layout View

  1. Click the View tab.

  2. In the Workbook Views group, click Page Layout View.

    Display a Worksheet in Page Layout View

View and Zoom Worksheets in Print Preview

  1. Click the Microsoft Office button.

  2. Click the Print item’s right arrow.

  3. Click Print Preview.

    View and Zoom Worksheets in Print Preview
  4. Click any area of the worksheet to switch between magnified and full-page view.

  5. Click Close Print Preview.

    View and Zoom Worksheets in Print Preview

Change Column Widths and Row Heights in Page Layout View

  1. Click the View tab.

  2. Click Page Layout View.

  3. Hover the mouse pointer over the edge of a column or row header until the mouse pointer becomes a two-headed arrow. Drag the edge until the column or row is the desired size.

  4. Click Normal to return to Normal view.

    Change Column Widths and Row Heights in Page Layout View
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.135.183.138