format text in cell to -/+ 180 digrees

**Ramzes** · 08-12-2010, 05:34 AM

Hello,

Is there any chance in excel to format cells so I can have my text upside down?

I know you can do + or - 90 digrees but is there any hidden option or add in that would allow me to do upside down.

Any suggestions appreciated.

Thanks
Simon

**martindwilson** · 08-12-2010, 05:41 AM

nope, you need an upsidedown font like stage dive
i posted something similar here
http://www.excelforum.com/excel-gene...down-text.html

**sandeep.warrier** · 08-12-2010, 07:16 AM

There is another way, but it is a bit hectic and has many limitations.

You need to create a linked image of a range. In the attached workbook, the cell D1 contains a linked image of the cell A1. To create this linked image I copied the cell A1, selected D1, pressed the shift key and selected Paste Picture Link from the Edit menu. This pasted a linked image in D1. The text shown in this image will change when you change A1.

You can format this image and set the rotation value as 180 so that it is flipped over.

Note that once you have created the image it fixes the column width. So if you enter anything in A1 that exceeds the column width of Column A, the same text will be truncated in the linked image.