Hi there...
My experience with excel is limited, but I know I can easily search the forums or net for that information. My question is a bit beyond that..
This is my situation. My friend was just given a whole new slew of karaoke music. He also got the file for the "book" for people to find songs to sing. The file was in Microsoft Works. Which is not only ugly, but I have to go to an older computer to open the works file. I have Microsoft Office 2007 and I rather use that. Using works I converted the file into a file that opens in excel. There is only 2 columns. Songs and Artists. And about 15,000 rows. And I need to add in a bunch more.
Right now as a works file it prints two rows per page (artist, then song) and prints out on over 350 pages. What I want ideally is to print this list with 4 columns on each page so i can reduce the book by 1/2 the amount of pages needed. Now if this was indesign or quark design problems I wouldnt have issues. but this isn't.
What do I do from here. Can i set up excel to be able to lay this out this way? Is there a way to send this to word and format it that way??
I know I can save the file as a csv file and open that in word, but some of these songs and artists have commas in the names, so that just makes more columns.
And on top of that excel doesnt seem to have a feature that i can convert all the text to all caps. I could try to fix the problems individually, but like i said, there is 15,000 rows (15,000 songs to choose from).
Any idea how to get this format I want? And any way to make everything all caps?
I just wish I could bring this into indesign easily and figure out how to do this, but I am lost.
Bookmarks