How do I insert ALL sheets of an Excel workbook into Word at once.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to insert an Excel document into Word as a linked worksheet object,
but rather than inserting just the active sheet I'd like to insert all of the
sheets in the workbook, so that they appear sequentially in the Word
document. Is there a quick way of inserting all of the sheets or do I have to
insert each one as a separate object?
 
Hi

There's no way to do this automatically. Furthermore, Word can't display
more than one page of an inserted or pasted Excel file at one time. So you'd
have to do each page of the Excel file at a time.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007 Import Excel spreadsheet from Workbook 1
How do I insert a whole Excel workbook into a Word document? 3
Insert PowerPoint file into Word 1
automatically insert table into lots of separate word documents 1
Inserting excel spreadsheet into word - problems 3
How to insert multiple page word document into word 2007? 8
Insert Word Document Thumbnail into document 1
Inserting a PDF file into Word 2007 0

Back
Top