Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Reply
3 replies

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

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.

User uploaded file

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

Can the text in the header row be slanted?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.