Forum Home
Press F1
 
Thread ID: 60539 2005-08-05 01:43:00 Excel question tedheath (537) Press F1
Post ID Timestamp Content User
378379 2005-08-05 01:43:00 I want to do vertical typing in a worksheet.
When I go to cell and right click format cells go to alignment tab select vertical it still types horizontaly.
I have Excel 97.
The sheet is just a table there are no formulas or anything.
I need to verticaly type down 4 or 5 rows. I cant type horizontaly because there isnt enough room in landscape to get all the stuff on.

Thanks for any help I could email the sheet to someone if it would be easier to work out what I want to do

tedheath
tedheath (537)
378380 2005-08-05 01:55:00 Works for me in XL 97 (and in 2003)

You have to exit the cell before the alignment changes.
godfather (25)
378381 2005-08-05 06:56:00 Still cant get it to work, could someone give me step by step instructions I must be doing something wrong.

thanks

tedheath
tedheath (537)
378382 2005-08-05 07:03:00 Make sure yiou select Verical in the "Orientation" part of the dialogue box, not the "Text Alignment"

Other than that there is no step by step/
godfather (25)
378383 2005-08-05 10:31:00 "Horizontal" and "Vertical" only control the position of text within a cell.
To change the direction of orientation of text within a cell, click on the red pointer at the end of the word "Text" in the quadrant on the right and drag it to either +90° or -90° for vertical text and click OK.
rad_s4 (7401)
378384 2005-08-06 09:08:00 Thanks Rad worked just like you said.
Thanks again

tedheath
tedheath (537)
1