5 Replies Latest reply: Feb 19, 2013 5:37 AM by Wayne Contello
tam1966 Level 1 Level 1 (0 points)

I'm trying to rotate the text in header row by 90 degrees.  Is this possible in Numbers?


OS X Mountain Lion (10.8)
  • 1. Re: How do you rotate text in numbers
    Wayne Contello Level 6 Level 6 (13,615 points)

    You cannot rotate text in any cell of a table.  There are a variety of technoques to work around this limitation:

     

    1) rotate a text box with the header text in it:

    Screen Shot 2012-10-14 at 1.29.48 PM.png

     

    2) copy the desired header text (which is rotated) then open Preview and create a new document from the clipboard.  Then use the rectangular selection tool to surround one word, then copy, then paste that into one of the cells in you header:

     

    Create new Preview doc from the clipboard contents:

    Screen Shot 2012-10-14 at 1.36.47 PM.png

     

     

     

    Now copy words out of preview using the rectangular selection tool:

    Screen Shot 2012-10-14 at 1.37.50 PM.png

    Screen Shot 2012-10-14 at 1.38.11 PM.png

    copy.

     

    now select the cell where you want this text:

    Screen Shot 2012-10-14 at 1.42.01 PM.png

     

    There are some other ways (which you can find by searching this forum).

     

    Hope these help

  • 2. Re: How do you rotate text in numbers
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Hi Tam,

     

    Be aware that inserting text as background fill, or overlaying your table with a text box, will achieve the visual effect, but the values or text you apply that way will not be avaiable for use in making calculations or charts.

     

    You can still have values in those cells of the table, and you can use that data in calculations and charts, but that will be an extra step.

     

    Jerry

  • 3. Re: How do you rotate text in numbers
    nakedbulb Level 1 Level 1 (0 points)

    Wayne,

    I created this NCAA Bracket in Numbers last March and exported it as a PDF for easy open and printing from any computer.  As you can see, I was able to rotate the text in cells along the edges showing where the first round games were.  I didn't use text boxes or any other programs yet now, I cannot remember how I did it!  When I opened the Numbers file to update it for this year's tournament, the cells are not rotated.  This isn't really a question, I'm just flabbergasted as to how I did it and what the heck happened to it.

    Screen Shot 2013-02-19 at 8.19.12 AM.png

  • 4. Re: How do you rotate text in numbers
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    I would guess that you used Text Boxes, rotated. If you click on the text in the original document, you should be able to tell what type of container it is in.

     

    Jerry

  • 5. Re: How do you rotate text in numbers
    Wayne Contello Level 6 Level 6 (13,615 points)

    bulb,

     

    I would think you used a text box rather than a table.  To insert a text box, select the TextBox tool from the tool bar:

    Screen Shot 2013-02-19 at 7.35.15 AM.png

     

    To rotate the textbox 90 deg open the metrics inspector while the text box is selected:

    Screen Shot 2013-02-19 at 7.36.43 AM.png