# Microsoft Knowledge Base

## XL: List Box Text Appears Clipped or Is Not Displayed

Last reviewed: March 27, 1997 Article ID: Q115694
5.00 5.00c 7.00 7.00a | 5.00 5.00a WINDOWS | MACINTOSH kbusage The information in this article applies to:

- Microsoft Excel for Windows 95, versions 7.0, 7.0a
- Microsoft Excel for Windows, versions 5.0, 5.0c
- Microsoft Excel for the Macintosh, versions 5.0, 5.0a

## SYMPTOMS

In Microsoft Excel, the text in a list box on a worksheet disappears or is clipped when you decrease the row height or hide a row on the worksheet that contains the list box.

## CAUSE

This behavior occurs when the list box is grouped with another object, and the Move And Size With Cells option is selected for the group object. When you group two or more objects, this option is selected by default on the Properties tab of the Format Object dialog box. When this option is selected, the height of the object increases and decreases with the height of the cells that contain the object.

When you create a list box, the minimum height you can give the list box is approximately two rows on a worksheet. When this minimum height is decreased, the items in the list box become clipped, and eventually do not display. Additionally, the list box scroll bar arrows disappear when the list box is sized to less than the minimum height.

Note that when you select a list box that is not contained in a group of objects, the Move And Size With Cells option is not available.

## WORKAROUND

To avoid this behavior when you group a list box and then change the height of the cells that contain the group object, set the Object Positioning option for the group object to either of the following:

- Move But Don't Size With Cells

  -or-

- Don't Move Or Size With Cells

> KBCategory: kbusage
> KBSubcategory:

> Additional reference words: 5.00 5.00a 5.00c 7.00 7.00a cut off
> Keywords : kbusage
> Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0
> Platform : MACINTOSH WINDOWS

> 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: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.