MS Excel export to MS Word multiple worksheets

Posted on 2011-10-24
Last Modified: 2012-05-12

I have a carefully formatted Excel document consisting of multiple worksheets, each 1-3 pages in length. I am trying to export the entire excel document into MS Word so that the formatting is the same and some values can be edited without me losing the formulas in those cells in Excel.

Thanks! WTC Services
Question by:WTC_Services
    LVL 17

    Expert Comment

    I think you will need a VBA solution to this, unless you can get what you want by using simple copy and paste.  That often gives reasonable results, but it's never going to give you precise formatting.

    If you can post the Excel spreadsheet, that will give us something to work on.
    LVL 11

    Accepted Solution

    To be a little more specific,

    You will select one page at a time... and then copy in Excel.

    Then go to word if you right click you will see a list of possible import formats.  

    My personal favorite is link and use destination formating.  

    However if you want to move the actual Excel worksheet in you have to use the word insert table excel first to create an Excel Table in Word.  Then just copy and paste the sheets from Excel directly into Word.  This will retain any formulas or anything else since it is an embedded Excel worksheet.

    Hope that helps!


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now