MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Can I Rotate Text Within a Cell In Numbers?

In Excel you can easy rotate text to any angle, but i’m have trouble finding a way to basically take the text and turn it on it’s side so the text will write from bottom to top (so the columns are not stupid wide and i can still read the column header). Some people have suggested a text box, but I’m not sure that will help because i’ll need to access the cell’s contents for another table,

Comments: One Response to “How Can I Rotate Text Within a Cell In Numbers?”

    3 years ago

    The Text Box idea works, but is painful and won’t work for you because of the need to access the data.
    So there isn’t a solution. When I need to do something like this, I usually just abbreviate words. You could do two columns, one with the abbreviation, and one with the full text. Then hide the full text column or make it small so it doesn’t get in the way, but you can still use it in your formulas in the other table. If you want to get really clever, you can automatically populate the abbreviated column with a LOOKUP from another table that features text and the matching abbreviations. This will also take some doing, though.

Comments Closed.