Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    insert some sheets from an Excel spreadsheet (2003)

    My Word document has page numbers in the footer and a table of contents, and I would like to include 2 of the sheets in one spot, and several others in another spot.
    The Excel sheet has a lot of formatting a protected cells (it is a form generated by someone else).

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: insert some sheets from an Excel spreadsheet (2003)

    Welcome to Woody's Lounge!

    Do you want the Excel sheets to be editable, or do you just want a "picture" of the sheets in your Word document?
    Should the inserted sheets be linked to the Excel workbook, so that if you edit the workbook, the changes will be reflected in the Word document?

  3. #3
    New Lounger
    Join Date
    Jul 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: insert some sheets from an Excel spreadsheet (2003)

    Just a picture is fine - no editing necessary in Word.
    I would link if possible, work around it if not.

    Thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: insert some sheets from an Excel spreadsheet (2003)

    OK - try the following.
    - Open the workbook in Excel and the document in Word.
    - Activate an Excel worksheet.
    - Select the range of cells that you'd like to see in the document; it shouldn't be too large to fit on a page.
    - Copy the cells to the clipboard (Edit | Copy or Ctrl+C).
    - Switch to Word.
    - Position the insertion point where you want to place the Excel data.
    - Select Edit | Paste Special...
    - Click the Paste Link radio button.
    - Select Picture from the list of available formats.
    - Click OK.
    - Repeat for the other ranges that you want to insert.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •