Dr. John 97

Q: Can the text in the header row be slanted?

In Excel the text in the header row can be slanted at an angle in order to show a long header text in a narrow column. Can this be done in Numbers?

MacBook Pro, OS X Mountain Lion (10.8.4), Keynote Program

Posted on Sep 18, 2013 1:40 PM

Close

Q: Can the text in the header row be slanted?

  • All replies
  • Helpful answers

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 18, 2013 1:56 PM in response to Dr. John 97
    Level 6 (19,017 points)
    iWork
    Sep 18, 2013 1:56 PM in response to Dr. John 97

    Short answer: No

     

    Long Answer:  There are ways to coerce text to be rotated.  One way is to:

    - write the text in a text box,

    - then rotate the text.

    - select the text box (not the text, the text box), and copy

    - open the app Preview and create a new window from the clicp board using the menu item "File > New from Clipboard"

    - now use the menu item "Tools > Rectangular Selection" to select the diagonal text as an image, then copy

    - now select the target cell in Numbers and paste

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Sep 18, 2013 3:00 PM in response to Dr. John 97
    Level 7 (29,996 points)
    Sep 18, 2013 3:00 PM in response to Dr. John 97

    John,

     

    Numbers doesn't support this directly. A quick way to fake it is to make a chart with slanted category axis labels. This won't give you slanted cell borders, but then you didn't ask for that.

    Screen Shot 2013-09-18 at 5.59.27 pm.png

    These particular instructions have an advantage over just pasting text boxes over the cells in that the same text is in the cell as in the label pasted over the cell. This may be helpful if you want to reference a header cell's content in an expression.

     

    Jerry

  • by Yellowbox,

    Yellowbox Yellowbox Sep 18, 2013 6:05 PM in response to Dr. John 97
    Level 6 (10,435 points)
    Mac OS X
    Sep 18, 2013 6:05 PM in response to Dr. John 97

    Hi John,

     

    Or use text wrap:

     

    Screen Shot 2013-09-19 at 11.03.08 AM.png

     

    Regards,

    Ian.