ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   horizontal lines to vertical (https://www.excelbanter.com/excel-discussion-misc-queries/176272-horizontal-lines-vertical.html)

[email protected]

horizontal lines to vertical
 
My transcripts need to be converted from horizontal text into horizontal text
in vertical columns..make sense?

[email protected]

horizontal lines to vertical
 
its me again, i thought i should explain a little more...im doing a
transcript for school, its a dialogue between two people, my teacher wants
there to be a cloumn for each persons "text", and a comment column and a
small "grade" column...anyway, after typing it out horizontally, he wants us
to flip the page so you can read the columns horizontally with the page on
its side (more room for the columns)..my question is how do i switch the
text, in order to print it on the page that way?...this is probably the most
easy thing, im just very fresh to this, thanks for your time...


" wrote:

My transcripts need to be converted from horizontal text into horizontal text
in vertical columns..make sense?


David Biddulph[_2_]

horizontal lines to vertical
 
Format/ Cells/ Alignment/ Orientation
--
David Biddulph

"
wrote in message ...
its me again, i thought i should explain a little more...im doing a
transcript for school, its a dialogue between two people, my teacher wants
there to be a cloumn for each persons "text", and a comment column and a
small "grade" column...anyway, after typing it out horizontally, he wants
us
to flip the page so you can read the columns horizontally with the page on
its side (more room for the columns)..my question is how do i switch the
text, in order to print it on the page that way?...this is probably the
most
easy thing, im just very fresh to this, thanks for your time...


" wrote:

My transcripts need to be converted from horizontal text into horizontal
text
in vertical columns..make sense?




[email protected]

horizontal lines to vertical
 
hey, cool, that really helped, im now on the right path...but now, when i did
this i tested it out with a few words in each column and they ended up being
beneith each other instead beside...you know, the columns didnt just pivot
all that way, they all lay under...do you know how to fix that too?....if not
thats cool youve already been a huge help, thanx


"David Biddulph" wrote:

Format/ Cells/ Alignment/ Orientation
--
David Biddulph

"
wrote in message ...
its me again, i thought i should explain a little more...im doing a
transcript for school, its a dialogue between two people, my teacher wants
there to be a cloumn for each persons "text", and a comment column and a
small "grade" column...anyway, after typing it out horizontally, he wants
us
to flip the page so you can read the columns horizontally with the page on
its side (more room for the columns)..my question is how do i switch the
text, in order to print it on the page that way?...this is probably the
most
easy thing, im just very fresh to this, thanks for your time...


" wrote:

My transcripts need to be converted from horizontal text into horizontal
text
in vertical columns..make sense?





Jon Peltier

horizontal lines to vertical
 
Sounds to me that this would be more effective in Microsoft Word, in a
table, on a landscape-oriented page.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"
wrote in message ...
its me again, i thought i should explain a little more...im doing a
transcript for school, its a dialogue between two people, my teacher wants
there to be a cloumn for each persons "text", and a comment column and a
small "grade" column...anyway, after typing it out horizontally, he wants
us
to flip the page so you can read the columns horizontally with the page on
its side (more room for the columns)..my question is how do i switch the
text, in order to print it on the page that way?...this is probably the
most
easy thing, im just very fresh to this, thanks for your time...


" wrote:

My transcripts need to be converted from horizontal text into horizontal
text
in vertical columns..make sense?




David Biddulph[_2_]

horizontal lines to vertical
 
No. It isn't at all clear what you want.
Two things you might look at, depending on what you really want:
One question is whether you've looked at setting the page to landscape
rather than portrait.
Another area to look if you're not getting the effect you want is word wrap
(again within Format/ Cells/ Alignment).

As someone else has pointed out, you may well be better off with Word rather
than Excel.
--
David Biddulph

"
wrote in message ...
hey, cool, that really helped, im now on the right path...but now, when i
did
this i tested it out with a few words in each column and they ended up
being
beneith each other instead beside...you know, the columns didnt just pivot
all that way, they all lay under...do you know how to fix that too?....if
not
thats cool youve already been a huge help, thanx


"David Biddulph" wrote:

Format/ Cells/ Alignment/ Orientation
--
David Biddulph

"
wrote in message
...
its me again, i thought i should explain a little more...im doing a
transcript for school, its a dialogue between two people, my teacher
wants
there to be a cloumn for each persons "text", and a comment column and
a
small "grade" column...anyway, after typing it out horizontally, he
wants
us
to flip the page so you can read the columns horizontally with the page
on
its side (more room for the columns)..my question is how do i switch
the
text, in order to print it on the page that way?...this is probably the
most
easy thing, im just very fresh to this, thanks for your time...


" wrote:

My transcripts need to be converted from horizontal text into
horizontal
text
in vertical columns..make sense?








All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com