Results 1 to 5 of 5
  • Thread Tools
  1. 3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    213
    Thanks
    0
    Thanked 18 Times in 17 Posts
    Still using Office 2000 in our leading-edge Company!!

    A co-worker selected 2 non-contiguous ranges in an Excel sheet and wanted to print them both on the same page, but Excel insisted on putting them on 2 separate pages even with Fit to 1 page (wide and tall) selected. Is it possible to do this?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. 3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Re Office 2000: be careful what you wish for. <g>

    Excel prints selections on separate pages.
    Have your co-worker copy and paste the two selections on a separate sheet and print that sheet.
    '--
    Jim Cone
    Portland, Oregon USA
    Excel printing add-in - Special Print

  4. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,917
    Thanks
    11
    Thanked 275 Times in 269 Posts

  5. 5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Depending on the layout of the data, another possibility if the data is non-contiguous but in the same columns or rows might be ...
    "Rows to repeat at top" using first range
    "Columns to repeat at left" using first range

    Also, as indicated by Jim Cone above, if calculations are a problem in the paste, try a copy and "paste special" > "Values and number formats" of each section.

  6. 3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    302
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Consider adding a Custom View. It may require re-working the spreadsheet to do so, but once completed works great.

    Set hidden columns and/or rows. Set print range and other print settings, then select Custom View, give it a name and Add.

    Suggestion: When I use Views I create two views, one for viewing/printing the printable area and the other to re-set to the original condition.

Posting Permissions

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