+ Reply to Thread
Results 1 to 5 of 5

Print two (or more) worksheets to one page

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Print two (or more) worksheets to one page

    I have a set of 6 or 8 one page documents that need to have different formatting on the top half vs. the bottom half. Since I can change the width of a column halfway down the worksheet I am wondering if I could solve this by having the top of the page on sheet one, and be able to choose from the other 6 or 8 sheets to print on the bottom half. Is such a thing possible?

    Thanks,
    "Laugh? I thought I'd die!"

    Jimbo?

  2. #2
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Print two (or more) worksheets to one page

    Google "Linked Picture". I don't remember how to do it in Excel 2003, but in 2010 it is just a paste option.

    See the attached for an example.

    The added bonus is that you can make the formula for the linked image dynamic.
    Attached Files Attached Files
    Last edited by Whizbang; 09-22-2014 at 05:03 PM.

  3. #3
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: Print two (or more) worksheets to one page

    Well that is just slick!!

    Thank you very much!
    Love this forum!!

  4. #4
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: Print two (or more) worksheets to one page

    One other question: Can you lock the position of the picture once you've got it placed right? I don't want a user accidentally moving it once I have it all lined up correctly.

  5. #5
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Print two (or more) worksheets to one page

    Protect the sheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. filter 15 worksheets so i can print all on one page
    By kristie626 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  2. How to print 2 worksheets (different col/rows) on the same page
    By lindag in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  3. How to print 2 worksheets (different col/rows) on the same page
    By lindag in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. filter 15 worksheets so i can print all on one page
    By kristie626 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] filter 15 worksheets so i can print all on one page
    By kristie626 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1