Making a Verticle List Horizontal

[SamuelT]

Hi all,

I have a long list of projects going from A2:A231. In another worksheet
I'm trying to display the same list horizontally, ie: A2 through to (and
I'm guessing here) GA2.

Is there a means/formula that allows me to do this? I've tried simply
dragging the cells, as I would if I was copying the verticle list, but
it copies the same horizontal cells.

Can anyone suggest what I could do to rectify the situation?

TIA,

SamuelT

 

[Dave Peterson]

You can
select your range
edit|copy
select A2 of the second sheet
edit|paste special|check transpose.

Or you could use a formula:

Select A2:GA2 (same guess as you!)
type this:
=transpose(sheet1!a2:a230)
and hit ctrl-shift-enter

Now if you change the first range (A2:A230), the second range (A2:GA2) will
change--'cause it's a formula.

 

[SamuelT]

Many thanks Dave. The 'Paste Special' works great (oh, it's actuall
HW2!

 

[Rajah]

Hi all,

I have a long list of projects going from A2:A231. In another worksheet
I'm trying to display the same list horizontally, ie: A2 through to (and
I'm guessing here) GA2.

Is there a means/formula that allows me to do this? I've tried simply
dragging the cells, as I would if I was copying the verticle list, but
it copies the same horizontal cells.

Samuel,
An easy way to do this is to:
1. Select cells a2:a231
2. Edit -> Copy the cells.
3. Move to A1 (or some other cell that doesn't overlap A2:a231)
4. Edit -> Paste Special. (Not the regular Paste here.)
5. Check the transpose box.
6. Press the OK button.

That should do the trick.