+ Reply to Thread
Results 1 to 3 of 3

Print a 15000 line list of 2 related columns in 4 columns per page.

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Print a 15000 line list of 2 related columns in 4 columns per page.

    Hi,

    Simple question.

    I have a 15,000-line list in two related columns (songs, singers). I want Excel to format this list in 4 columns per page, retaining the data sort of the list, so that I can send it to the printer.

    How do I do this without having to manually arrange the data in Excel?

    Because I update this list from time to time, rearranging the data manually is too time consuming, and it is subject to many errors.

    Jorge

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Print a 15000 line list of 2 related columns in 4 columns per page.

    How many lines do you want on a page?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Print a 15000 line list of 2 related columns in 4 columns per page.

    I have one line of print titles and 62 lines of text. There is no header and I have a one line footer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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