MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Displaying Text up-side down

Posted by Troy on January 28, 2002 10:59 AM

Thank you for your reply. The value of the data I would like displayed upside-down will change. With-in the spreadsheet I have about 40 different pages that will print out with different values. This printed sheet will then be wrapped around construction drawings and then put into storage bins in the side of a wall. Only the last 3" of the roll will stick out of the bin and I would like to label them for easy access. The cell I would like the text displayed upside-down is linked to another sheet. Don't know if the header would work, but will try. Thanks again.

Hi Troy

Couple of options
1) Why not use Footers and input the cell data
into the footer
2) Use WordArt and Flip the wordart



Posted by Juan Pablo G. on January 28, 2002 11:39 AM

I'm not sure about this one, but if you merge, let's say, A1:A10, and then, you set the text orientation in Cell format to be -90º or 90º maybe you can achieve what you want.

Juan Pablo G.

Posted by Chris D on January 29, 2002 11:15 AM

If you take 2 cells (say A1 and D1) and enter the same text in each....... then format one with -90 degree alignment, and the other with +90 degree alignment - they are relative to each other by 180 degrees (ie the flip that you require) when in Landscape orientation

maybe if you can redesign or play around with your header and the body of your data (maybe utilising the landscape vs portrait print options) you could probably get something that resembles what you are after

maybe just transpose the whole of your data so it's orientation is horizontal rather than vertical then +90 degree it's orientation, substituting row height for what used to be column width, whilst squashing down column width to resemble your original row heights ?

totally messy and not practical, I have to admit...

hope this might help