I have a list that I need to print. It is only 2 columns, but 12 pages long. I would like to print 4 or 6 pages, side by side on the same sheet. I tried changing the print setting to 4 pages per page. But, when I looked at the print preview, it showed only 1 page per page. Anyone have any ideas?
Did you try printing it?
Entia non sunt multiplicanda sine necessitate
I am using Excel 2007
OK.
Did you try printing it?
Yes, it printed 4 on a page.. But, I lost the size of the font. It is alot smaller. is there a way to make it print side by side, with the page(and the writing) in portrait alignment?
How could it print four pages per page and not be smaller?
If I could print 8 rows wide on 1 page, it would stay the same size
a1 a1 a1 a1
a1 a1 a1 a1
a1 a1 a1 a1
a1 a1 a1 a1
a1 a1 a1 a1
a1 a1 a1 a1
instead of
a1
a1
a1
a1
a1
a1
a1
a1
a1
a1
a1
a1
a1
Thats what I need
How about posting a workbook, so we're not all befuddled.
Here is a workbook. I whittled it down to 4 pages that I would like to try to print 2 pages per page. Both sheets printed vertically on a page side by side, in portrait, not in landscape mode.
If you print multiple pages per page, the font is going to scale.
To do what you want, I expect to need to duplicate the data on another sheet arranged as you like, and then print in the normal fashion.
Well, that kind of sucks... as I have to print things like this all the time.
Thanks for the help though.
Feel free to write a more clever program than Excel and share it.
I tried in the printer settings. Before printing go to Properties, Then choose "Finishing" You can select how many pages in a sheet viz., 1,2,4,6 etc.... It will work.Originally Posted by Befuddled
Hi. I have the same issue. I don't seem to have a finishing option in my printer settings. I did try an option for 2 pages per sheet, but it too printed very small leaving lots of white space (print preview didn't even display it that). It seems silly that I'm having trouble finding an answer to this problem as well. Maybe I need to use Word in a mail merge type thing...
ohno6345,
Please do not resurrect old threads. Further, do not post your question in the thread someone else has started - this is known as thread hijacking and is against the Forum Rules.
Always start your own thread and, if it helps to clarify your needs, provide a link back to other threads.
I suggest you take the time to read the Forum Rules so that you can avoid infractions that will impact your posting privileges.
Ben Van Johnson
For those looking for the answer to this question who came to this site like me or to Befuddled whose question wasn't really answered, here is the solution someone passed on to me. It's actually quite simple.
Copy data
Open Word
Paste data
Page Layout>Columns
Hope it helps.
Not helping...
I need that top title repeat also automatically..
The answer of rearrange within excel is better answer...
ghelo welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks