+ Reply to Thread
Results 1 to 3 of 3

How to print a selection to PDF

  1. #1
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    How to print a selection to PDF

    Hello I've attached a sheet. In this sheet I would like to print the selection....C9:17 and BL9:BW17. I would like to print it onto a PDF and I would like to expand it so it is very visible. Actually, it doesn't need to be PDF. If I could just print this selection and make it visible that would work. I had a problem using print selection because the columns are seperated. I also tried fit to page but that makes it too small. HELP!!!!

    Mod's note: file attachment removed at OP's request
    Last edited by FDibbins; 05-02-2013 at 08:42 PM.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to print a selection to PDF

    Using Excel 2010, I had to look for this as I had never done it but this is what I think will work.

    1.) Select the first range C9:C17.

    2.) Hold down the Ctrl Key and select the second range BL9:BW17.

    3.) Copy

    4.) Create a new sheet and paste. Your selections will be side by side. Save as PDF.

    The PDF options on the save dialogue has an area where you can select the Active Sheet or Selection. If you select "Selection" you don't need to paste onto a new sheet. So, you have the choice. Click OK assign a name and click Save.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to print a selection to PDF

    Why not just hide the unneeded columns?
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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