How do I turn text to vertical in Numbers app?

> In Numbers, is there any way to turn the text to a vertical path?

Not as an editable/referenced cell, no, but it is possible visually.

Two ways come to mind:

1) Create a text object (via the toolbar). Text objects can be rotated via Format Inspector -> Arrange -> Rotate, then you can drag it to overlay your spreadsheet table

2) Create your rotated text (either as above, or in some other app) and take a screenshot (Command-Ctrl-4). You can then paste this into a cell as a picture object.

Pros and cons to both approaches.

In the first case, the text remains a text object and is editable at any point.

In the second case the text isn't editable, but it is at least associated with the relevant cell and will move/resize with that cell.

In neither case can you reference the rotated text in any formula (the first case isn't part of a cell therefore has no reference, the second case is a picture and there are no formula functions that work on pictures.

From a visual standpoint, it may be enough, though.

Hi HSKang,

See this User Tip from 2nd February 2017:

Rotate cell contents in Numbers 3 and 4: … - Apple Community

See also a better solution :

Rotate Text in a Cell (Numbers) - Apple Community

To help you go to the nitty gritty, see my reply to Barry on 2nd March 2021 (scroll down)

Hi Barry,

Yes. it was fiddly.

1. Set the width of the columns to accommodate the widest entry in the body cells (yes, we are stuck with that width).
2. Set the height of the header row to accommodate the longest rotated label, plus a bit more (see point 8).
3. Format Panel > Table > Row & Column Size and note them.
4. Create text boxes with width (before rotating) equal to the row height and height (before rotating) equal to the column width.
5. Type the labels and rotate the boxes 90 degrees.
6. Take screen shots. Great care needed to capture only the boxes and not any of the surrounding white canvas.
7. Insert screen shots onto the canvas. Copy and paste into the cells. Scale to fill should involve minimal (if any) distortion.
8. Type the labels into the cells so that the values can be used in formulas. Align to the top of the cells. Turn off Wrap Text in Cell. Hide the cell contents by changing the text colour to match the image fill background. The extra height (point 2) ensures that the grey text does not obscure the black text in the image fill.

Yes, we are stuck with the chosen cell sizes. Choose wisely!

Regards,

Ian.

I don't know much about Numbers for iPhone.

This has plenty of references to styles:

https://help.apple.com/numbers/iphone/5.0/#/tan72790d40

Regards,

Ian.