Skip navigation

How do you rotate text in numbers

1890 Views 5 Replies Latest reply: Feb 19, 2013 5:37 AM by Wayne Contello RSS
tam1966 Calculating status...
Currently Being Moderated
Oct 14, 2012 9:50 AM

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

OS X Mountain Lion (10.8)
  • Wayne Contello Level 6 Level 6 (12,560 points)
    Currently Being Moderated
    Oct 14, 2012 11:44 AM (in response to tam1966)

    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

  • Jerrold Green1 Level 7 Level 7 (28,120 points)
    Currently Being Moderated
    Oct 14, 2012 3:54 PM (in response to tam1966)

    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

  • nakedbulb Calculating status...
    Currently Being Moderated
    Feb 19, 2013 5:22 AM (in response to Wayne Contello)

    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

  • Jerrold Green1 Level 7 Level 7 (28,120 points)
    Currently Being Moderated
    Feb 19, 2013 5:35 AM (in response to nakedbulb)

    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

  • Wayne Contello Level 6 Level 6 (12,560 points)
    Currently Being Moderated
    Feb 19, 2013 5:37 AM (in response to nakedbulb)

    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

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. 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. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.