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)
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)
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.
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.
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.
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.
Ian, have you been able to figure out where your nice user tip on this has gone to?
SG
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.
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.
Hi Winston,
Sorry, Numbers does not support rotated text within a table cell.
Regards,
Ian.
Ian, pity user tips have gone missing. Missing also may be a preposition in your Churchill quote!😀
https://brians.wsu.edu/2016/11/14/churchill-on-prepositions/
SG
Hi SG,
"Ian, have you been able to figure out where your nice user tip on this has gone to?"
A web search with DuckDuckGo:
https://discussions.apple.com/docs/DOC-7201
Regards,
Ian.
Hi SG,
"up with which I will not put."
Good catch!
Regards,
Ian.
The user tip survives!
Thanks for digging it up.
Or am I supposed to say thanks for digging up it?😀
SG
Vertical text