rotating text in numbers

Question

Level 1

8 points

rotating text in numbers

very new to numbers and having trouble rotating text within a cell so that it reads "vertically" instead of "horizontally". more specifically, i've got several cells that are tall and thin, and i need to get the text to read within the cell. when i transfered the sheet from excel, it "unformatted" those specific cells.

any help is greatly appreciated. thanks.

MacBook, Mac OS X (10.5.6)

Posted on Dec 30, 2008 6:28 PM

Reply

Answer 1

Dec 30, 2008 7:22 PM in response to fadada1

No such feature in Numbers. That's why it didn't translate. If the row of text that you want to display vertically is just a set of titles, you can achieve what you want by creating a single column table, rotate the table 90 degrees, and place it where the titles need to be.

Jerry

Reply

Answer 2

fadada1 Author

Level 1

8 points

Dec 30, 2008 7:50 PM in response to Jerrold Green1

i think i understand - still a bit confused compared to excel, but learning quickly. i'll give that a try and see what happens.

thanks.

Reply

Answer 3

Ashka

Level 4

3,885 points

Dec 31, 2008 12:35 AM in response to Jerrold Green1

Hi Jerrold,
You have me stumped, rotating objects, shapes, pictures no problem but I can't get a table, even a single column one, to behave like an object. I cannot get a table to rotate.
Please How?

Reply

Answer 4

KOENIG Yvan

Level 8

41,807 points

Dec 31, 2008 3:16 AM in response to Ashka

Same thing for me Ashka.

I uses text blocks to achieve the wanted goal.

Yvan KOENIG (from FRANCE mercredi 31 décembre 2008 12:15:26)

Reply

Answer 5

Dec 31, 2008 7:22 AM in response to Ashka

Ashka, Yvan, Fadada1,

My apologies. I had mistakenly put my Pages Hat on when I made the claim that the table could be rotated.

Here's what can be done in Pages, that I mistakenly claimed could be done in Numbers:

The top row in the graphic is a single column table that has been rotated and placed adjacent to another table to give the appearance of having vertical text in the top row. Even this isn't perfect because as you can see, a 1-pt line in a rotated table appears slightly thicker than a 1-pt line in a non-rotated table.

So, as Yvan suggests, you can use multiple Text Boxes to get a similar effect. And I continue to occasionally stumble across differences in how apparently-similar containers are treated in Numbers vs. Pages.

Thanks for catching my error.

Jerry

Reply