Excel experts. Help!

Discussion in 'The Bar' started by HelloCleveland!, Dec 20, 2015.

  1. HelloCleveland!

    HelloCleveland! Well-Known Member VIP

    Reputations:
    37,646
    Joined:
    Jan 5, 2012
    Messages:
    7,127
    Likes Received:
    9,794
    I'm an Excel novice. I have a spreadsheet with 2249 rows x 4 columns of data.

    Even at 8 point text, printing all this out will take 39 pages.

    How can I print this out to create 2 columns on each sheet?
    For example: on sheet 1, rows 1-50 of the 4 columns will print on the left side, rows 51-100 of the 4 columns will print on the right side. Sheet 2 will have rows 101-150 on the left, 151-200 on the right. And so on...
     
  2. DrivenByDemons

    DrivenByDemons VIP Extreme Gold

    Reputations:
    40,685
    Joined:
    Sep 16, 2010
    Messages:
    76,895
    Likes Received:
    51,486
    Get some scissors and glue. Cut them out and glue side by side.
     
    banksy, Lemmy, Teeney and 2 others like this.
  3. HelloCleveland!

    HelloCleveland! Well-Known Member VIP

    Reputations:
    37,646
    Joined:
    Jan 5, 2012
    Messages:
    7,127
    Likes Received:
    9,794
    You ate paste, didn't you?
     
    Teeney likes this.
  4. walterHwhite

    walterHwhite Heisenberg

    Reputations:
    5,929
    Joined:
    Jun 29, 2014
    Messages:
    9,165
    Likes Received:
    5,979
    That's pretty easy
     
  5. Chief

    Chief I'm all sixes & sevens & nines Staff Member

    Reputations:
    64,811
    Joined:
    Sep 19, 2010
    Messages:
    50,268
    Likes Received:
    26,642
    It's been awhile since I've done any Excel formatting but i think you use the page layout tab and then selection pane to move your cells.
     
  6. DrivenByDemons

    DrivenByDemons VIP Extreme Gold

    Reputations:
    40,685
    Joined:
    Sep 16, 2010
    Messages:
    76,895
    Likes Received:
    51,486
    Yes :nojj:
     
  7. DarkFriday

    DarkFriday I'll take the NY Giants +3 Gold

    Reputations:
    559,310
    Joined:
    Jul 6, 2011
    Messages:
    216,141
    Likes Received:
    159,806
    [​IMG]
     
  8. PullMyFinger

    PullMyFinger Hors d'oeuvre Addict 2010 OG VIP

    Reputations:
    12,504
    Joined:
    Sep 28, 2010
    Messages:
    12,908
    Likes Received:
    1,722
    No idea how to do it on Excel, but check out a FinePrint. It lets you print up to 4 pages on one. Saves a ton of paper. I think they have a free trial version.
     
  9. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    83,662
    Joined:
    Jan 16, 2012
    Messages:
    34,965
    Likes Received:
    44,239
  10. BleedingGums

    BleedingGums Fesh Fox Faggot 2010 OG VIP

    Reputations:
    45,851
    Joined:
    Sep 21, 2010
    Messages:
    44,066
    Likes Received:
    8,181
    JPEG it
     
    Chriza and banksy like this.
  11. newcastlefan

    newcastlefan גֵּרְשֹׁם VIP Gold

    Reputations:
    74,499
    Joined:
    Dec 31, 2011
    Messages:
    77,039
    Likes Received:
    34,089
    it sounds like you have your page setup set to 132 columns instead of 80.
     
  12. banksy

    banksy My fav chil VIP

    Reputations:
    25,234
    Joined:
    Dec 14, 2011
    Messages:
    81,824
    Likes Received:
    11,744
    You're going to need some pliers and a set of 30 weight ball bearings.
     
  13. HelloCleveland!

    HelloCleveland! Well-Known Member VIP

    Reputations:
    37,646
    Joined:
    Jan 5, 2012
    Messages:
    7,127
    Likes Received:
    9,794
    You got it. I've got it prepared with some 3-in-one oil and gauze pads.
     
    O Face likes this.
  14. HelloCleveland!

    HelloCleveland! Well-Known Member VIP

    Reputations:
    37,646
    Joined:
    Jan 5, 2012
    Messages:
    7,127
    Likes Received:
    9,794
    Hey, thanks! Problem solved.
     
  15. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    83,662
    Joined:
    Jan 16, 2012
    Messages:
    34,965
    Likes Received:
    44,239
    :toptip:
     
  16. banksy

    banksy My fav chil VIP

    Reputations:
    25,234
    Joined:
    Dec 14, 2011
    Messages:
    81,824
    Likes Received:
    11,744
    [​IMG]
     
    O Face likes this.
  17. zhukov

    zhukov Time Traveler VIP

    Reputations:
    51,937
    Joined:
    Feb 6, 2011
    Messages:
    37,675
    Likes Received:
    21,280
    move the lower portions of the columns over to the right and fill the page that way.

    you should be able to get several sets of columns that way, which will decrease the number of pages.
     
    Last edited: Dec 22, 2015
    O Face likes this.
  18. HelloCleveland!

    HelloCleveland! Well-Known Member VIP

    Reputations:
    37,646
    Joined:
    Jan 5, 2012
    Messages:
    7,127
    Likes Received:
    9,794
    That would work if I just want to print without regard to formatting or future work in the spreadsheet. Moving the cells over will prevent me from still being able to sort the data as a whole.
     
  19. Gomez

    Gomez VIP Extreme Gold

    Reputations:
    13,589
    Joined:
    Dec 13, 2011
    Messages:
    24,031
    Likes Received:
    9,025
    SUM=B:46,X:627
     
  20. Tranquil

    Tranquil Decent! VIP Gold

    Reputations:
    54,595
    Joined:
    Jan 15, 2012
    Messages:
    27,577
    Likes Received:
    16,073
    Have you tried plotting to a PDF at 8.5x11 first? That way you can see for sure how the prints will turn out, then from that pdf if it worked right, just make your prints. That has worked for me in the past.

    Edit: make sure your settings are set to Print to Screen when you use 8.5x11 or whatever paper size you're using.