XL: Printing Cell Notes As Separate Printout

ID: Q112221

5.00 5.00c 7.00 WINDOWS kbusage

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Microsoft Excel, the Notes option is located on the Sheet tab of the Page Setup dialog box (from the File menu, choose Page Setup). When this option is selected, notes will be appended to the printed worksheets.

You do not have the option of automatically printing notes separately (without printing the worksheet data).

This feature is by design.

WORKAROUND

To print notes separately from the worksheet:

1. From the File menu, choose Print Preview.

2. Scroll to the page that contains the notes.

3. To print only the page that contains the notes, choose the Print button,

   and specify to print Pages <n> to <n> (where n is the page or pages
   containing the notes).

REFERENCES

"User's Guide," version 5.0, page 676

For more information about Notes, choose the Search button in Help and type:

    Notes

Additional reference words: Notes 5.00

Version           : 5.00 5.00c 7.00
Platform          : WINDOWS

Last Reviewed: March 29, 1997