Answer: Select the cell(s) that you wish to rotate the text for. Right-click and then select 'Format Cells' from the popup menu. Right-click and then select 'Format Cells' from the popup menu. When the Format Cells window appears, select the Alignment tab. In Excel you can easy rotate text to any angle, but i’m have trouble finding a way to basically take the text and turn it on it’s side so the text will write from bottom to top (so the columns are not stupid wide and i can still read the column header). Hi Ian, It's a good thing you think left (down after rotation) alignment looks better, because there seems to be no way to script it to be otherwise! It's not hard to script the width of a table column. If that will help, I can demonstrate how to do that. But it doesn't seem possible to script the 'width' (actually the 'height' property, as before the box is rotated) of a text box. The width (height before rotation) doesn't seem to be so easy to change manually either, except by changing the value for 'Text inset'. Have you found another way? Hi SG, Resizing a text box manually has no option to change the height. Height is set by the font size and number of lines of text (and text inset as you say). Plan A.Text box with border to show its size. Text selected to show return characters. Text is 12 pt, the two returns are 8 pt Could scripting add varied font-sized returns before and after item i's contents? Come to think about it, aren't we doing this to make narrow columns (duh!). Maybe scripting to match column width to a bee's knees bigger than the default text box 'width'. 10 best antivirus for mac. Regards, Ian. Hi SG, Perhaps we are looking at this from the wrong end. We could leave the text boxes at their default height (= width after rotating) and adjust the column width of the underlying table. Text boxes have borders for illustration only. ![]() ![]() Increase the row height of the Header row. Set column widths of the table to a bee's knees wider than the text boxes. The bee's knees gives some leeway for adjusting the positions of the text boxes (by manual or scripting method). Without borders on the text boxes, it looks seamless. I wonder what is the record for the most discussion on a User Tip? Regards, Ian. Hi SG, From the Macquarie Dictionary (the dictionary that I recognise as the National Dictionary for Australia): Co- a prefix signifying partnership, joint responsibility or ownership, as in co-producer, co-writer. Therefore co-author means equal author. Please feel free to edit this User Tip. Better, use these ideas to create your own User Tip, you guru! Regards, Ian. The best video editing software for mac. It doesn't do a lot, but what it does is brilliant. Edit: Better, use these ideas to create your own User Tip, you guru! Then we can delete our confusing comments and make a clean User Tip. Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.
0 Comments
Leave a Reply. |