Printing Cell Notes As Separate Printout (112221)


The information in this article applies to:

  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0c
  • Microsoft Excel for Windows NT 5.0
This article was previously published under Q112221

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

Modification Type:MinorLast Reviewed:8/15/2005
Keywords:KB112221
©2004 Microsoft Corporation. All rights reserved.