Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account

Submit your paper to J Biol Methods today!
Photo
- - - - -

change of columns into rows in EXCEL


  • Please log in to reply
3 replies to this topic

#1 Inmost sun

Inmost sun

    Veteran

  • Active Members
  • PipPipPipPipPipPipPipPipPipPip
  • 315 posts
60
Excellent

Posted 21 April 2012 - 06:18 AM

How do I change columns into rows in EXCEL?

#2 dpo

dpo

    Enthusiast

  • Active Members
  • PipPipPipPipPip
  • 89 posts
5
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

#3 Inmost sun

Inmost sun

    Veteran

  • Active Members
  • PipPipPipPipPipPipPipPipPipPip
  • 315 posts
60
Excellent

Posted 22 April 2012 - 12:02 AM

so simple, thank you!!!Posted Image

#4 newborn

newborn

    Enthusiast

  • Active Members
  • PipPipPipPipPip
  • 72 posts
2
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.




Home - About - Terms of Service - Privacy - Contact Us

©1999-2013 Protocol Online, All rights reserved.