| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I change rows content to column & vice versa Excel spread s
Data is already spread in the Excel sheet.
|
|
#2
|
|||
|
|||
|
Hi
If you copy your range you can then select Edit|Paste Special|Transpose, which will tranpose your columns to rows and rows to columns. Make sure you take a copy before you start! Andy. "Harinath" wrote in message ... Data is already spread in the Excel sheet. |
|
#3
|
|||
|
|||
|
Note that you cannot paste to any range that overlaps the original in any
way. Paste to another range and then move or copy the data to where it needs to go. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Andy B" wrote in message ... Hi If you copy your range you can then select Edit|Paste Special|Transpose, which will tranpose your columns to rows and rows to columns. Make sure you take a copy before you start! Andy. "Harinath" wrote in message ... Data is already spread in the Excel sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| How do I change columns going from left to right to rows going up. | Excel Discussion (Misc queries) | |||
| Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
| Way to put multiple rows into the same column. | Excel Discussion (Misc queries) | |||
| How do I export comments into another excel column as cell content | Excel Worksheet Functions | |||
Hybrid Mode
