Tech Support Guy banner
Cancel

Print Areas in Excel

962 Views 8 Replies 3 Participants Last post by  XL Guru, 
C
If I have a sheet in Excel and want to print out say a section in Row one and then a section in Row four, I know I can highlight the first area I want to print and then set the print area and then add to that print area but when it actually prints out it always prints on two pages. Is there anyway of forcing it to consolidate on to one page!? Or is there another method of being able to print two separate sections of a sheet on to one page......

Any ideas appreciated!
Save
Like
Status
Not open for further replies.
1 - 2 of 9 Posts
itsmeitsmeitsme
http://www.mrexcel.com/archive/Printing/22944a.html

This link will tell you how...although its a bit involved. I believe it was posted by dreamboat who is a very excel savy poster here at techguy. Hope this helps

EDIT: in the normal mode where it prints on 2 pages you can also print 2 pages on 1 sheet by going to File-page setup-options(layout tab) and click on the pages per sheet and put 2 in and both pages will print on 1 sheet
Save
Like
itsmeitsmeitsme
Guru, Glad to be able to help once in awhile. You have certainly helped me many times with excel questions.
Save
Like
1 - 2 of 9 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top