Benches Uncategorized

11

Vertical text

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

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)

11 replies

Sign in or join Beachball Help to reply.

  1. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  2. 0

    Winston Churchill

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  3. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  4. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Ian, have you been able to figure out where your nice user tip on this has gone to?

    SG

  5. 0

    Winston Churchill

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  6. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  7. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi Winston,

    Sorry, Numbers does not support rotated text within a table cell.

    Regards,

    Ian.

  8. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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

  9. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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.

  10. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi SG,

    "up with which I will not put."

    Good catch!

    Regards,

    Ian.

  11. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    The user tip survives!

    Thanks for digging it up.

    Or am I supposed to say thanks for digging up it?😀

    SG