Text Box Distortion Upon Deletion of Rows (2000)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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!

Reply | Quote

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).

Reply | Quote

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.

Reply | Quote