Inverted text

B

Billy Thomas

I can go to the format window and forced text 90°, or letters running top to
bottom. can I rotate text180° so it is upside down? I tried using a text
box, and using the flowchart autoshape for "process" , but when i rotate the
box 180°, the text remained the same. Word Art doesnt seem to be a good
choice, bcause I just want a plain font (10 or 12 pt arial). Any
suggestions?

Thanks,

Billy
 
D

David McRitchie

The ability to rotate a True Type font 180 degrees was
available on mainframes over 10 years ago. It is hard
to believe that any PC software is unable to rotate a
True Type 180 degrees. I was very disappointed
in 1996 that I could not do this on a PC.

You can turn the cell into a picture.
Copy (Ctrl+C)
Shift+Edit, Paste Picture
Copy (Ctrl+C) to copy the picture

But you can't rotate the picture in Excel (2000). So you
have to go outside Excel to rotate the picture.

You can use the free IrfanView (http://www.irfanview.com)
to rotate the picture. Edit, paste, L, L, Copy (L is rotate left)

You can use SnagIT which is pay for software
to go from clipboard to clipboard and rotate it in the edit area.

You can use any picture formatting tool to rotate that can
take from the clipboard and put back to the clipboard.

Back in Excel
Paste the rotated picture, realign to the cell boundary
and lock to the cell gridlines. It is a picture and the content
will not change though.

Another possibility since you don't give a purpose. If you
wanted to produce a Tent Card (Folded Card with Name/Dept)
for a meeting. You could probably use two text boxes, or
two cells Rotate the text in one +90 degrees, and the other
one -90 degrees.

I think it took 4 years after getting True Type fonts on main
frame to be able to rotate them 180 degrees so we could
choose a font orientation that was turned and turn it 180
degrees from that as long as the result as not upside down
to the paper orientation going through the printer.
 
B

Billy Thomas

David,
You hit the nail in the head! I did want to make a tent.....to be exact, to
create labels for index tabs. Your suggestion of opposite 90° orientations
should work perfect. Thank you for your very elegant solution!!
Billy
David McRitchie said:
The ability to rotate a True Type font 180 degrees was
available on mainframes over 10 years ago. It is hard
to believe that any PC software is unable to rotate a
True Type 180 degrees. I was very disappointed
in 1996 that I could not do this on a PC.

You can turn the cell into a picture.
Copy (Ctrl+C)
Shift+Edit, Paste Picture
Copy (Ctrl+C) to copy the picture

But you can't rotate the picture in Excel (2000). So you
have to go outside Excel to rotate the picture.

You can use the free IrfanView (http://www.irfanview.com)
to rotate the picture. Edit, paste, L, L, Copy (L is rotate left)

You can use SnagIT which is pay for software
to go from clipboard to clipboard and rotate it in the edit area.

You can use any picture formatting tool to rotate that can
take from the clipboard and put back to the clipboard.

Back in Excel
Paste the rotated picture, realign to the cell boundary
and lock to the cell gridlines. It is a picture and the content
will not change though.

Another possibility since you don't give a purpose. If you
wanted to produce a Tent Card (Folded Card with Name/Dept)
for a meeting. You could probably use two text boxes, or
two cells Rotate the text in one +90 degrees, and the other
one -90 degrees.

I think it took 4 years after getting True Type fonts on main
frame to be able to rotate them 180 degrees so we could
choose a font orientation that was turned and turn it 180
degrees from that as long as the result as not upside down
to the paper orientation going through the printer.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

rvExcelTip > said:
Style orientation is limited to the [-90°,+90°] interval. You could
possibly use for some small investment an upside-down font. cfr
http://www.myfonts.com/fonts/ingrimayne/upside-down/
Click to expand...
Click to expand...
 
D

David McRitchie

Hi Billy,
Yes it was index tabs for file folders that I did on my PC at
home, as well. At work things were more complicated even
for simpler forms depending on paper used on high speed
printers (fan fold forms with tractor holes).
// David
 
Top