Excel: Printing Information About Every Cell in Selection

 Last reviewed: November 29, 1994
Article ID: Q63805
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0

SUMMARY

The Show Info command on the Window menu in Microsoft Excel is designed to display information about a single cell at a time. It is not possible to display information about more than one cell on the screen; however, it is possible to print this information:

  1. Select the range of cells for which you want to display information.

  2. From the Window menu, choose Show Info. In Excel 4.0 you can show the Info Window by choosing Info Window from the Options Workspace dialog. At this point, the information of the active cell in the selection will be displayed.

  3. With the Info window still active, choose Print from the File menu. Click OK.

The resulting printout will contain the information from every cell in the selection.

You cannot display information from all the cells in the selection on the screen (except in Print Preview). Also, it is important to note that information will be printed about every cell in the selection, whether or not that cell is part of the active work area. Therefore, selecting the entire worksheet would create a printout of 4,194,304 cells.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.2 2.20 3.0 3.00 4.0 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.