Rotated Text

Sly R · Apr 2nd, 2002, 01:40 PM

I wish to place 'x' and 'y' headings in the upper left corner of a document.

The x heading will be horizontal, as usual. No problem.

The 'y' heading must be rotated 90 degrees counterclockwise, so as to lie along the "spine" of the sheet.

How can I accomplish this without changing the size of a cell?

Jack in the UK · Apr 2nd, 2002, 01:46 PM

Hi Mate!

I would love some guru to prove me wrong.. this is impossible!

I have spent years trying to do thisone Work (Yuuuuck) can but Excel cant.

Excel can rotate work art.. text upside down or 90oD is impossible by other meant, Alignment by 90 is poss 180 inpossible TRUST ME...

I have some code supplied by a great pa; Ivan F Moala who changes text into BPM and flips 180 works perfect.. worth dropping him a line im sure he will post some help.. this code i used and i still owe Ivan a beer ovetr that one.

FIX:

You nned a font thats USD.. i have never fouind one, but am still intrested.. also MIRROR fornt ir USD and BTF (Back to front)

sorry...

Please prove me wrong

wi_guy · Apr 2nd, 2002, 01:47 PM

About the only thing that I know of, is when you turn the text with FORMAT:CELLS:ALIGNMENT...first, highlight a few rows above your data (if label is in cell A26, highlight A23:A26) and check the merge cells box before you hit ok.

Chris Davison · Apr 2nd, 2002, 02:23 PM

Sly,

or pop your heading somewhere safe, rotate it your desired degrees and then take a snapshot of the resulting rotation...

(snapshot is the camera icon on the tools toolbar)

then just pop the picture ontop of where you want it to go, it will sit on top of any cells, regardless of their sizes, merging or whatever....

Jack - you forgot my camera trick

wi_guy · Apr 2nd, 2002, 02:27 PM

Yes, definately the best solution !!!!

Chris Davison · Apr 2nd, 2002, 02:39 PM

Quote:

On 2002-04-02 13:27, wi_guy wrote:
Yes, definately the best solution !!!!

cheers ! check out the help file on "camera"

Apr 2nd, 2002, 01:46 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Mate! I would love some guru to prove me wrong.. this is impossible! I have spent years trying to do thisone Work (Yuuuuck) can but Excel cant. Excel can rotate work art.. text upside down or 90oD is impossible by other meant, Alignment by 90 is poss 180 inpossible TRUST ME... I have some code supplied by a great pa; Ivan F Moala who changes text into BPM and flips 180 works perfect.. worth dropping him a line im sure he will post some help.. this code i used and i still owe Ivan a beer ovetr that one. FIX: You nned a font thats USD.. i have never fouind one, but am still intrested.. also MIRROR fornt ir USD and BTF (Back to front) sorry... Please prove me wrong __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 01:40 PM	#1
Sly R New Member Join Date: Apr 2002 Posts: 1	I wish to place 'x' and 'y' headings in the upper left corner of a document. The x heading will be horizontal, as usual. No problem. The 'y' heading must be rotated 90 degrees counterclockwise, so as to lie along the "spine" of the sheet. How can I accomplish this without changing the size of a cell?

Apr 2nd, 2002, 01:47 PM	#3
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	About the only thing that I know of, is when you turn the text with FORMAT:CELLS:ALIGNMENT...first, highlight a few rows above your data (if label is in cell A26, highlight A23:A26) and check the merge cells box before you hit ok.

Apr 2nd, 2002, 02:23 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Sly, or pop your heading somewhere safe, rotate it your desired degrees and then take a snapshot of the resulting rotation... (snapshot is the camera icon on the tools toolbar) then just pop the picture ontop of where you want it to go, it will sit on top of any cells, regardless of their sizes, merging or whatever.... Jack - you forgot my camera trick

Apr 2nd, 2002, 02:27 PM	#5
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	Yes, definately the best solution !!!!