Microsoft KB Archive/112221

From BetaArchive Wiki
Knowledge Base


Printing Cell Notes As Separate Printout

Article ID: 112221

Article Last Modified on 8/15/2005



APPLIES TO

  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0 Standard Edition



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



Additional query words: Notes XL

Keywords: KB112221