+ Reply to Thread
Results 1 to 5 of 5

Paste horizontal text from outside application to vertical text Excel 2010 (transpose)

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    10

    Paste horizontal text from outside application to vertical text Excel 2010 (transpose)

    Hello all,
    I am attempting to paste a string of horizontal text vertically into Excel 2010. I have tried several things.
    When I simply paste it is horizontal text. When I paste special to try and transpose , that option does not appear.
    When I ctrl+c the horizontal text I pasted and then I do get the transpose option, it does not change the text to vertical.
    Please help.

    Thanks


    sean.rooney@nypa.gov

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Paste horizontal text from outside application to vertical text Excel 2010 (transpose)

    Hi Sean,

    If your string is in one cell then all you need to do is to Format cells, Alignment and change Orientation 90 degrees (+/-).
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    04-08-2014
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Paste horizontal text from outside application to vertical text Excel 2010 (transpose)

    AlKey, The string is a string of numbers. And when I rotate 90 degrees the text is sideways and unreadable.

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Paste horizontal text from outside application to vertical text Excel 2010 (transpose)

    Maybe you not clearly explaining your problem.

    Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  5. #5
    Registered User
    Join Date
    04-08-2014
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Paste horizontal text from outside application to vertical text Excel 2010 (transpose)

    AlKey,
    I cannot upload that at the moment. However, let me explain further and in more detail.
    I am copying and pasting from a PDF document into excel.
    The string is vertical in PDF but pastes horizontal in Excel.
    I need it vertical.
    I have tried to transpose after pasting but it just stays horizontal.
    I cannot transpose before pasting as that option does not appear.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel macro to transpose horizontal data to vertical
    By LittleFry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2016, 05:54 AM
  2. [SOLVED] How to change horizontal text lines into vertical ?
    By christianbber in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2012, 08:37 AM
  3. Transpose horizontal data to vertical data with paste link
    By M.Devadhasan in forum Excel General
    Replies: 0
    Last Post: 07-07-2012, 01:01 PM
  4. Replies: 0
    Last Post: 07-29-2011, 07:19 AM
  5. vertical text to horizontal and vice versa
    By ghadir14 in forum Excel General
    Replies: 3
    Last Post: 03-19-2008, 04:57 PM

Tags for this Thread

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