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.