Cell Referencing - Vertical to Horizontal

Select vertical column of data.
Select cell in Sheet2
Click Paste Special: Transpose

- Moo

Or, if you don't want to transpose, you can try this:

If vertical data is in the range of A1:A10 on Sheet1, and you want it horizontally starting in A1 on Sheet2:

Put this formula in cell A1 on Sheet2, then fill right.

=INDIRECT("Sheet1!A"&COLUMNS($A:A))

- Moo