word wrap is off
what i'm looking for is how to keep the row height at 12.75 and the text span down across several rows
like it does when you enter text horizontal and it spans across several columns This message was edited by SparQ2020 on 2002-11-07 22:36
Solution I use for this is a text box with no fill or borders. Hold down ALT while sizing the box to snap to the grid. You could put a text box over several rows and format it with one of the vertical alignments.
This is not as limiting as it seems: you can make text box contents dynamic. For this, make a cell somewhere that contains whatever content you want to appear in the text box (result of INDEX, CONCATENATE, TEXT, etc). Select the tet box - click directly on the border so it is solid grey. Then click in the formula bar and type the address of your cell (ie =$A$1) and hit Enter. Then format.
Hope this helps
EDIT - Sparq, welcome to the board. I gotta take off but back tomorrow if necessary. This message was edited by Alriemer on 2002-11-08 00:35 This message was edited by Alriemer on 2002-11-08 00:36