Printing in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

brykMantra

Thread Starter
Joined
Apr 8, 2004
Messages
36
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!
 
Joined
Aug 17, 2003
Messages
17,584
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.
 
Joined
Dec 9, 2003
Messages
563
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.
 

brykMantra

Thread Starter
Joined
Apr 8, 2004
Messages
36
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 ...
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top