Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inserting Excel data (2003)

    I need to insert Excel data into a Word document. It is wide, so I'd like to put it on its own page, in landscape format. How do I do this? THanks.

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

    Re: Inserting Excel data (2003)

    Select the Excel object (plus caption or whatever extra text you want to include).
    Select File | Page Setup...
    Select Landscape and make sure that Apply To is set to Selected Text, then click OK.
    Word will insert section breaks before and after the selected text, and set the selected text to landscape format, while the text before and after it remains in portrait format.

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting Excel data (2003)

    Worked fine, thanks. I will look this up in Help, but how does a "section break" fit into the scheme of things? I thought everything was "paragraph" oriented. I was looking all over the place for how to do that as a paragraph adjustment.

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Inserting Excel data (2003)

    Word stores things like margins, page size and orientation, headers and footers in sections. It wouldn't make much sense for these to be different for different paragraphs on the same page!

    StuartR

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inserting Excel data (2003)

    I had to redo the excel table, expanding it. Now, I cannot get the advice above to recreate the landscape presentation I earlier created. I followed the instructions, but the Excel cells now show as large, and entending over the page border, in portrait mode. Any ideas on how to correct this? Is it always this difficult or is it just a matter of doing it enough? Thanks.

  6. #6
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Inserting Excel data (2003)

    I think it is a matter of experience, I sometimes get this problem too but can usually correct it.

    Try completely deleting the Excel table, including the section breaks, and adding it back in again.

    StuartR

Posting Permissions

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