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

Vertical text

Anyway to have vertical text in a cell.


FTAOD, I require each character sideways and not just one above the other, as per my attached image (in which I've used text boxes positioned over the cell to achieve this)

Posted on Jan 9, 2019 8:00 AM

Reply
Question marked as Best answer

Hi Winston,


Rotated text boxes placed over cells will give the appearance that you want, but they won't move with the table.

Take a screen shot of a rotated text box.

Menu > Insert > Choose.

The screen shot will arrive on the "canvas".

Copy (or Cut) and click once in a cell. Paste.

The screen shot will become an Image Fill in that cell.


Or you could use the Choose button in that Format Panel.


Regards,

Ian.

Posted on Jan 9, 2019 11:39 PM

11 replies
Question marked as Best answer

Jan 9, 2019 11:39 PM in response to Winston Churchill

Hi Winston,


Rotated text boxes placed over cells will give the appearance that you want, but they won't move with the table.

Take a screen shot of a rotated text box.

Menu > Insert > Choose.

The screen shot will arrive on the "canvas".

Copy (or Cut) and click once in a cell. Paste.

The screen shot will become an Image Fill in that cell.


Or you could use the Choose button in that Format Panel.


Regards,

Ian.

Jan 10, 2019 5:07 AM in response to Winston Churchill

Hi Winston,


Thanks for the green tick but I am still puzzled as to your overall aim.

Adding the text as an image is a better solution. Shame there isn't an option to rotate text column names are regularly so much wider than the cell content and quite often wider than single words, so even multiple line headers don't suit well.

I am not sure what you want to do.

Try this

Row 1 contains images as Image Fill.

Row 2 contains text with Format Panel > Text > Wrap text in cell. You can hide Row 2 and formulas will still find that text.

Row 3 contains images (screen shots) of rotated text boxes.


What do you want to do next? Do you want to "pull" data from the "Menu Items" table into the "Tuna Mayo Sandwich" table or "pull" data from the "Tuna Mayo Sandwich" table into the "Menu Items" table ?


Regards,

Ian.

Jan 10, 2019 6:54 AM in response to Yellowbox

I would have liked to have been able to rotate text in a header cell without the need for images. I can't speak for everyone but when the data cells are all checkboxes horizontal headers are somewhat useless.


I have multiple columns and don't want them much wider than the checkbox.



I'd wondered if I might be missing something obvious but assume now it's just not possible and requires the images as a work around. hence why your post answered my question.

Jan 10, 2019 6:59 AM in response to SGIII

Hi SG,


Yes, I remember that your AppleScript made that User Tip very useful.

No, I can't find that User Tip (that we both! created) or any other User Tip.


My reply to Winston is based upon a vague memory from a 'Numbers for Mac' discussion where a fellow user found a clever solution by inserting a rotated text box as an Image Fill.


That is the way to go, about which we did not think (paraphrasing the older Winston Churchill: "A sentence that ends with a preposition is something with which I shall not put."


Perhaps our Apple Support Communities Winston Churchill can advise on how to find and edit old User Tips.


Regards,

Ian.

Vertical text

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