Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Virginia
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text Box Distortion Upon Deletion of Rows (2000)

    Excel 2000

    I have a workbook / worksheet in which the first four columns are a database / list. To the right, out of the database area, are three text boxes arranged vertically with certain information I want displayed to the "user." Whenever I delete a record (row) that is under the top or second text boxes, they seem to try to accommodate themselves to the reduced space by reducing their height, and one has to manually move the bottom (and middle) text box down, and then manually adjust the height of the text box(es) that has been "squished."

    Is there any way to change this behavior, such that the text boxes retain their size and placement from the top of the worksheet border? I.e., their readability is not affected by the deletion of worksheet rows.

    The three text boxes contain three different types of information. It doesn't really make logical sense to combine them into one text box.

    Is this "fixed" in Excel XP?

    Thanks,

    Fred Holmes

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Text Box Distortion Upon Deletion of Rows (2000)

    Right click the border of the text box (don't click inside the text box).
    From the context menu, select "Format Text Box".
    Select the "Properties" tab.
    There are 3 options for "Object Positioning".
    Select the "Don't move and size with cells" option. The default setting is to move and size with cells - this causes your text boxes to shrink and/or move when you delete rows.

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Box Distortion Upon Deletion of Rows (2000)

    Can anyone extend this concept going the other way ? If a text box's contents would cause it to increase in height (if that's possible), how can I force the row height to increase? Thanks in advance!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Text Box Distortion Upon Deletion of Rows (2000)

    I don't know if this works in Excel 2000. In Excel 2002, text boxes have a property AutoSize (a check box in the Alignment tab).

  5. #5
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Box Distortion Upon Deletion of Rows (2000)

    Thanks, but this does not adjust the underlying cell's/row's height from what I can tell. And you can only have one or the other (Automatic Size -or- Move and Size with Cells). I really want the rest of the rows to "move" down to accomodate the larger text box. I guess I might look at a scroll bar next that will print the entire contents.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •