this thread is already posted on the other forum but i havent gotten any informative replies yet and time is tight so need to re-post this.

http://www.mrexcel.com/forum/showthread.php?t=595361


i have a file about 29K lines long, of which i only need to print the first 5 pages. how do i go about doing this in the page break preview? in there there's a lot more pages. i could go allllll the way to the end and just drag that up but that would be very time consuming.


EDIT - on the left of col A I see these plus signs, and at the top there's 3 columns labelled 1,2, and 3. When I click 2 I see the total by site, and THEN it fits on 5 pages. However this is actually more like 1 line from page 5, 1 line from pg 20 etc. So I need to print the relevant totals, and the Print Preview - Fit to 5 pages option wont work b/c that just cuts all 29K lines down to 5 pages and makes it too small to read.