How do I change columns into rows in EXCEL?
0
3 replies to this topic
#2
dpo
-
- Active Members
-
- 67 posts
Enthusiast
1
Neutral
Neutral
Posted 21 April 2012 - 06:32 AM
select the cells you want to change
copy
select the cell where you want to paste into
right click and select paste special
click 'Transpose'
click OK
copy
select the cell where you want to paste into
right click and select paste special
click 'Transpose'
click OK
#3
Inmost sun
-
- Active Members
-
- 286 posts
Veteran
59
Excellent
Excellent
Posted 22 April 2012 - 12:02 AM
so simple, thank you!!!
#4
newborn
-
- Active Members
-
- 64 posts
Enthusiast
2
Neutral
Neutral
Posted 24 April 2012 - 10:17 PM
I cant remember these tricks, so each time I have to search the above term in the Excel help and it works.
