Share via

Looking to flip text 180 degrees in Excel file (2010)

Anonymous
2018-10-13T22:08:23+00:00

I have an auditorium seating chart in Excel 2010 that shows seat numbers from the stage view out. I'd like to find a way to reverse that, so the seat numbers can be seen facing the stage. Any way to do that directly or indirectly with some efficiency?  Thanks,

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

12 answers

Sort by: Most helpful
  1. Anonymous
    2018-10-14T04:16:29+00:00

    So, do you mean you want to keep the seating plan in its original up/down orienation, and you just want to change the orientation of the 1100 seat numbers on the image?

    If that is the case you have 2 options that I can think of ...

    Find the original file, edit the file numbers there.

    The other is to take a screen capture, flip the image, then zoom way the <expletive deleted> in and tediously insert new numbers over top of the old ones. 

    OK, looking at the image again there is one more option.  Use the current image as a guide, then manually recreate the whole thing in Excel.

    OK, I just figured it out. You can automate recreation of the diagram. There still is a lot of manual work to get the shape and color right, but generating the seat numbers right is a simple concatenate formula

    granted, this block is not in the right space on the worksheet, you have to displace it right to allow for east block, but you get the general idea.  All you have to do is adjust the locked $ row and column identifier for the first seat in each block, then copy and paste to fill the rest of the block.

    I just used default highlight colors, you could select custom colors that are closer.

    Adjust the row and column heights as needed

    Here is a quick and dirty recreation of the West block:

    https://1drv.ms/x/s!Am8lVyUzjKfpiRkjqFo7gylnrC96

    1. enter the required row and column labels
    2. paste the formula =CONCATENATE($A4,"-",B$3)   in cell B4
    3. Now copy and paste left and down
    4. drop out or delete unneeded "seats"
    5. add color to taste
    6. add wheel chair graphics (you can merge cells to do that.
    7. repeat with the other sections.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2018-10-13T23:04:29+00:00

    Does it have to be Excel?

    Are you simply looking for a grid to input the numbers?

    In Excel, or Word, you can insert a text box, then insert a table with appropriate number of rows and columns. The text box has an attached green ball at the top, center. Click and drag it to invert the text box.

    There is no simple way to do upside down text in Office. Here are some general tips that you may be able to adapt to your need.

    Note: most of the tips for other Office applications can be adapted for Excel

    Postscript- **Upside-Down Text with PostScript******http://wordribbon.tips.net/T010251_Upside-Down_Text_with_PostScript.html

    Got a printer that understands PostScript? You can use some simple PostScript coding to turn text completely upside down on your page.

    https://wordmvp.com/FAQs/DrwGrphcs/UpsideDownText.htm

    **Rotate objects precisely**(PPT)

    http://www.ellenfinkelstein.com/pptblog/rotate-objects-precisely/

    PowerPoint makes simple object rotations very easy.

    **Rotation tips**

    **Rotation tips**(PPT)http://www.ellenfinkelstein.com/pptblog/rotation-tips/****If you need to rotate objects or images, you can easily do so and get just the look you want

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2018-10-13T23:31:13+00:00

    I'm really not looking to be doing any major input and the goal is to rotate only the text in the cells, not the auditorium.

    The image I'm working with in pdf form can be seen at https://www.intermountainopera.org/ticketing/

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2018-10-13T22:43:02+00:00

    Maybe it will. I just need step by step instruction how to set up this function to run. And does the format of a range use a colon between beginning and end? It's been a very long time since I ran a function in a spreadsheet. Thanks,

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2018-10-13T22:22:21+00:00

    Maybe this will work for you?

    Public Function RevStr(rng As Range)

            RevStr = StrReverse(rng.text)

    End Function

    A1  contains 123

    =RevStr(A1)   returns  321

    Gord. . . . .droG

    Was this answer helpful?

    0 comments No comments