#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 82
Default how

select column, copy, select destination cell, go to speacial paste select
"change column and row" and OK. This will change place of row and column.
Is this what are you looking for?


"Saeid" wrote in message
...
hi . How can I chang data that are in a column in rows to columns in one
row.


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 82
Default how

you are right.
"Roger Govier" wrote in message
...
Hi
"change column and row"

The option that shows when you choose Paste Special is Transpose

--
Regards

Roger Govier


"Rasoul Khoshravan" wrote in message
...
select column, copy, select destination cell, go to speacial paste select
"change column and row" and OK. This will change place of row and column.
Is this what are you looking for?


"Saeid" wrote in message
...
hi . How can I chang data that are in a column in rows to columns in one
row.





  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how

hi . How can I chang data that are in a column in rows to columns in one
row.


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default how

Hi
"change column and row"

The option that shows when you choose Paste Special is Transpose

--
Regards

Roger Govier


"Rasoul Khoshravan" wrote in message
...
select column, copy, select destination cell, go to speacial paste
select "change column and row" and OK. This will change place of row
and column.
Is this what are you looking for?


"Saeid" wrote in message
...
hi . How can I chang data that are in a column in rows to columns in
one row.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"