software

Is there a way to center vertical text across rows? If you're familiar with
using quot;centering text across selectionquot; this is the same type of thing I want
to do but I would like the text to be vertical across multiple rows.

A B
1 data
2 data
3 data
4 T data
5 E data
6 X data
7 T data
8 data
9 data
10 data

I know I can do it by merging the cells in column A but then I can't insert
a row without un-doing the merge.

Thanks for any help.

Kim,

If its just for labeling, make a text box from your draw toolbar. You can
orient and center anywhere.

Beege

quot;Kimquot; gt; wrote in message
...
gt; Is there a way to center vertical text across rows? If you're familiar
gt; with
gt; using quot;centering text across selectionquot; this is the same type of thing I
gt; want
gt; to do but I would like the text to be vertical across multiple rows.
gt;
gt; A B
gt; 1 data
gt; 2 data
gt; 3 data
gt; 4 T data
gt; 5 E data
gt; 6 X data
gt; 7 T data
gt; 8 data
gt; 9 data
gt; 10 data
gt;
gt; I know I can do it by merging the cells in column A but then I can't
gt; insert
gt; a row without un-doing the merge.
gt;
gt; Thanks for any help.
Thank you very much. I think this will work.

quot;Kimquot; wrote:

gt; Is there a way to center vertical text across rows? If you're familiar with
gt; using quot;centering text across selectionquot; this is the same type of thing I want
gt; to do but I would like the text to be vertical across multiple rows.
gt;
gt; A B
gt; 1 data
gt; 2 data
gt; 3 data
gt; 4 T data
gt; 5 E data
gt; 6 X data
gt; 7 T data
gt; 8 data
gt; 9 data
gt; 10 data
gt;
gt; I know I can do it by merging the cells in column A but then I can't insert
gt; a row without un-doing the merge.
gt;
gt; Thanks for any help.