+ Reply to Thread
Results 1 to 7 of 7

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.

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,155

    Re: Copy and paste from Vertical to Horizontal

    Using the functions supported using the 365 version of Excel this can be done by selecting cell A1 in the new sheet and entering: =TOROW(Sheet1!A1:A256)
    For more information please register and then start a new thread.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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