Printing in Excel

I'm trying to print 2 long columns and have them print all on one page.

Example: Say you have 2 columns, 100 rows long (for instance, the names of 100 students, and by each name you have the student's grade). I want Excel to print all these on one page, in four two-column columns (if you see what I'm saying). I want the data to break after the first 25 names, then start at the top of the page to the right of the first section, instead of going to the next page.

Does anybody know how to do this? (Does it make any sense at all?)

Thanks in advance!

 

Simply drag and drop the column portions so they sit beside each other. Preferrably in a copy of the original spreadsheet.

Or preferably, create a second multi-column worksheet and link the cells to it, so a printable version is created.

What you want is for Excel to repaginate and realign cells but just for printing, but in doing so it would destroy cell relationships, so its not an inbuilt feature. It would actually be a nightmare for important spreadsheets if it was accidentally able to be done!

You can highlight different areas by holding down the CTRL key and therefore set multiple print areas, but as far as I know there is no way to get it to re-arrange these on 1 page.

 

This might be what you want.

1. Create a Word Document and Format it for the no of columns you want : Format/Columns/ specify how many columns - in your case this would be how many pairs of excel columns.

2. Copy your two columns from Excel and paste into the first column on your Word document.

This will wrap for you down then across the page.

 

Ha! I KNEW there was a workaround -- thanks Hew!

Thanks to Kiwi too -- I wrote a response last night, but it didn't post somehow ... I probably wasn't paying attention somewhere along the line ...