type upsidedown in excel

  f1fan 22:47 10 Jun 03
Locked

Does any-one know how I can turn text in a cell through 180 degrees?

  VoG™ 22:59 10 Jun 03

(1) Emigrate to Australia.

(2) Format/Cells, Alignment tab - I think that this will only go 90 degrees. Why would you want upside-down text?

  f1fan 23:08 10 Jun 03

Goo-day Vog

Reason- to print factory pan cards to laminate-- two on a page-- so second card,when cut has the open end facing down.

Hope that makes sense.
(Don't Know my-self now!!!)

Regards..

  VoG™ 23:11 10 Jun 03

I don't think that Excel can do this but I'm willing to be proved wrong.

I would insert the second sheet upside down in the laminator.

  f1fan 23:17 10 Jun 03

We have over 200 tags to print out,
so would like to put two on a A4 page. To save money, the root of all evil. (so they say)

  VoG™ 23:22 10 Jun 03

Send me a ticket to Silverstone and I'll work on it.

No, seriously you will have to do this mechanically (*pun intended*).

  Voyager 23:50 10 Jun 03

Er, he's right ya know, isn't "-90" same as 180?? but I guess it depends on what your using, if MS Excel 2000, try right clicking on the cell(s) and then left click on Format Cells, then left click Alignment tab, and drag li'll red diamond ta bottom.

  daba 00:40 11 Jun 03

Yoyager - -90 puts the text vertical reading upwards, and +90 puts the text vertical reading downwards.

Thee is no way to put the text "upside down".

The only way I can think of in excel is to use an "upside-down" font, but I don't know if these exist - I'll try a Google search later

  daba 01:06 11 Jun 03

Just Sussed it out.

Side 1 - format as -90

Side 2 - fornat as +90

there's 180 difference between them so a fold at the right place is just the ticket !!

  daba 01:28 11 Jun 03

Reformat your A4 page to "landscape" printout.

cells on the left-hand half configure as "-90" orientation, cells on the right hand side as "+90" orientation.

play about with cell "height" and "width", and remember, side 2 will have the same settings as side 1, you may need to redesign the form to fit the constraints of the formatting.

printout folds A4 to A5 about the centre line and the two new sides are the "same way up"

just tried it, its a doddle, and simple geometry, OK

  f1fan 08:56 11 Jun 03

Thanks daba,
Great lateral thinking.

Problem solved.

:)

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…