Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    England
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing multiple ranges on one page

    Is it possible in Excel 97 to print several selected ranges on the same page. Currently the ranges print on separate pages <img src=/S/question.gif border=0 width=15 height=15>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing multiple ranges on one page

    The only way that I know is to create anoter sheet with links to the cells arranged in the wat you want them printed in contiguous cells.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing multiple ranges on one page

    Another way is to 'paste pictures' of your dispersed ranges onto one sheet arranged in the way you want to see the printout. Check Excel Help for "Pictures" and check the topic titled: "Create a picture of cells and link it to the source data".

Posting Permissions

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