How can I make Excel wrap successive columns on a page?

Question

I have the newest version of Microsoft Excel. It does wonders, but I would like to run a very long, narrow stream of data (2-3 columns). Two streams would easily fit side-by-side on a page. How can I set up Excel so that it will print to the bottom of the page, go back up to the right side of the page and continue down? The stream would continue down the left side of the next page. This would reduce my paper needs in half!

Answer 1

I'm not 100% sure what you're asking for, but this may help. Go to page setup, then go to the sheet tab. At the bottom, there's the page order option. The default is Down, then over. Change it to Over, then down.

Answer 2

Hey, I assume you're using Excel 2007... Select the first column that contains artist's name and press at the same time CTRL+1. It will open a menu that allows you to format the whole column. Go to Alignment tab and in the Text control section and check mark "Wrap text". The problem is you can't have 2 columns with the same name and you need column header to sort the list alphabetically. So you should have .. Artist in the first column and Artist1 in the third one. Same for Song.. Then select Custom sort from Home menu, Editing Tab and choose Sort by artist from A to Z then by Artist1 from A to Z. Hope it helps. C.

Answer 3

You can export it to MS Word using trial and error various text format (tab delimited, fixed spacing), set Word to 2 columns display and print from Word itself.



Anyway it is unnecessary. You can print it to PDF and let users decide if they want to search using text search or if they really want to print them and waste papers.