+ Reply to Thread
Results 1 to 6 of 6

Copy and paste from Vertical to Horizontal

  1. #1
    mardskee
    Guest

    Copy and paste from Vertical to Horizontal

    Does anyone know how to copy a vertical column from excel and paste it into
    a horizontal row? I have a sheet with column A 1-256 filled in and I want to
    copy and paste it into a new sheet using row 1 A-ZZ etc. Can this be done?



  2. #2
    Barb Reinhardt
    Guest

    Re: Copy and paste from Vertical to Horizontal

    Copy the cells that you want to transpose.
    Go to the location where you want to paste them.
    Edit -> Paste Special -> Transpose

    "mardskee" <amigo@elitemg.com> wrote in message
    news:%23ARhYm3GFHA.1476@TK2MSFTNGP09.phx.gbl...
    > Does anyone know how to copy a vertical column from excel and paste it
    > into a horizontal row? I have a sheet with column A 1-256 filled in and I
    > want to copy and paste it into a new sheet using row 1 A-ZZ etc. Can
    > this be done?
    >
    >




  3. #3
    Bill Kuunders
    Guest

    Re: Copy and paste from Vertical to Horizontal

    use copy,edit, paste special and tick "transpose"
    Regards
    Bill K

    "mardskee" <amigo@elitemg.com> wrote in message
    news:%23ARhYm3GFHA.1476@TK2MSFTNGP09.phx.gbl...
    > Does anyone know how to copy a vertical column from excel and paste it
    > into a horizontal row? I have a sheet with column A 1-256 filled in and I
    > want to copy and paste it into a new sheet using row 1 A-ZZ etc. Can
    > this be done?
    >
    >




  4. #4
    mardskee
    Guest

    Re: Copy and paste from Vertical to Horizontal

    Barb, it worked

    Thanks


    "Barb Reinhardt" <reply@tonewsgroup.com> wrote in message
    news:u9mghq3GFHA.588@TK2MSFTNGP15.phx.gbl...
    > Copy the cells that you want to transpose.
    > Go to the location where you want to paste them.
    > Edit -> Paste Special -> Transpose
    >
    > "mardskee" <amigo@elitemg.com> wrote in message
    > news:%23ARhYm3GFHA.1476@TK2MSFTNGP09.phx.gbl...
    >> Does anyone know how to copy a vertical column from excel and paste it
    >> into a horizontal row? I have a sheet with column A 1-256 filled in and I
    >> want to copy and paste it into a new sheet using row 1 A-ZZ etc. Can
    >> this be done?
    >>
    >>

    >
    >




  5. #5
    Registered User
    Join Date
    04-25-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Copy and paste from Vertical to Horizontal

    I used to know how to do this. But in excel 2010 i donīt get the same menu. How can I find the transpose option of PASTE?

    thank you!

  6. #6
    Registered User
    Join Date
    09-03-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Copy and paste from Vertical to Horizontal

    It worked for me as well - and the cells I was transposing had formulas in them. For it to work, the steps I performed:

    -Copy
    -Paste Special
    -click on Values, then
    -click Transpose

    It worked for me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1