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
--
Just a regular user

Copy the data

Select the target cells and then EditPasteSpecialTranspose

--
__________________________________
HTH

Bob

"Rockbear" wrote in message
...
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
--
Just a regular user

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

"Rockbear" wrote:

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
--
Just a regular user

To convert 616 rows into 616 columns requires either Excel 2007 or more than
one worksheet.
--
Gary''s Student - gsnu200814


"Rockbear" wrote:

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
--
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

"Rockbear" wrote in message
...
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
--
Just a regular user

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

--
__________________________________
HTH

Bob

"Niek Otten" wrote in message
...
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

"Rockbear" wrote in message
...
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
--
Just a regular user

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
--
Just a regular user


"Mike H" wrote:

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

"Rockbear" wrote:

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
--
Just a regular user

Thanks, I know..
:)
--
Just a regular user


"Niek Otten" wrote:

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

"Rockbear" wrote in message
...
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
--
Just a regular user