+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : Copying multiple lines in each row

  1. #1
    Registered User
    Join Date
    01-07-2012
    Location
    Guwahati,India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Copying multiple lines in each row

    Hello Friends, I need to copy multiple lines of around 1000 in each row of excel sheet. Is there any easy and efficient method to do it so??? Please help out.

    Thanking in advance.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Copying multiple lines in each row

    Hello & Welcome to the Board,

    Not exactly sure what you are after, but if you were trying to copy row 1 to 1000 and you are asking a quick and easy way to select them...

    In the name box (right above column A) >> type in 1:1000 >> select enter
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    01-07-2012
    Location
    Guwahati,India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Copying multiple lines in each row

    Thanks Jeff.

    Actually I was trying to copy multiple lines (separate and properly indented) from a word document to an excel spreadsheet. Its not copying from excel to excel. I need to copy each line in each row i.e. row 1 in word to row 1 in excel, row 2 to row 2 and so on.
    Hope you could get it.

  4. #4
    Registered User
    Join Date
    01-07-2012
    Location
    Guwahati,India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Copying multiple lines in each row

    Thanks Jeff.

    Actually I was trying to copy multiple lines (separate and properly indented) from a word document to an excel spreadsheet. Its not copying from excel to excel. I need to copy each line in each row i.e. row 1 in word to row 1 in excel, row 2 to row 2 and so on.
    Hope you could get it.

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Copying multiple lines in each row

    I don't have any experience with transferring data from Word to Excel but you might get some hits if you either search this forum or a google search.

    I'm out of the door right now but I will check back later. This is another reason why thread titles and OP should be clear as to your intentions because if so I would have let those who are more suited to answer this query...

  6. #6
    Registered User
    Join Date
    01-07-2012
    Location
    Guwahati,India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Copying multiple lines in each row

    Anyway Jeff thanks for your kind reply. I will have to search more then I guess.

  7. #7
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,310

    Re: Copying multiple lines in each row

    I've done this with simple documents by saving the Word doc as a text file and then importing it into Excel.

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Copying multiple lines in each row

    What happens when you just copy and paste?
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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