print non-contiguous ranges

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: print non-contiguous ranges

  1. #1
    New Member
    Join Date
    Jan 2003
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Any ideas on how to print non-contiguous ranges?

  2. #2
    Board Regular indiantrix's Avatar
    Join Date
    Oct 2002
    Location
    Philadelphia 'Burbs
    Posts
    943
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    First select the non-contig ranges by dragging range1, then holding your control key down and dragging range2, then range3... etc., until all non-contiguous ranges are selected. Then File/Print Area/Set Print Area will "lock in" your selection until you choose to clear it.
    This process will print each range on a separate sheet. I have not been successful in printing them all on a single sheet, but someone here will undoubtedly offer a solution. Cheers!
    /s/ Larry

  3. #3
    Board Regular indiantrix's Avatar
    Join Date
    Oct 2002
    Location
    Philadelphia 'Burbs
    Posts
    943
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Accidental double post...oops!
    /s/ Larry

    [ This Message was edited by: indiantrix on 2003-01-18 11:27 ]

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  5. #5
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Andrew - WAY COOL!
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com