Print

Printing in Excel can sometimes be complicated. Learn about Excel printing, including setting the right print area, in this lesson.

Introduction

By the end of this lesson, you should be able to:

Printing in Excel

Once you've made the necessary adjustments to your Excel spreadsheet, you're ready to print. Printing in Excel is similar to printing in other Office 2000 applications, so this lesson will review printing basics and emphasize any differences.

To print your document:

  • Click the Print button on the Standard toolbar. print button
  • The document prints with default options.

OR

  • Choose Filearrow bullet Print from the menu bar. The Print dialog box opens.
  • Choose print options in the Print dialog box.
  • Click OK. The document prints.

Important pointDon't print your Excel document without checking spelling first! Excel includes two tools to help correct spelling errors: AutoCorrect and Spelling. For a review of these features, see Word 2000's AutoCorrect and Spelling and Grammar lessons.

The Print Dialog box in Excel

Many options are available in the Print dialog box, including:

Print Dialog Box

Printer name

The name of the default printer appears in this box. If you are connected to more than one printer, you can choose the name of the printer to use for this print job. Click the drop-down arrow and make a printer selection.

Properties button

Use this to view or change the printer's settings.

Print range

Using the Print Range option boxes, choose which pages of your document to print.

Number of copies

Click the up or down arrows in the Number of Copies list box to choose the number of copies you want to print.

To print:

  • Click any of the desired options. The options are activated.
  • Click OK to print your document and close the Print dialog box.


Challenge!

  • Open the Excel document of your choice.
  • Use Print Preview's functions to check and finalize formatting before printing.
  • Click the Print button in Print Preview.