Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Export to Word (XL2003)

    This post may belong in the GOS or Word forum...

    I have created a chart (cells B2:Q40) using Excel. It is very graphical. Using Excel, it is formatted to print perfectly on an 8.5 X 11 sheet of paper (landscaped). I need to export the chart to Word, where it will become one page of a 24 page document...

    What I've tried, so far:

    I've started by opening a blank Word doc, clicking on File|Page Setup...|Orientation|Landscape to turn the doc on its side. Then copying the selected cells and pasting it onto the blank doc. The result is that the selection consumes about 1 1/2 pages, with no way (that I can see) to reduce this down. Plus, this looks terrible as now there's cell outlines, etc. Just need the image.

    In Word,, I've tried Paste Special|Pictue|OK and then changed to landscape and this looks perfect. But, this doesn't work with the other 23 pages of the document. I can't seem to apply the landscape orientation to just the chart page; Word wants to turn all of the pages on their sides. <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>

    In the end, the chart would be on page 16 [just page 16] of a 24 page Word document. Either page 16 needs to be landscaped or the chart / image needs to be turned on it's side (vertically).
    - Ricky

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

    Re: Export to Word (XL2003)

    On page 16, select File | Page Setup, click Landscape and select 'This point forward' in the Apply to dropdown, then click OK.
    On page 17, select File | Page Setup, click Portrait and select 'This point forward' in the Apply to dropdown, then click OK.

    Alternatively, insert Next Page section breaks (Insert | Break) before and after the chart, then select the chart page and set page orientation to Landscape and select 'This point' in the Apply to dropdown, then click OK.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Export to Word (XL2003)

    If you want a landscape page within portrait pages:

    In word you can add a "next page section break" (insert - break unders "section break type": next page) and page 16 will become a new section.

    Then select the new page created and set it to landscape. (file - page setup - margins (tab) - orientation, make sure "apply to section" is selected). By creating a new section the setup can be different.

    You will have to insert another "next page section break" after this page and restore the remaining part of the document to portrait

    Steve

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Export to Word (XL2003)

    If you want to rotate the chart picture (if you have headers or footers on the page, you may want them all to be portrait), you could add the chart as a picture, then in the picture toolbar press the "rotate left" button.

    Steve

  5. #5
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Thank you

    Steve and Hans -

    Thanks for the solutions.

    <img src=/S/rant.gif border=0 alt=rant width=66 height=37>
    I know this is not the place but I'll feel better.... Working with a multi-page document in MS Word is maddening. There's probably a thousand reasons for the omission but how can there not be a simple Insert Page or Delete Page feature. One should be able to right click on any page and select Insert or Delete from the context menu. It can probably be accomplished with a very simple macro or 25-30 perfectly timed mouse clicks but what would be so terrible with Insert|Page?

    There; I do feel better.
    - Ricky

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

    Re: Thank you

    Ctrl+Enter inserts a page break.

    Since automatic page breaks shift continually as the user edits a document, inserting or deleting an entire "page" is not a very meaningful concept in most situations.

Posting Permissions

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