Results 1 to 5 of 5

print non-contiguous ranges

This is a discussion on print non-contiguous ranges within the Excel Questions forums, part of the Question Forums category; Any ideas on how to print non-contiguous ranges?...

  1. #1
    New Member
    Join Date
    Jan 2003
    Posts
    2

    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

    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

    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
    67,388

  5. #5
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default

    Andrew - WAY COOL!
    Barry-

    Photo Restoration/Enhancement

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


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