5 Replies Latest reply: Dec 31, 2008 7:22 AM by Jerrold Green1
fadada1 Level 1 (0 points)
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)
  • Jerrold Green1 Level 7 (29,960 points)
    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.

  • fadada1 Level 1 (0 points)
    i think i understand - still a bit confused compared to excel, but learning quickly. i'll give that a try and see what happens.

  • Ashka Level 4 (3,780 points)
    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?
  • Level 8 (41,790 points)
    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)
  • Jerrold Green1 Level 7 (29,960 points)
    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.