• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

MS Excel export to MS Word multiple worksheets

Hi,

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
0
WTC_Services
Asked:
WTC_Services
1 Solution
 
andrewssd3Commented:
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.
0
 
ScriptAddictCommented:
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!

-SA
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now