• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Printing Worksheets

Open the File menu and select Print to open the Print dialog box.

Click the down arrow next to the Printer Name field to select the printer or fax you want to use (unless you have only one printer, like here).

In the Print Range area, select All to print all the pages in your worksheet, or select Page(s) From and To to specify the pages (for example, From 2 To 5).

INTRODUCTION

Printing a worksheet, workbook, or chart sheet can be quite simple, but setting the options for printing can be complex. The number of options that must be set before printing depends on the amount of data stored in the workbook, how it is arranged, how much of it needs to be printed, and how you want the printout to look.


TIP

Quickly Printing

If you simply click the Print button on the Standard toolbar, your entire worksheet will print using the default printing options unless you recently selected a different printer.


TIP

Setting Additional Print Options

To set additional print options, such as the paper size, graphic options, font options, and printer details, click the Properties button in the Print dialog box.


Type the number of copies you want to print in the Number of Copies field, which defaults to 1.

If you want the printed pages to be collated, click the Collate check box to select it.

In the Print What area, select Selection (specific cells), Active Sheet(s) (the current sheet), or Entire Workbook (all worksheets and chart sheets).

Click OK to send your printout to the printer. Alternatively, click Preview to preview your printout; then click the Print button on the Print Preview toolbar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint