Results 1 to 3 of 3

Thread: How to keep the formatting as it is after copying content from Word to Excel

  1. #1
    Join Date
    Nov 2011
    Posts
    124

    How to keep the formatting as it is after copying content from Word to Excel

    I have got some text in Word 2003, formatted using Word's standard outline indent formatting. (This is a standard Word format, in which Word formats the text as a series of paragraphs (multi-line text), in hierarchical outline form. Each level is indented slightly from the previous level (for example, Level 1 is at left margin, Level 2 has 1/4 inch indent, Level 3 has 1/2 inch, Level 4 has 3/4 inch, etc.). Each paragraph starts with a bulllet, with a different bullet character for each level.). I would like to copy to Excel 2003 and look approximately the same. When I do this through simple copy-and-paste, Excel puts each paragraph into a cell. Indentation and bullet characters are retained.

    However, there is no word wrap - each paragraph is on a single line, extending possibly far to the right. When I then add word-wrap (Format / Cells / Alignment / Word Wrap), Excel retains the bullet characters, but loses the indentation. Everything is left-justified. I have confirmed that word wrap is not inconsistent with cell indent. I can take a word wrapped cell and indent it. So I could achieve the desired format if I manually add the indents for each cell, but that's obviously cumbersome. Is there any easier way. (I.e. Copy text from Word to Excel, retain word wrap, retain indent.)

  2. #2
    Join Date
    Jun 2011
    Posts
    487

    Re: How to keep the formatting as it is after copying content from Word to Excel

    There are two ways of pasting items on an excel spreadsheet. One is to put the data into the cells and another method is putting objects ontop of cells. I have taken section of word documents and placed them as object on top of the cells. I usually pasted them as enhanced Pictures.You can try two things here.
    • When you paste a black box with a clip board icon will appear. try options in this box
    • Use Paste Special (in edit Menu) instead of Paste. Try different options.

  3. #3
    Join Date
    Jun 2011
    Posts
    798

    Re: How to keep the formatting as it is after copying content from Word to Excel

    Basically under my experience with Excel, I had found that when copy paste the content from Microsoft Word to Excel then the formatting is loosed. Somehow it takes tables or list. There are some reference link I found below which you can see and check. There are some solution which might help you.

Similar Threads

  1. Replies: 3
    Last Post: 11-06-2012, 12:21 PM
  2. Copying tables from Word 2007 to Word 2003
    By mlsrinivas in forum MS Office Support
    Replies: 1
    Last Post: 18-04-2012, 03:18 PM
  3. Formatting MS Excel 2010 vs. Formatting MS Excel 2003
    By Dalajit in forum Windows Software
    Replies: 6
    Last Post: 12-08-2011, 10:19 PM
  4. Is copying content from yahoo answers to our website allowed?
    By Noell in forum Technology & Internet
    Replies: 3
    Last Post: 07-06-2011, 07:32 PM
  5. How to copy content from web page without formatting?
    By bharti_rajpal in forum Technology & Internet
    Replies: 5
    Last Post: 13-01-2010, 05:01 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
  •  
Page generated in 1,711,616,724.61545 seconds with 17 queries