Microsoft Knowledge Base

Hidden Text Boxes Change When Unhiding Rows
Last reviewed: September 12, 1996
Article ID: Q109062
The information in this article applies to:
  • Microsoft Excel for Windows versions 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh versions 3.0, 4.0

SUMMARY

When you create a number of text boxes on a worksheet that are different heights and widths, and you group them together, then hide the rows, when you unhide the rows, the text boxes will all have the same height and width.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open new worksheet.

  2. Click Text Box tool

  3. Create three text boxes in the following ranges: B4:C14, E10:E20, and F8:G14

  4. Select all the text boxes.

  5. From the Format menu, choose Group. (In Excel 5.0 choose Format menu,
then select the placement option and then select Group)

  1. Select the rows from 3 to 21.

  2. From the Format menu, choose Row Height and then hide. (In Excel 5.0
choose Format menu, then select the Row option and then select Hide)

  1. From the Format menu, choose Row Height and then Unhide. (In Excel 5.0
choose Format menu, then select the Row option and then select Unhide)

All text boxes will be the same height and width and will be positioned side by side.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.00 4.00 4.00a
This can also be replicated with Excel 5.0 beta for the Macintosh build
3010.




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