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
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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
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
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.
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?