Printing two columns in Excel

johnnymk · 12-01-2007, 07:36 AM

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 · 12-01-2007, 09:07 AM

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 · 12-01-2007, 12:32 PM

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 · 12-02-2007, 06:16 AM

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

ArkiStan · 12-02-2007, 11:49 AM

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 · 12-03-2007, 05:46 AM

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

johnnymk · 12-03-2007, 06:01 AM

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

Layla · 12-03-2007, 10:31 AM

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.

12-01-2007, 07:36 AM	#1
johnnymk Chief of Naval Operations Join Date: May 2000 Location: LEVITTOWN< PA> USA Posts: 13,621	Printing two columns in Excel 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.

12-01-2007, 12:32 PM	#3
Butch Rear Admiral Lower Half Join Date: Jun 2000 Location: New York, NY Posts: 2,915	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. __________________ I used to be into sadism, necrophilia and beastiality, but then I realized I was just beating a dead horse

12-03-2007, 10:31 AM	#8
Layla Lieutenant Junior Grade Join Date: Jul 2007 Location: Chula Vista Posts: 97	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. __________________ *2008 3-Day Walker!* *DC #45*

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

12-01-2007, 09:07 AM	#2
glagic Lieutenant Commander Join Date: Aug 2001 Location: UC Irvine Posts: 799	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

12-02-2007, 06:16 AM	#4
johnnymk Chief of Naval Operations Join Date: May 2000 Location: LEVITTOWN< PA> USA Posts: 13,621	Thanks, Butch, but I really don't want it to print out that way.

12-02-2007, 11:49 AM	#5
ArkiStan Admiral Join Date: May 2000 Location: Recession Central Posts: 5,898	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.

12-03-2007, 05:46 AM	#6
Jeffbx Fleet Admiral Join Date: Mar 2000 Location: Michigan Posts: 9,390	Have a copy of Access? Sounds like you need to import it there & create a custom report.

12-03-2007, 06:01 AM	#7
johnnymk Chief of Naval Operations Join Date: May 2000 Location: LEVITTOWN< PA> USA Posts: 13,621	No, and if I did I wouldn't have a clue how to use it. I am having enough trouble with Excel.

User Name
Password
Remember Me?