Printing two columns in Excel

[johnnymk]

I have a ist of Karaoke songs I want to print. There are 24,000 entries with the Artist, Title of Song, Company and Disc number and Song number. (5 cells per entry).

Excel shows single column printing at approx. 550 pages, which is way too many. I know a Karaoke DJ who has the same list at half the pages but dual columns.

I have the font size and column width for each cell at the minimum size possible. I have tried going to Page Setup, then Sheet and typing in A1:E1 in the upper space, then A2:A52 in the space below it for 50 entries per column. I changed the margins to allow the maximum information for each page. And I checked Over and Down for the repeat pattern.

I cannot get a second column to show up in Print Review, and there seems to be enough room for a second column.

Any tips? I believe it's Excel 2002.

[glagic]

you could always set it to print 2 pages on a single sheet. thats the only thing i can think of. should be in your printer options when you do ctrl+p

[Butch]

Why not just C&P the data in rows 12001 - 24000 in columns G - L starting at row 1, then set the page to print 1 page wide?

This won't be ideal, since you'll have "A"s and "N"s on the same page, but at least you get your columns.

[johnnymk]

Thanks, Butch, but I really don't want it to print out that way.

[ArkiStan]

Excel is really an enigma of a program for me. It's one of those programs that I always use, but I can never take seriously enough to really learn in depth. I'm curious to know the answer to your question as well, johnnymk.

[Jeffbx]

Have a copy of Access? Sounds like you need to import it there & create a custom report.

[johnnymk]

No, and if I did I wouldn't have a clue how to use it. I am having enough trouble with Excel.

[Layla]

I fiddled around in Excel for quite a while and couldn't figure it out. Then I went to Google. There's are lots of people with the same problem. The only solution I really found was to copy and paste into Word with a page setup with columns.