Rows into columns

[Rockbear]

Hi

Is it possible in 2003 to make rows into columns without cut and paste?
I have 616 rows of uniqe numbers and want the same numbers in columns..

Hopefull

Rock

 

[Bob Phillips]

Copy the data

Select the target cells and then Edit>PasteSpecial>Transpose

 

[Mike H]

What was wrong with the answer I gave you in your other post?

 

[Gary''s Student]

To convert 616 rows into 616 columns requires either Excel 2007 or more than
one worksheet.

 

[Niek Otten]

In Excel 2003 a worksheet has only 256 columns. This can not be changed.
You can use Bob's suggestion but spread the data over 3 sheets (in 3
copy/paste actions).

 

[Bob Phillips]

I assumed that if he wanted 616 columns he already had 2007. Must stop
assuming <bg>

 

[Rockbear]

Hi Mike H

Sorry, some error message said it was not posted, and I posted new one in
"public", but the naswer was fine, and clicked on yes

Sorry about that, should have checked if the reply was out..

Rock

 

[Rockbear]

Thanks, I know..

--
Just a regular user

In Excel 2003 a worksheet has only 256 columns. This can not be changed.
You can use Bob's suggestion but spread the data over 3 sheets (in 3
copy/paste actions).

--
Kind regards,

Niek Otten
Microsoft MVP - Excel