Excel: Outlining Icon Disappears in Outline Mode

 Last reviewed: November 3, 1994
Article ID: Q69533
The information in this article applies to:
  • Microsoft Excel for Windows, version 2.x, 3.0, 4.0, 4.0a, 5.0

SUMMARY

The outlining icon to collapse or expand a section of the outline should appear above a row or column. If you apply outlining to a hidden row or column, the outlining icon that should appear above the hidden row or column is not displayed.

MORE INFORMATION

Steps to Reproduce Problem

  1. Start Microsoft Excel.

  2. Select cells A1 and B1 and click the demote icon (right arrow) in the tool bar or press ALT+SHIFT+RIGHT ARROW on the keyboard. Select Columns when prompted.

  3. Notice the outlining icon that appears above column C.

  4. Select cell F1 and choose Column Width from the Format menu. Then choose Hide.

  5. Select cells D1 and E1 and click the demote icon (right arrow) in the tool bar or press ALT+SHIFT+RIGHT ARROW on the keyboard. Select Columns when prompted.

  6. Notice that the outlining icon does not appear in the outlining margin. The other outlining information does show up in the margin area but the icon is hidden.

To view the icon, unhide column F.

Note: This procedure also relates to rows.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 2.0 2.00 2.01 2.1 2.10 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 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.