Print or email a worksheet, panels or multiple levels

1. Click in the Standard toolbar.
   
   

2. Using the buttons at the top left of the preview tab, you can print, go to the next or previous page, view two pages at a time, zoom in and out, and close the print preview.
   
   

3. If the print preview looks correct, click Print.  
   
   If you need to modify the worksheet before printing, click Close then make the changes.

All visible columns of the worksheet will be printed. We recommend that you do a print preview before printing.

Note: The page will be horizontally scaled to fit all the visible columns on one page. Therefore the total width of your columns will affect the size of the font printed — the wider the columns and the more columns you are viewing, the smaller the font.

1. From File menu click Print.
   
   

2. In the Print dialog select the Printer, the Print range, the number of copies.
   
   

3. Click Properties to change the selected printer's properties such as the page orientation (portrait or landscape) and paper source.  
   
   

4. Click OK.

In this example, instead of printing a list of all the items in the worksheet you will print a list of panels.

1. Sort your worksheet by Part Description, Part Number and Catalog code.
   
   

2. Select all the panels on your worksheet.
   
   

3. From the File menu select Print Preview.
   
   Notice that only the panels are shown. If you have any items selected, worksheet will assume that you will be printing selected items only and will automatically insert a subtotal of the selected items in the printout.
   
   
   
   

4. From the File menu select Print.
   
   

5.  In the Print dialog box, verify that Selection is checked in Print Range.
   
   

6. Click OK.

Note: Use the Advanced Find Feature to select a number of similar items on your worksheet without sorting your worksheet.

Page setup controls the way the worksheet prints. Once you change it for your worksheet it will stay that way. This information is linked to a specific worksheet, not to the computer.

1. From the File menu, select Page Setup.
   
   

2. Change any of the following settings: Margin, Distance To Frame, Appearance, Orientation and Centering.
   
   

3. Under Miscellaneous you can choose to insert a page break after each subtotal.
   
   

4. Click Print Preview to preview your page setup.
   
   

5. Click OK to save the page setup or Print to send the worksheet to the printer.

Note: Even if you are printing to a black and white printer, check Print in Color to see subtotals better on your printout.

To set the default printer, paper size and orientation for all open worksheets:

1. From the File menu, select Print Setup.
   
   

2. Select the printer, paper size and orientation.
   
   

3. Click OK.

Note: This information is linked to the computer, not to a specific worksheet.

A quick way to print all the levels (Standards or Outline) in a worksheet is to use the Print Levels tool. Before you print you will need to set the default printer using the Print Setup dialog.

1. From the menu select File, Print Levels.
   
   

2. In the Print Levels dialog box, select which worksheets you wish to print.  For each line checked you will have one printout.

2. Check whether you also want to print the cover page and/or the report.
   
   

3. Click Print.

 Note: The title on each sheet will be the name of the Standard or the Outline level.

From the File menu select Send.

A new mail message appears, with the current worksheet set as attachment.

This feature works with any Messaging Application Programming Interface (MAPI) compatible program, such as Microsoft Outlook.